Here's our Microsoft Office Tip for.. January 28, 2002
Click Here to see a complete list of all of our previously released Tips!
Using AutoFormat
We've talked quite a bit about different Excel formatting options. Well, here's a quick way to format data using the AutoFormat feature. This feature offers a number of predefined formatting schemes. You simply apply one of these schemes to your data and Excel does all the work. Neat, huh?

Before you can choose a format, you must identify the data you want to format. You can do so by selecting any cell within the spreadsheet or by selecting the entire range of data. After you've identified the data, choose Format, AutoFormat. Select one of the 17 predefined formatting schemes. Then, click OK to apply the selected scheme and return to your worksheet.

If you don't like the results, simply click the Undo button on the Standard toolbar.