The order of celestial bodies from smallest to largest can be broken down into four distinct categories: stars, planets, moons, and asteroids.
Stars are the smallest celestial body of all, ranging in size from 0.5 to 150 solar masses. The smallest stars are red dwarfs, which are typically just a few times more massive than the planet Jupiter. The largest stars, known as supergiants, can be up to 150 times larger than the Sun.
Planets are the second-smallest celestial body, with sizes ranging from as small as Mercury to up to 17 times the mass of Jupiter. The smallest planets are of the terrestrial variety, such as Mercury, Venus, and Earth. The largest planets are gas giants, such as Jupiter, Saturn, Uranus, and Neptune.
Moons are the third-smallest celestial body, with sizes ranging from a few kilometers in diameter to up to one-third the diameter of the Earth. The smallest moons are in orbit around the planet Mercury, while the largest moons are in orbit around the planet Jupiter.
Asteroids are the fourth-smallest celestial body, with sizes ranging from a few meters in diameter to up to about 900 kilometers in diameter. The smallest asteroids are known as meteroids, while the largest asteroids are known as dwarf planets.
In summary, the order of celestial bodies from smallest to largest is stars, planets, moons, and asteroids. Stars are typically the smallest, with sizes ranging from 0.5 to 150 solar masses, while asteroids are typically the largest, with sizes ranging from a few meters to up to 900 kilometers in diameter.