On Feb 6, 1:33 pm, 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

I think this is simpler than a macro...you can use it for multiple
things..


Insert a column to the left of the data
Type a number 1 to the left of the data on the first row (in the new column)
Fill the column with consectuve numbers using data fill (highlight first row and second row-the blank row,
and then drag the little box in the botton of the area highlighted to
the end of the sheet).
This will product a column of consecutive numbers but on alternating
rows.
Sort the data (including the new column)
The blank rows will all be in the same area of the sheet
delete the blank rows
delete the new column
This will insure that your data is in the same order as previously.

Hope this helps....