On Feb 25, 6:47*pm, GS wrote:
It happens that GARY formulated :





On Feb 25, 5:53 pm, GARY wrote:
On Feb 25, 5:07 pm, GS wrote:

GARY formulated on Friday :

When I print my spreadsheet, the cells with one line prints OK. But,
if the cells have more than one line, the first line is OK but the
subsequent line(s) are cut-off.

How do resolve this problem

This is probably a RowHeight issue where the Print_Area is 'fit'
between the margins. Anything that won't fit hides below the cell
border.

--
Garry

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

The lines that are cutoff are INSIDE the cells, not at the margins of
the spreadsheet.- Hide quoted text -

- Show quoted text -

Hi Garry,

I guess I don't understand what you mean by "Print_Area".

Is that the same as the "Print Area" on the "Page Layout" tab in the
"Page Setup" group?

I've clicked on "Clear Print Area" but that didn't resolve the problem.

The Print_Area is determined by Excel when you print or view
PrintPreview. It's based on the UsedRange of the wks, and how it's
'fitted' between the margins. If it doesn't fit between margins then
the rightmost cells will print on another page.

The problem ISN'T the defined Print_Area. It's a result of the printed
RowHeight not being sufficient to display all the contents of
multi-line cells. Try changing to a smaller font OR set wider margins
to see the effects as compared to what you see with the printout now.
Pay particular attention to 1 specific cell that has its contents cut
off, then play with the font size OR margins to see what changes occur
in that 1 cell.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

To avoid the line(s) in the cells from being "cut off", I had to
MANUALLY set the row heights as follows:

cells with one line - 15 pixels
cells with two lines - 36 pixels
cells with three lines - 66 pixels
cells with four lines - 74 pixels

It's a very tedious process to adjust the row height for each row.

Doesn't Excel have a feature that adjusts the row heights
AUTOMATICALLY?

If AutoFit Row Height doesn't do this, what good is AutoFit Row Height?