View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Deleting every other row?

I would insert a new column A into the worksheet.

Then select A1:A25000
And type this formula (with a1 the active cell)
=MOD(ROW(),2)
But hit ctrl-enter to enter the formula in all the selected cells.

Then with A1:A25000 still selected
edit|copy
edit|paste special|values

Sort all the data by that column.

And delete the 12500 rows you don't want--either 0's or 1's in those cells.

Then delete column A.

The Joe wrote:

I have a 25000 line spreadhseet and I need to delete every other row of it.
Is there a way to do so without manually deleting every row (12500 lines!!!).
Thanks


--

Dave Peterson