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

SUMMARY

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.

back to the top

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.

back to the top

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.

back to the top