Most valuable professional
  • Excel Book Excerpt

Excel Transform Black-and-White Spreadsheets to Color by Using a Table

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Transform Black-and-White
Spreadsheets to Color by Using a Table

Problem: My worksheet is boring black and white. I want to jazz it up with color.

Strategy: Format the range as a Table. Use the Table Styles gallery to format the spreadsheet. Here’s how you do it:

1. Select one cell in your range of data. Press Ctrl+T or select Insert, Table icon.

2. Excel asks to confirm the location of your table and indicate if there are headers. Click OK.


Figure 1145 Accept the table range.

3. A new Table Tools Design ribbon tab appears. Use the Table Styles gallery, in conjunction with the Table Style Options check boxes to format your table.


Figure 1146 Choose a color scheme from the gallery.

Additional Details: The gallery shows variations on six color schemes. To use new color schemes, you can choose a new theme from the Page Layout tab of the ribbon.

Additional Details: Creating a table enables many new and powerful features. If those features annoy you, then use the Convert to Range button on the Design ribbon. Excel will convert the data from a table to a regular range, but the formatting will remain.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: