Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
As mentioned in an earlier tip, AutoFormat affects every aspect of formatting a table. This includes all the number, font, border, position, and row and column settings necessary to change the entire look of your table. You might not, however, want AutoFormat to change every aspect of the formatting.
In these situations, you should click on the Options button when the AutoFormat dialog box is displayed. You will then see an enlarged version of the AutoFormat dialog box. If you click your mouse on the Options button again, the original (smaller) AutoFormat dialog box will reappear. (See Figure 1.)
Figure 1. The expanded version of the AutoFormat dialog box.
When the expanded dialog box is visible, Excel includes formatting options at the bottom of the dialog box. Every option that has its check box selected will be modified by AutoFormat. If you do not want AutoFormat to change a particular formatting attribute, clear the check box beside that attribute. When you later click your mouse on OK, only those attributes you have specified will be modified.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2137) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!