View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default merging cells in an unshared protected sheet

You'll have to explain why you would need merged cells for a fill-in the
blanks form.

Have you tried wrap text and autofit?

How much text are you attempting to enter in a cell?

Excel will allow 32767 chars per cell but will display only 1024 of those in
the cell.

Merging several cells will not increase that limit............you still have
one cell.

Try an Alt + Enter every 100 chars to increase the display limit.


Gord

On Mon, 13 Oct 2008 16:32:15 -0700, James
wrote:

The layout is a simple letter size fill-in the blanks form with no macros and
some cell validations. I have tried inserting a text box but I cannot adjust
the paragraph spacing.