View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?