Skip to main content.

 

Spreadsheets in Microsoft Excel 2003

Formatting Cells: Apply Shading < Previous


The Pattern tab allows you to apply colors and patterns to the selected cell(s). This tab offers the following options for color and patterns:

Color Select the color to be applied as shading.
Pattern Select the pattern to be applied as shading.
Sample Preview the settings you make.

To apply colors and patterns:

Format Cells

  1. Select the cell(s) to configure.
  2. Select Format located on the menu bar.
  3. Choose Cells.
  4. Click on the Patterns tab.
  5. Select a color of cell shading.
  6. Choose the down arrow button to display different pattern styles.
  7. Select a pattern.
  8. Click OK.

Patterns Window


EXCEL EXTRAS

You can also use the Fill Color icon Fill Icon on the Formatting toolbar to shade cells.