Sorry, I thought you were trying to shade columns - the technique works for
rows too by holding ctrl. Follow the same instructions but replace 'column'
with row.

"ewan7279" wrote:

Hi,

You are correct. Click the first of the columns you wish to shade, hold
control and select the other columns one by one. With all required columns
selected, right click the mouse and select Format Cells, Patterns, select the
colour to shade with and click OK.

Ewan.

"sweeps" wrote:

I am trying to add shading to every other row. I thought if I held CTRL and
clicked on the the columns then I could add shading to the columns all at
once but this is not working. Any help is appreciated.