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 Problems with merged cells

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

On Tue, 6 Apr 2010 17:11:01 -0700, Emma
wrote:

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