Automatically delete blank rows
Apply a filter to the first column (DataFilterAutofilter), 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)
"Tinkerbell1178" wrote in message
...
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?
|