Show All

Apply or remove automatic formatting on a range of cells

1. Select the range you want to format or remove the autoformat from.
2. On the Format menu, click AutoFormat.
3. Do one of the following:

   Apply an autoformat    Click the format you want.

   Remove an autoformat    At the bottom of the list, click the format above None.

Note  If you want to use only selected parts of a format when autoformatting or removing an autoformat, click Options, and then clear the check boxes for the formats you don't want to apply. When you remove an autoformat for the font, the font specified in the General tab of the Excel Options dialog box will be used.