Customizing Excel 2007's Fill Handle

One of Excel's more useful "Auto" features is being able to Auto Fill using the fill handle.

What it does is allow you to easily add preset lists of data to a spreadsheet, such as the months of the year and the days of the week.

To increase the usefulness of Auto Fill, you can add your own custom lists. If you frequently add a series of department titles or people's names to your spreadsheets you can create a custom list and then use Auto Fill to add the names when you need them.

To find out how easy it is to do this, read the quick tip on Customizing Excel 2007's Fill Handle.

Related Articles

• Adding Data with the Fill Handle
• Copy Formulas with the Fill Handle