• Formatting
  • About Cell Formatting
  • Conditional Formatting
  • Adjusting Cell Height
  • Adjusting Cell Width
  • Aligning a Column of Cells
  • Aligning Numbers and Text in a Cell
  • Capitalizing Cell Contents
  • Changing a Cell's Font
  • Changing a Cell's Type
  • Changing The Separator for Date Cells
  • Creating a User Defined Underline
  • Defining Cell Options Globally
  • Distributing Cell Contents Evenly
  • Formatting The Appearance of Negative Values
  • Formatting The Appearance of Positive Values
  • Formatting The Appearance of Zero Values
  • Printing a Currency Sign Inside a Cell
  • Separating Large Currency Values with a Comma
  • Shading a Cell
  • Shading a Column of Cells in Form Mode
  • Shading Multiple Cells
  • Underlining a Cell
  • Underlining The Currency Symbol

Shading Multiple Cells

1. Select the column(s) of cells by holding Alt and dragging over the cells. To add additional cells outside of the block, click on the individual cells while holding Ctrl. The cell color changes to show that they have been selected.

2. On the Home tab, click Cell, and then click Formatting.

3. In the Type list, select a pattern for the shading.
4. In the Color list, select a color for the shading. To create a custom color, select Other from the drop-down and create a customized color.
5. Select any other shading options, such as shading currency signs or brackets.

6. Click OK.

Related Topics

• About Cell Formatting