Tips.Net > ExcelTips Home > Tools > AutoFormat
Tips, Tricks, and Answers
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Placing Limits on AutoFormat The AutoFormat tool is a great way to quickly change the appearance of a data table. Usually AutoFormat changes all the formatting in a table, but you might not want this to happen. Fortunately you can modify exactly what AutoFormat affects by following the simple guidance in this tip. Microsoft Excel versions: 97 2000 2002 2003
Undoing an AutoFormat Excel allows you to automatically format data tables using a number of different schemes. What happens if you want to undo this type of formatting? There are a couple of ways you can remove the formatting, each with their own “gottchas.” Microsoft Excel versions: 97 2000 2002 2003
Fast Answers!
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Great Info!
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)