Delete Blank Lines

T

Templar

I have a hunch this should not be so difficult, but I have reviewed all the
HELP stuff and am unable to locate how to delete the blank lines from an
Excell spreadsheet.
Very annoying doing the deletiona manually with Control -. Thanks.
 
G

Gord Dibben

Select a column within the range that has blank cells.

F5>Special>Blanks>OK

Edit>Delete>Entire Row.

If you are thinking of deleting all the unused blank rows below your data
range, this cannot be done.

Those you hide.


Gord Dibben MS Excel MVP
 
Top