Delete Blank Lines

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

 

[ward376]

see:
http://www.ozgrid.com/VBA/VBACode.htm

Cliff Edwards

 

[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