cut/paste text into cells (wrap text)

J

JoBeth

I have 3 large paragraphs that I'm pasting into a large cell. I have
formatted the cell for 'wrap text' and although all my text appears in the
preview pane in the tool bar, on the worksheet it cuts off & does not appear
either in print preview or print.

How do I get all the text to show & where the heck is it??
 
G

Gord Dibben

JoBeth

You can enter 32767 characters in a cell but Excel will display or print only
1024 of these.

A workaround is to add an Alt + ENTER linefeed every 100 or so characters.

Or paste the text into a TextBox


Gord Dibben MS Excel MVP
 
Top