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

  • Thread starter Thread starter Darla
  • Start date Start date
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?
 
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
 
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...
 
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...
 

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
the merge cells option is disabled, i don't know why 1
Merge Cell Cut & Paste 1
Merging cells in shared file 2
merge cell is disabled 2
Excel 2007 - Why is Cell Merging Disabled? 5
allow merging cells in protected sheet 1
How do I locate merged cells in my Excel worksheet? 7

Back
Top