I recently printed a report, only to discover that there were two lines of data in one cell. On one printer, the report only printed the first line. On a second printer, it printed both lines. On a third printer it overtyped the second line over the contents of the cell below. The first case is of highest concern, since I could be losing data (horizontally and vertically) without getting any warning.

[Reply or follow-up to this message]

You are vague about exactly what you're talking about. It sounds like you need to fix the formatting of whatever this cell is. If you were using Word you could do a Print Preview and see what that shows. Also, you could make a change and print only the page involved until you see the formatting is fixed.

Bob Sturtevant  http://home.adelphia.net/~bobstur/
Please let us know what works.

On Fri, 8 Jun, 2001 - 6:43, art janiger wrote:

I recently printed a report, only to discover that there were
two lines of data in  one cell. On one printer, the report only
printed the first line. On a second printer, it printed both
lines. On a third printer it overtyped the second line over the
contents of the cell below. The first case is of highest
concern, since I could be losing data (horizontally  and
vertically) without getting any warning.

[Reply or follow-up to this message]

On Fri, 8 Jun, 2001 - 8:02, Bobstur wrote:
>You are vague about exactly what you're talking about. It sounds like you need to
>fix the formatting of whatever this cell is. If you were using Word you could do
>a Print Preview and see what that shows. Also, you could make a change and print
>only the page involved until you see the formatting is fixed.
>

Bob Sturtevant 
> http://home.adelphia.net/~bobstur/
>

>Please let us know what works.

>
>

On Fri, 8 Jun, 2001 - 6:43, art janiger wrote:
>

>I recently printed a report, only to discover that there were
>two lines of data in  one cell. On one printer, the report only
>printed the first line. On a second printer, it printed both
>lines. On a third printer it overtyped the second line over the
>contents of the cell below. The first case is of highest
>concern, since I could be losing data (horizontally  and
>vertically) without getting any warning.
>

Bob, thanx for the response. I'm not sure how to clarify my question, but here goes: The application is excel 2000. I have several cells which have hard returns (alt-enter) Print preview shows me that I have the first line, but It does not highlight the fact that the second line is being cut off because my row height is not high enough. Further, when I print it on another printer I get the second line overtyped on top of the cell beneath. Since it is another printer, print preview is not showing the effects of a printer that it does not know about. Bottom line: it is very possible for me to not be printing all my data and me not knowing this. And going thru each cell and looking at the formula bar is tedious.

[Reply or follow-up to this message]

I just tried a little experimenting with Excel and I get the picture. It seems to me that mostly what I see in the spreadsheet is what I get. If I decrease a row height too much I lose one of the lines in that cell.

About all I can think of is to increase all your row heights, but I gather that's a PITA. I would imagine that different printers handle cut off lines differently but I would think that all the printers would be OK with no cut off lines.

Not much help...

Bob Sturtevant  http://home.adelphia.net/~bobstur/
Please let us know what works.

On Fri, 8 Jun, 2001 - 12:50, art janiger wrote:

Bob,

thanx for the response.

I'm not sure how to clarify my question, but here goes:

The application is excel 2000. I have several cells which have
hard returns (alt-enter)  Print preview shows me that I have
the first line, but It does not highlight the fact that the
second line is being cut off because  my row height is not high
enough. Further, when I print it on another printer I get the
second line overtyped on top of the cell beneath. Since it is
another printer, print preview is not showing the effects of a
printer that it does not know about.

Bottom line: it is very possible for me to not be printing all
my data and me not  knowing this. And going thru each cell and
looking at the formula bar is tedious.

[Reply or follow-up to this message]

Oh, you asked how can you tell what cells are cutoff.

It looks like you can compare a cell with the edit bar and quickly see if the cell is showing less rows.

Bob Sturtevant  http://home.adelphia.net/~bobstur/
Please let us know what works.

[Reply or follow-up to this message]

Highlight all rows of the report, by dragging your cursor down the left-hand index column (the one with the row numbers)
Now double click on the join between any two rows. All rows should open wide enough to reveal all contents, including wrapped text.

Paul D

On Fri, 8 Jun, 2001 - 6:43, art janiger wrote:
>I recently printed a report, only to discover that there were two lines of data in
>one cell.
>On one printer, the report only printed the first line.
>On a second printer, it printed both lines.
>On a third printer it overtyped the second line over the contents of the cell below.
>The first case is of highest concern, since I could be losing data (horizontally
>and vertically) without getting any warning.

[Reply or follow-up to this message]

• Search this forum
• Start a new thread on a different subject

• Report abuse of the forum