View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Can you only merge up to a certain number of cells

From "Excel Specifications and Limits"
Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


Due to merged cells causing more trouble usually than they're worth, is
there some reason you can't just break the text up over multiple cells, or
type it all into a single cell, and then use the "Align center over
selection" format?

--
Best Regards,

Luke M
"Sue" wrote in message
...
I am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it
only
prints up to line 20...I have checked to make sure there are not locked
cells
etc. I cannot figure out at all why this is happening...is there only up
to
a certain number of cells you can merge?