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
|