View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Gerrie Gerrie is offline
external usenet poster
 
Posts: 13
Default is there a limit to how much text can be entered in merged cel

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.
--
Thanks for any help you can give me.


"Gerrie" wrote:

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!
--
Thanks for any help you can give me.


"Gord Dibben" wrote:

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


On Mon, 11 Sep 2006 13:31:01 -0700, roygray
wrote:

Where do i find this Workaround from Dave's Post

"Gord Dibben" wrote:

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

On Mon, 11 Sep 2006 04:00:02 -0700, roygray
wrote:




Gord Dibben MS Excel MVP