Welcome toExcel2007.Tips.Net
Cooking Tips
Gardening Tips
Home Tips
Pet Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
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.