Merge Icon Does not work?


C

CWHelp

I inherited several spreadsheets and the merge cell icon is shaded and will
not allow operation. Also, cannot check or uncheck box in format cell.
I have removed sort function but not luck. The sheet is not protected? Does
anyone any idea how to reactivate the merge function?
 
Ad

Advertisements

G

Gord Dibben

Is the workbook shared?

If so, unshare and your merge will come alive.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Merge Cell Cut & Paste 1
Can't use protection options 1
troubleshoot merge cells - checked protection. Why is icon dim? 4
Make Alignment options under format cells available as shortcut 1
Merge and Center when sheet is protected 2
why would the merge box in the format cells menu be greyed out 4
Merged Cell Sorting 1

Top