Custom Lists By default Excel contains some built-in lists that can be used for auto-filling cells when you drag a pointer. You can type 1 in a cell and 2 in the cell below. If you select the two cells you can then drag then pointer down while holding down the left mouse button Excel will add numbers in sequence, one for every cell you highlight.
Days of the week and months can also be auto filled in thanks to the built in lists.
You can also customize lists based on your own specific needs. Let’s say you have a set list of items your company produces and you seem to need to add them to your worksheets on a regular basis. Just as with the number example above you can create your own custom list.
In 2007 – From the Office Button select Excel Options