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

This article was previously published under Q263557
This article has been archived. It is offered "as is" and will no longer be updated.
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
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.

back to the top
XL2000 AskMaxwell

Article ID: 263557 - Last Review: 10/20/2013 20:53:36 - Revision: 3.0

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kbhowtomaster KB263557