"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Cool Formatting In Four Clicks


I'm sure you are aware that Excel allows you to format your worksheets with an almost endless assortment of fonts, colors, borders, and patterns. You probably have created spreadsheets where you spent more time on formatting than you did on the basic data input and formulas.

Fortunately, Excel has a cool option when you want a great looking reports but don't have time to mess with all that formatting. And it only takes four clicks.

  1. Select a cell within the table you want to format
  2. From the Format menu select AutoFormat...
  3. Choose one of the predefined formats.
  4. Click OK (If you don't like the result, click Edit, Undo (or CTRL+Z)and try again)
The Options button in the AutoFormat dialog box allows you to choose any combination of Number, Font, Alignment, Borders, Patterns or Width/Height formats from that particular AutoFormat.

AutoFormat may not always be the answer to your formatting needs, especially with more complicated tables. But for basic data tables in Excel, AutoFormat can give you some pretty cool results in a flash.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.