Problems with merged cells

[Emma]

I have merged a fair few cells so that I can enter paragraphs, once I type
past a certain point it wont bring up everything I have entered in the cell,
it cuts half of it off & it wont print it either, but when i click on the
cell all the information is there......can anyone help me out with this???

 

[Gord Dibben]

Since limits on a lot of features are version-dependent it is always best if
you state which version of Excel you are using.

In Excel 2003 and earlier you can place 32767 characters in a cell.

However, only 1024 of these will be visible in the cell or can be printed.

Merging cells only gives you one large cell with the same limits as a
regular cell.

Add an Alt + Enter every 100 or so characters to increase this limit in
2003.

2007 version gives you same 32767 chars but more visible
characters........around 8000, I believe.

For large amounts of text you should be using a TextBox or Word.


Gord Dibben MS Excel MVP