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

Article translations Article translations
Article ID: 263557 - View products that this article applies to.
This article was previously published under Q263557
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page


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.


Article ID: 263557 - Last Review: October 20, 2013 - Revision: 3.0
  • Microsoft Excel 2000 Standard Edition
kbnosurvey kbarchive kbhowtomaster KB263557

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from