How do I select all even or odd rows in Excel
Maybe add an extra column with two values (0,1) for odd and even rows by
entering 0,1,0,1 down the column. Extend the selection by selecting the first
few values and double-clicking the fill handle (in the bottom right corner of
the selection).
Now you can use DataFilterAutofilter to select 0,1 to show alternate rows.
"mmcclain" wrote:
In a large file, is it possible to select all even or odd rows quickly?
|