Microsoft KB Archive/263557

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

Article ID: 263557

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q263557



IN THIS TASK
SUMMARY
 * Use Selected Parts of AutoFormat
 * What Is AutoFormat?

REFERENCES



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

