How to Use Autofill in Excel 2007

1. Position the cursor in the first cell of the series and type in the data. For our example using days of the week, type 'Monday' into the first cell and press 'Enter' on your keyboard.
2. Click on the cell and move your mouse so that the pointer is positioned over the small black box in the lower right corner of the cell. The pointer will change from a white cross to a black cross when you have it positioned correctly.
3. Use your mouse to drag the black cross, known as the AutoFill handle, across the range of cells which you wish to fill with the rest of the series.
4. Release your mouse button and AutoFill will complete the rest of the data entry in the series. In our example, if you were to drag the AutoFill handle across 6 more cells, it would fill in the days of the week - Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday.
5. Make your own custom AutoFill series by clicking the Office button, clicking on 'Excel Options,' and then selecting the 'Popular' tab. Click on the 'Edit Custom Lists' button, then 'Add.' Type your custom list into the 'List Entries' text box. Click 'OK' twice to finish.