ExcelBanter - Delete Blank Lines

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete Blank Lines (https://www.excelbanter.com/excel-discussion-misc-queries/214693-delete-blank-lines.html)

Delete Blank Lines

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

Delete Blank Lines

Select a column within the range that has blank cells.

F5SpecialBlanksOK

EditDeleteEntire 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

On Fri, 26 Dec 2008 12:11:01 -0800, Templar
wrote:

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.