Read Excel Tips Such As How To Transform Black And White Spreadsheets Into Color At BrightHub.com

Read Excel Tips Such As How To Transform Black And White Spreadsheets Into Color At BrightHub.com
Page content

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

Images

Fig. 1046

Fig. 1047

Fig. 1048