View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jpmurray22 jpmurray22 is offline
external usenet poster
 
Posts: 6
Default Wrapping text at end of page, and cells widths different when prin

I am not sure about the 2nd question, but for your first problem with the
wrapping just highlight the cells that you would like to wrap the text than
click on: format - cells- allignment tab- than check the box that says wrap
text.

"david" wrote:

1/ I have a few cells with long text in them, which is longer than the
width of the page when I print out. How can I get the text to wrap at the
right side of the page?

2/ Also when I print out, the cell widths come out a little different from
on the screen. E.g. if I have two cells adjacent on the same row, one with
the word "green" in one and the next with the word "yellow". On the screen
the "n" at the end of green might be just overlapping the "y" at the start
of yellow, but when I print out there is a gap between the "n" and the "y".
It makes it difficult to know how wide to make cells on the screen because I
don't know how wide they will appear on the paper until I printout. Have
experimented with fonts Arial and Times New Roman and same thing happens
with both, so I assume nothing to do with fonts. Is there an easy way round
this?

Thanks for any advice

David