ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merged cells/wrap text (https://www.excelbanter.com/excel-discussion-misc-queries/188892-merged-cells-wrap-text.html)

Daniela

Merged cells/wrap text
 
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?

Andrea Jones

Merged cells/wrap text
 
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

"Daniela" wrote:

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?



All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com