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.

Machinist60 expressed precisely :
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.

What is the purpose of the blank rows? If used for spacing I normally
use row height for that so I have contiguous data with manual page
breaks. The problem with text wrap is that if you do anything to the
cells you lose your row heights to whatever Excel determines they be
after the sheet is updated. Absolute PITA, so if anyone has a solution
I'd be very interested (and grateful)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

The exact nature of the problem is unclear to me.
When data is sorted, blanks are sorted to the bottom by default and sorting certainly doesn't create
new blank rows.
Could those "blank" rows actually contain something that isn't visible: maybe "".

VBA code to delete blank rows is readily available in these newsgroups/internet.
'---
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
editorial review of special sort add-in (30 ways to sort)




"Machinist60"
wrote in message
...
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.