Modifying AutoFormat in Excel

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 97 and other Software topics.

Can I modify the AutoFormat tool?

Modifying AutoFormat in Excel

While some of the formats provided with AutoFormat in Excel 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.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Heidi Splete