One of the best kept secrets in Excel is the amazing 'Fill Handle' for data entry purposes. Watch this video, the link will take you to a screen demonstration with me talking in the background: Excel Fill Handle Video
I would type it all out, but it would be a page long and the video is only one minute long.