HOW TO SELECT EVERY OTHER LINE IN A WORKBOOK AUTOMATICALLY

R

Rachel

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
 
M

Myrna Larson

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.
 
B

B. R.Ramachandran

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
 
Top