HOW TO: Use Only Selected Parts of AutoFormat in Excel 2000

This step-by-step article describes how to use only selected parts of an AutoFormat.

You can also find this information in more detail in Microsoft Excel 2000 Help. For more information, please see the REFERENCES section later in this article.

Use Selected Parts of AutoFormat

To use only selected parts of an AutoFormat, follow these steps:

1. Select the range that you want to format.
2. On the Format menu, click AutoFormat.
3. Click the format that you want.
4. Click Options, and then click to clear the check boxes for the formats that you do not want to apply.

What Is AutoFormat?

You can use the AutoFormat feature to format an entire list or other large range that has distinct elements, for example, column and row labels, summary totals, and detail data. The design that you choose then applies distinctive formats for the various elements in the range.

For more information about AutoFormat, click Microsoft Excel Help on the Help menu, type autoformat in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.