How do I select all even or odd rows in Excel
Hi Mclain
One way,
In a blank column put 0 in the first cell and 1 in the second
Highlight both cells grab the fill handle and drag down
as far as is needed, hold ctrl and let go of the left button.
You can then use Autofilter to select 0 or 1.
HTH
Martin
"mmcclain" wrote in message
...
In a large file, is it possible to select all even or odd rows quickly?
|