View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default Select every other Row to copy/cut????

I do this with a helper column. In the helper column, I enter

=mod(row(),2)

The result is wither 0 or 1. Autofilter the data and delete either 0 or 1
(whatever you want). Keep in mind that when you delete the data, it will
recalculate. Remove the autofilter and the helper column and VIOLA (I know
I spelled it wrong), you're done.

"Too much data - Too little time" <Too much data - Too little
wrote in message
...
How do I select every other row on a large Excel Document?