Excel Tips – How to Quickly fill a series of values?

Excel  2007

Use the AutoFill feature. It inserts a series of values or text items in a range of cells.

Drag the AutoFill handle (the small box at the lower right of the Active cell) to copy the cell or automatically complete the series

You can create your own list by adding a ‘Custom List’. To add a Custom List click <Office Button> à <Excel options> à <Popular> à <Edit Custom Lists..> and select the [Custom List tab]. In the [List entries] list box, type out your list entries separated by enter.