Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 542
Default merging cells in an unshared protected sheet

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Cells on Protected Sheet denis mat Excel Discussion (Misc queries) 1 October 10th 08 09:38 AM
paste locked cells and unlocked cells in protected sheet Angeline Excel Worksheet Functions 15 November 1st 06 11:51 PM
merging cells in a protected work sheet EG Excel Discussion (Misc queries) 4 October 15th 06 02:55 AM
Merging cells on a protected work sheet EG Excel Worksheet Functions 1 October 14th 06 04:03 PM
Can I allow cell merging in a protected sheet PatM Excel Worksheet Functions 1 December 13th 05 03:06 PM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"