Merged cells/wrap text

D

Daniela

Entering long amounts of text into merged cells and have chosen the wrap text
option. However part of my text is being cut off, even if I manually resize
the cell it still gets cut off - any idea why?
 
A

Andrea Jones

Excel will only display the first 1024 characters that are entered in a cell,
although it actually stores up to 32,767 characters entered in the cell. If
you want to annotate your spreadsheet with a large block of text then it is
better to place a text box on the spreadsheet and use that.

Andrea Jones
www.stratatraining.co.uk
www.allaboutoffice.co.uk
 

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 control row height and text wrap in non-merged cell ??? 2
Wrap text in merged cells VBA 2
some text shows in merged cells but not all 2
Cell Size Issue 1
Wrapping Text in Merged Cells - Excel 2002 3
Excel 2007: Word wrapping in merged cells 2
merged cells and wrap text 3
Getting word wrap to work in a merged cell 1

Top