I have a work sheet 4 columns by 1200+ rows, all text set to upper left of
the cell with wrap. This is to be printed, about 25 pages. Many rows have
blank lines using valuable print space. Auto row height does not remove
these.

How do I remove these blank lines other than manually, a gigantic pain as
this sheet is often sorted and they reappear again.

Help appreciated.

John.