Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There is a section of this form (24 merged rows) that the writer will need to
type in comments. If the sheet is protected and the sentence is too long, the writer cannot merge one row to another. -- James "Gord Dibben" wrote: 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge Cells on Protected Sheet | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
merging cells in a protected work sheet | Excel Discussion (Misc queries) | |||
Merging cells on a protected work sheet | Excel Worksheet Functions | |||
Can I allow cell merging in a protected sheet | Excel Worksheet Functions |