View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default troubleshoot merge cells - checked protection. Why is icon dim?

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

Merged cells can create all sorts of problems, while virtually all the
benefits can be gained through other means.



"Walter K" wrote:

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