You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import.

Warnings If you're filling a column with dates generated by an Excel function, AutoFill won't work in situations in which you want each cell to reference one specific cell location.

How to Fill Colors in a List in Excel. With Microsoft Excel, you can simplify data entry by adding a drop-down list to a cell, allowing users to pick an option from the list instead of entering data.

One Excel feature that will save you time is Autofill, which can generate a series of dates for your worksheets.

My copy of Excel (XP) occassionally won't display the "short cut menu" when you drag a series to "autofill" it. (I.E. the date)Since it doesn't appear (sometimes), I can't choose to fill in only ...