Lines cut off

[GARY]

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

 

[GS]

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.

 

[GARY]

GARY formulated on Friday :



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.

 

[GS]

GARY pretended :

The lines that are cutoff are INSIDE the cells, not at the margins of
the spreadsheet.

Doesn't matter where the cells are. What DOES matter is the Print_Area
is being forced to 'fit' between the margins. Thus, the available space
for existing RowHeight may become insufficient to display all cell
contents.

 

[GARY]

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.

 

[GS]

It happens that GARY formulated :

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.

 

[GARY]

It happens that GARY formulated :










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?

 

[GS]

GARY pretended :

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 looks like you're using a fairly large font size. With Arial 9 my
RowHeight settings are:

1 line: 15
2 lines: 30
3 lines: 45
4 lines: 60

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?

Yep, it's annoying! What's more annoying is trying to find where the
UsedRange displays what PrintPreview displays, preference being the
latter shows what you see in the wks.

What can help (sometimes) is to store a macro in PERSONAL.XLS that
autofits the selection, and run it when needed.

Example:
Sub Autofit_SelectedCells()
Dim c As Range
For Each c In Selection
Rows(c.Row).AutoFit
Next
End Sub

 

[GS]

My previous reply assumes WrapText is already turned on. Otherwise,
revise as follows:

Sub Autofit_SelectedCells()
Dim c As Range
For Each c In Selection
c.WrapText = True: Rows(c.Row).AutoFit
Next
End Sub