Try conditional formatting. Select the entire range to be affected (all rows,
not just alternate rows), then Format/Conditional and select Formula Is in the
first box and type =MOD(ROW(),2)=0 and set the format for the shaded rows.
That will do even numbered rows. If you want odd numbered, change the final 0
to 1.
On Wed, 5 Oct 2005 13:54:06 -0700, Rachel
wrote:
I need to select every other row to highlight them. If there is a way to do
it
more quickly than holding down the control key and selecting every other
line that would be very helpful
|