Tips, Tricks, and Answers

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

AutoFilling from a Custom List 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

AutoFilling with the Alphabet Creating your own custom word search puzzles in Excel can present you with an interesting problem: how to fill a range of empty cells with letters of the alphabet. It turns out that there are several different ways you can accomplish the task, as this tip details. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

AutoFilling with Weekdays You can easily use Excel’s AutoFill feature to place the days of the week in a range of cells. With a small change in how you use the feature, you can also fill the range with only the weekdays Monday through Friday. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Fast AutoFill Want to fill a long column with predictive data? It’s easy to do by using AutoFill and a double-click of the mouse. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Quick AutoFill Variations The AutoFill feature of Excel can be very handy. Most people are not aware that there are a number of ways you can use the feature, and all those methods are only a right-click away. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Turning Off AutoFill AutoFill can be a great timesaver when adding information to a worksheet. Even so, some users may not want the feature to be available, so Excel provides a way to turn it off. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)