Formatting Data with AutoFormat

Formatting worksheet data can be a lot of fun but also very intensive . To make formatting data more efficient, Excel includes 18 AutoFormats. An AutoFormat includes a combination of fill colors and patterns, numeric formats, font attributes, borders, and font colors that are professionally designed to enhance your worksheets. If you don't select any cells before choosing the AutoFormat command, Excel will "guess" which data it should format.

Apply an AutoFormat

Select a cell or range to which you want to apply an AutoFormat, or skip this step if you want Excel to "guess" which cells to format.

Click the Format menu, and then click AutoFormat.

Click an AutoFormat in the list.

Click Options.

Select one or more Formats To Apply check boxes to turn a feature on or off.

Click OK.

Did You Know?

You can copy cell formats with Format Painter . Select the cell or range whose formatting you want to copy, double-click the Format Painter button on the Standard toolbar, select the cells you want to format, and then click the Format Painter button.