Hide/Delete all Empty Rows in Excell

[anonymous8472]

How do I do this? I have over 800 lines and I cannot select and hide each one, would take hours!!!

 

[fred]

in column A, make a filter. then filter to select to show only "Blank" cell in column A.


"Go to special" select "visible cells". hi-light the rows. right click, select "delete row".


Go back to filter, "select all". Wah-la! all empty rows are gone.

 

[anonymous8472]

Ta-da!!!!! Awesome..thanks fred!

 

[Luke M]

Taking Fred's idea a little faster

Select Range of interest (eg, A1:A1000)

Ctrl+G (goto dialogue)

Special, blank cells

Hold Ctrl and hit the "-" symbol.

Select "delete entire rows"


I've noticed that if you try to delete rows while a filter is active, it can take a long time.

 

[anonymous8472]

ah....that could work too...no I didn't have any problem deleting rows with Fred's method..