How to add shading to more than one column at a time?

[sweeps]

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.

 

[Faz]

I can't understand why this isn't working for you. You do use ctrl hel
whilst clicking on all the rows you need, you can let go of ctrl if yo
need to scroll down, though make sure you're holding it before clickin
another row. Once you have all rows selected, right click on any of th
highlighted cells and format as you would

 

[ewan7279]

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.

 

[ewan7279]

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.