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