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

How to paste this down? 3
Visio shape text disappears upon copy paste 1
Text cut off in Text Box. (Not a quantity issue) 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Cut-off lines 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Print preview not same a printed spreadsheet 0
Merged cells/wrap text 1

Top