View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default cut/paste text into cells (wrap text)

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

On Fri, 11 Jul 2008 15:24:01 -0700, JoBeth
wrote:

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??