"jpmurray22" wrote in message
...
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.

Thanks for replying. When i do it it wraps the text to the narrow cell
boundaries
but I would like to wrap to the right boundary of the page.
Sorry I'm new to this and may be not explaining well.


Row1 contains Cell1 Cell2 Cell3 ...... Cell10 | edge of page
Row2 contains Long sentence of text all in Cell1 going right across page and
beyond right boundary of page
Row3 contains Cell1 Cell2 Cell3 ...... Cell10 | edge of page

In Row2 there is nothing in Cell2 ... Cell 10.

When I print out the long sentence gets cut off the right of the page.

David