Quick Tip: How to Auto Fill a Column (or Row) with Information in Excel
http://www.access2learn.com/
This quick (less than 2 minute) tutorial shows you how to quickly repeat cells of information. This will work for entered information, as well as formulas!
2 easy ways shown, depending upon which makes the most sense for you.
Using this little trick will make you look like a power user