HOW TO SELECT EVERY OTHER LINE IN A WORKBOOK AUTOMATICALLY
 

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

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

Hi,

Use Conditional Formatting.

Select the first (topmost) row you want to highlight;

"Format" (in the Toolbar) -- "Conditional Formatting" -- select "Formula
Is" and in the formula bar enter
=MOD(ROW(),2)=0 (if that row is an even-numbered row), or
=MOD(ROW(),2)=1 (if that row is an odd-numbered row)
Click the "Format" button, and select "Patterns" and select the shading color,
Click "OK".
Now fill-in the formula in the rows below.

Regards,
B. R. Ramachandran




"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