• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing a Worksheet with Ex... > Adding Color and Patterns to Cells

Adding Color and Patterns to Cells

Colors and patterns added to the worksheet's light gray grid help identify data and streamline entering and reading data. If your data spans many columns and rows, color every other row light yellow to help readers follow the data. Or add a red dot pattern to cells with totals. Color adds background shading to a cell. Patterns add dots or lines to a cell in any color you choose. You can use the Format Cells dialog box to add color and patterns to a worksheet. However, if you want to add color to cells quickly, you can use the Fill Color button on the Formatting toolbar.

Apply Color and Patterns

Select a cell or range to which you want to apply colors and patterns.

Click the Format menu, and then click Cells.

Click the Patterns tab.

To add shading to the cell, click a color in the palette.

To add a pattern to the cell, click the Pattern list arrow, and then click a pattern and color in the palette.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint