Can you only merge up to a certain number of cells

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?

0
Utf
5/19/2010 7:30:01 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
672 Views

Similar Articles

[PageSpeed] 24

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" <Sue@discussions.microsoft.com> wrote in message 
news:E790D085-6FF8-4822-BEC8-D6CD889F9E77@microsoft.com...
>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?
> 


0
Luke
5/19/2010 7:35:41 PM
Why have you bothered to merge cells?

All that does is create a larger cell with the same limitations as a single
cell.

See Like's post on limitaions for visible characters.

You can increase this limitation by adding an in-cell linefeed every 100 or
so characters.

Linefeeds are entered using Alt + Enter key.


Gord Dibben  MS Excel MVP

On Wed, 19 May 2010 12:30:01 -0700, Sue <Sue@discussions.microsoft.com>
wrote:

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

0
Gord
5/19/2010 8:36:09 PM
Reply:

Similar Artilces: