Applying an AutoFormat

With Excel's AutoFormat feature you can apply a combination of formats to different elements of your workbook. Preview the many possible combinations of patterns, borders, fonts, colors, and alignment settings in the AutoFormat dialog box.

To apply an AutoFormat:

1. Select the text or data you want to format.
2. Click AutoFormat… on the Format menu.
3. Scroll the list of options.
4. Click the layout you want to apply; then click OK.

Click the Options... button to customize the AutoFormat layouts. Deselecting a checkbox will change the preview in the list.