Following the direction of other posts.....

Try something like this:

A1: 1
A2: (blank)

Select A1:A2
Click and HOLD on the drag handle (black box in the lower right corner)
Drag down as far as you need (eg through cell A100).
(That will create a range of alternating numbers and blanks)

While A1:A100 is still selected....
Press [F5]..a shortcut for <edit<go to
Click [Special]
Check: Blanks
Click [OK]

The even (blank) cells with be selected.

or...
Check: Constants
Click [OK]
to select the non-blank cells.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Ron Coderre" wrote in message ...
I think if you describe what you utlimately want to do with those rows, we can probably suggest a solution that will work for you.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"mmcclain" wrote in message ...
In a large file, is it possible to select all even or odd rows quickly?