Thread: HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
sandman832
 
Posts: n/a
Default HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET
Gord, that's amazing! I used the Select column - F5 routine and immediately
removed over 1600 blank lines from a huge spreadsheet. Thanks so much!
--
zzzzzzz


"Gord Dibben" wrote:

DataFilterAutofilter to filter for blanks.

OR Select a column and F5SpecialBlanksOK

EditDeleteEntire Row.


Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 07:40:35 -0800, sandman832
wrote:



Reply With QuoteReply With Quote