Hi Fiona

You could use Conditional formatting.
Mark the range you want to formatFormatConditional Formattinguse dropdown
to select Formula is=MOD(ROW(),5)=0Choose a Format you wantOK

--
Regards
Roger Govier

"Fiona" wrote in message
...
Hi
I wondered if there was any way I caould shade certain lines in a document
automatically?

I want to shade every 5th row , on the whole document.

I hoped there may be a quicker way than going through the worksheet
manually.

Many thanks