Excel and Office RAQ

Shading every other line in Excel


Tactical solutions

Research projects

Microsoft Office

Multiple choice guessing


Knowledge measurement audit

Item bank services

Item design course








Technical articles

Excel and Office RAQ

Free Excel Add-in

Free PowerPoint Add-in


Home page

Q: In Excel I have a large table of data I print out regularly. I would like to have every other row shaded like on old printout paper to make it easier to read along lines. I've tried doing it manually but when I move data around it spoils the shading. Is there an easy way to do this which won't get messed up when I move data.

A: Yes, there is. I use it all the time. You need to select the whole worksheet, then from the 'Format' menu, select 'Conditional Formatting'.

Change the pulldown which reads 'Cell value is' so it reads 'Formula is' and then enter this formula in the empty field:


Next, hit the 'Format' button and on the 'patterns' tab choose a colour. The lighter ones on the bottom row of the palette work best.

Back to other RAQ topics