Excel isn't really designed as a "What you see is what you get" program. It
has a number of idiosyncracies, especially with AutoFit and column widths.

Usually I find that I can either get the print layout as I want it, or the
screen layout as I want it but not both.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Betsy" wrote:

I have a problem with a worksheet that needs to "look good" both in print and
when displayed in Excel. Many of the cells contain text. The problem is that
the line breaks seems to be different on-screen vs. in print. That is, some
cells require only one line when printed, but on the display they wrap to 2
lines. Does anyone know why this is? And what I can do to make the on-screen
display "match" the printed output?

I'm not using AutoFit for the row height. I need some white space between
the rows, so I'm manually setting the row height.

Thanks,

Betsy