Skip to main content.

Apply Shading



The Fill tab on the Format Cells dialog box allows you to apply colors and patterns to the selected cell(s). This tab offers the following options for color and patterns:

To apply colors and patterns:

  1. Navigate to the Home Tab/Font Group pull down arrow. Font Group
  2. The Format Cells dialog box will appear.
  3. Click on the Patterns tab.
    • Select a color of cell shading.
    • Choose the down arrow button to display different pattern styles.’
    • Select a pattern.
    • Select a pattern color.
  4. Click OK.

Fill Window

EXCEL EXTRAS

You can also use the Fill Color icon Fill Icon on Home Tab/Font Group to shade cells.

Fill Bucket Icon Drop Down Menu