remove blank records (row) in worksheet

S

sahusir

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.
 
E

excelent

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


"sahusir" skrev:
 
G

Gord Dibben

F5>Special>Blanks>OK

Edit>Delete>Shift up or Entire Row


Gord Dibben MS Excel MVP
 
Top