Row height overlap in Print and Print Preview

B

Bion

I recently upgraded to Mac OS 10.3.4 and Office 2004. I have some
Excel sheets with wrapped text in one column. They look fine in the
normal and page layout views, but when I go to print preview or print
them the last line in some of the text cells is partially or
completely obscured by the top of the cell in the row below. Not all
rows have the problem. If I go into the sheet and manually change the
row height for each row I can get all the text to show, but some of
the sheets are several pages long, so that's not a very good solution.
 
J

JE McGimpsey

I recently upgraded to Mac OS 10.3.4 and Office 2004. I have some
Excel sheets with wrapped text in one column. They look fine in the
normal and page layout views, but when I go to print preview or print
them the last line in some of the text cells is partially or
completely obscured by the top of the cell in the row below. Not all
rows have the problem. If I go into the sheet and manually change the
row height for each row I can get all the text to show, but some of
the sheets are several pages long, so that's not a very good solution.


Have you chosen your printer driver in the Print dialog?

Font metrics may differ from printer to printer, and from the Generic
printer driver.
 
B

Bion

JE McGimpsey said:
Have you chosen your printer driver in the Print dialog?

Font metrics may differ from printer to printer, and from the Generic
printer driver.

Yes. I even updated the firmware on the newest printer and
reinstalled the print driver just to be safe. I still have the same
problem. It looks the same whether I use the Generic driver or the
Xerox 6250 or the old HP6MP.
 
B

Bion

JE McGimpsey said:
Have you chosen your printer driver in the Print dialog?

Font metrics may differ from printer to printer, and from the Generic
printer driver.

I'm sending this before my privious post hits the board because 1) I
have some additional, possibly relevant, information and 2) the matter
is getting more complicated from a personal standpoint. My wife, an
accomplished Windows Excel user, has suggested that the problem only
happens when I start fooling with the margins. I have about 2 inches
of header text on the top of each page, and, instead of allowing for
it on the initial sheet layout, I have just been going into print
preview and pulling the top margin down so the data rows do not
overlap the header (I also usually fool around with the side margins
to make the pagination come out the way I want it). She says this is
when the problem starts happening if she duplicates it on her iMac.
Now she's working on a $50,000 solution to my $5 problem. Help!
 
B

Bion

I'm sending this before my privious post hits the board because 1) I
have some additional, possibly relevant, information and 2) the matter
is getting more complicated from a personal standpoint. My wife, an
accomplished Windows Excel user, has suggested that the problem only
happens when I start fooling with the margins. I have about 2 inches
of header text on the top of each page, and, instead of allowing for
it on the initial sheet layout, I have just been going into print
preview and pulling the top margin down so the data rows do not
overlap the header (I also usually fool around with the side margins
to make the pagination come out the way I want it). She says this is
when the problem starts happening if she duplicates it on her iMac.
Now she's working on a $50,000 solution to my $5 problem. Help!

I have not tried this on a large sheet yet, but, after messing around
with a small test page, it appears that if I change the print quality
setting from "high" to "normal" the problem goes away. Is there some
explanation for that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top