Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.
While some of the formats provided with AutoFormat are useful, they might not be quite what you need. A good example of this is where you want to apply all of the formatting, but leave the font as it is.
To modify this, click on Options from the autoformat dialog box (Format, AutoFormat) and deselect the font option. Any of the other aspects of AutoFormat can be selected and deselected in this manner.