Pin Me

Microsoft Excel: Transform Black And White Spreadsheets Into Color

written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011

Problem: Your worksheet is boring black and white, as shown in Fig. 1045. You want to jazz it up with color.

  • 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

  • slide 2 of 2


    Fig. 1045Fig. 1046Fig. 1047Fig. 1048