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
 

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

Similar Threads

Merged cells/wrap text 1
word wrap & pasted text 4
Text Cutting Off When Printing 1
Merged cell text does not wrap 1
Wrap text "disappears" 3
Wrap text is tempermental within a single cell 2
Expanding Capabilities of Wrap Text in a cell 1
How do I get the a large amount of text to show in merged cell? 2

Top