software

I'm trying to merge cells in an existing shared workbook, but the icon is
dim, and in the format cells dialog box, the merge cells box is checked, but
dim. I turned off any protection or cell locking, so why won't it let me
merge, and what've I got to do to allow me to merge cells?
Thanks in advance for any help

Hi

It sounds like the some of your cells are already merged - or part-merged.
You'll have to find out which cells are merged to select them and unmerge
them. You can then merge the ones you want.

Hope this helps.
Andy.

quot;Walter Kquot; lt;Walter gt; wrote in message
...
gt; I'm trying to merge cells in an existing shared workbook, but the icon is
gt; dim, and in the format cells dialog box, the merge cells box is checked,
gt; but
gt; dim. I turned off any protection or cell locking, so why won't it let me
gt; merge, and what've I got to do to allow me to merge cells?
gt; Thanks in advance for any help
Check to see if your workbook is shared. quot;toolsquot;, quot;share workbookquot;
quot;Walter Kquot; wrote:

gt; I'm trying to merge cells in an existing shared workbook, but the icon is
gt; dim, and in the format cells dialog box, the merge cells box is checked, but
gt; dim. I turned off any protection or cell locking, so why won't it let me
gt; merge, and what've I got to do to allow me to merge cells?
gt; Thanks in advance for any help

Try desperately hard to NOT MERGE cells. Use Center Across Selection
instead, under Format-gt;Cells-gt;Alignment-gt;Horizontal.

Merged cells can create all sorts of problems, while virtually all the
benefits can be gained through other means.
quot;Walter Kquot; wrote:

gt; I'm trying to merge cells in an existing shared workbook, but the icon is
gt; dim, and in the format cells dialog box, the merge cells box is checked, but
gt; dim. I turned off any protection or cell locking, so why won't it let me
gt; merge, and what've I got to do to allow me to merge cells?
gt; Thanks in advance for any help

Duke,

That is a AWESOME tip!

Thanks,

Scott
quot;Walter Kquot; wrote:

gt; I'm trying to merge cells in an existing shared workbook, but the icon is
gt; dim, and in the format cells dialog box, the merge cells box is checked, but
gt; dim. I turned off any protection or cell locking, so why won't it let me
gt; merge, and what've I got to do to allow me to merge cells?
gt; Thanks in advance for any help