Merge Cells option is disabled sometimes, how do I enable it?

D

Darla

The MERGE CELL option has previously worked and still works on some sheets.
There are times when it is disabled. How does this happen and how can I
change it?
 
G

Gord Dibben

Merged cells will cause no end of problems but if you "must" use them......

A couple of things I can think of.

If the workbook is shared the option will not be available.

If the worksheet is protected the option won't be available.


Gord Dibben MS Excel MVP
 
F

Fesco

Gord Dibben said:
Merged cells will cause no end of problems but if you "must" use them......

A couple of things I can think of.

If the workbook is shared the option will not be available.

If the worksheet is protected the option won't be available.


Gord Dibben MS Excel MVP



I tried to save as the file to different file name but still shows as shared file. What will I do?
Click to expand...
 
Top