Thread: Automatically delete blank rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Automatically delete blank rows

Select a column and F5SpecialBlanksOK.

EditDeleteEntire Row.


Gord Dibben MS Excel MVP
On Tue, 29 May 2007 00:32:11 -0700, Tinkerbell1178
wrote:

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?

Reply With QuoteReply With Quote