Shading Multiple Cells
-
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.
-
On the Home tab, click Cell, and then click Formatting.
- In the Type list, select a pattern for the shading.
- 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.
- Select any other shading options, such as shading currency signs or brackets.
-
Click OK.
