excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Cooking Tips
Gardening Tips
Home Tips
Pet Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

AutoFill

Tips, Tricks, and Answers

The following articles are available for the 'AutoFill' topic. Click the article's title (shown in bold) to see the associated article.

Creating and Using Custom Lists
AutoFill can be a real timesaver if you often work with set lists of data. You can define your own custom lists and then use them over and over again, as described here.

Disabling the AutoFill Feature
AutoFill is a great editing tool that comes in particularly handy when you are first creating a worksheet. You may, at some point, want to turn off the feature. This tip shows how you can do this.

Importing Custom Lists from a Worksheet
Custom lists are handy ways to enter recurring data in a worksheet. Here's how you can import your own custom lists from a range of cells.