Yes, with conditional formatting.
Select the entire rows in your used range (I wouldn't select the entire worksheet). Then go to
Format/Conditional. Assuming A1 is the active cell, select Formula Is in the first box, and type
=MOD(ROW(A1),2)=0 and apply the shaded format you want. That will shade even rows. If you want
to shade odd rows, change =0 to =1.
Is there a way to automatically format worksheets so that every other line is shaded; like in a
checkbook register?
