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
Select the Popular tab and then click on the Edit Custom Lists button.
Just type your list in the List entries window then click the add button. Your list will then display in the Custom Lists window. When done click the OK button.
How can you use custom lists to make your daily job a bit easier?