Automatically delete blank rows

T

Tinkerbell1178

I need to delete every second row in my spreadsheet - the rows are blank.
There are 30,000 rows so I don't want to do it manually - is there an easy
way to delete every second (or every blank) row?
 
B

Bob Phillips

Apply a filter to the first column (Data>Filter>Autofilter), and then filter
it by a value of Blanks, then select all the rows where the row number is
blue, and delete them. Remove the filter and voila.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Gord Dibben

Select a column and F5>Special>Blanks>OK.

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
Top