AutoFormat

Excel's AutoFormat feature offers a quick way to dress up tabular data in worksheets by applying predefined formats. If you're like me and like to leave design for designers, you'll welcome this feature.

To use AutoFormat

1.
Select the portion of the worksheet you want to format (Figure 80).
Figure 80. Select the part of the worksheet you want to format.

2.
Choose Format > AutoFormat (Figure 8) to display the AutoFormat dialog (Figure 81).
Figure 81. The AutoFormat dialog.

3.
Choose a format from the Table format scrolling list. A preview ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.