remove blank records (row) in worksheet
 

Large number of records with many blank records (row) are there. I want to
remove all blank records from it. I dont want to sort it. just squeeze it,
means removal of blank records.

remove blank records (row) in worksheet
 

hit F5
select Special
mark Blanks
ok
rightklick on 1 selected cells
select move cells up
ok


"sahusir" skrev:

Large number of records with many blank records (row) are there. I want to
remove all blank records from it. I dont want to sort it. just squeeze it,
means removal of blank records.

remove blank records (row) in worksheet
 

F5SpecialBlanksOK

EditDeleteShift up or Entire Row


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 08:33:02 -0700, sahusir
wrote:

Large number of records with many blank records (row) are there. I want to
remove all blank records from it. I dont want to sort it. just squeeze it,
means removal of blank records.