View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 272
Default 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?