- slide 1 of 2
Strategy: Use a predefined AutoFormat.
1) Select your range of data. From the menu, select Format – AutoFormat. As shown in Fig. 1046, choose a style.
2) Choose the Options button. As shown in Fig. 1047, in the options section of the dialog, you can choose whether the format should apply to everything or, perhaps, everything except borders.
Result: Your worksheet is formatted in just a few clicks, as shown in Fig. 1048.
Summary: The AutoFormat dialog offers many built-in formats to quickly transform a black and white spreadsheet to something neatly formatted.
Commands Discussed: Format – AutoFormat