is there a limit to how much text can be entered in merged cells

D

Dave Peterson

32,767 characters.

But unless you do something special, you might not be able to see more than
about 1000 characters.

If you add alt-enters every 80-100 characters and adjust the rowheight, you'll
see much, much more than the 1000 characters documented in xl's help.

roygray wrote:
 
G

Gord Dibben

No more than you can enter into a single cell.

Reason..........if you merge 14 cells into one, you have one big cell with the
same properties as any single cell.

See Dave's post for workaround.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Dave's post stated...................

"If you add alt-enters every 80-100 characters and adjust the rowheight, you'll
see much, much more than the 1000 characters documented in xl's help."


Gord


Where do i find this Workaround from Dave's Post
Click to expand...

Gord Dibben MS Excel MVP
 
G

Gerrie

I tried Dave's workaround, but it isn't working for me. Is there anything
else I can do. We use EXCEL spreadsheets to track absenteeism and there are
usually many many comments to add. Any suggestions for me! HELP!
 
D

Dave Peterson

What happens when you add alt-enters every 80-100 characters and then adjust the
rowheight manually?
 
G

Gerrie

I get white space at the top of the cell and the rest of the text just moves
down in the cell without giving me the last few lines of text just as before
the alt-enters.
 
Top