unmerge cells

[Susanstef]

The merge cells option has been deselected and I want to be able to
unmerge the cells. I don't know how or why the merge cells option has
been deselected (I inherited the document) but as far as I can see, the
document is not protected. How can I access the merge cells option to
be able to unmerge?

 

[Gord Dibben]

Select the merged cells.

Format>Cells>Alignment.

What is in the merge cells option box?

Try clicking it a few times.


Gord Dibben MS Excel MVP

 

[Susanstef]

the merge cells option is deselected. that is, I can't tick or untick
it is currently ticked (but greyed out)

 

[Debra Dalgleish]

If the workbook is shared, you won't be able to merge or unmerge cells.
That's one of many features that aren't available:

http://office.microsoft.com/en-ca/assistance/HP052010801033.aspx

 

[Susanstef]

Thanks Debra!! Yes, I can see now that the file appears to be "shared"
(I can only tell this by the title [shared] after the file name at the
top. As I said, I have inherited this file, is there someway to
"unshare" it or do I have to save it as a different file to get rid of
the shared status??

Susan

 

[Debra Dalgleish]

You should make a backup copy of the file, because it may have history
that you'll need later. The history would be deleted if you remove sharing.

Then, on another copy of the file:

Choose Tools>Share Workbook
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time.'
Click OK

Thanks Debra!! Yes, I can see now that the file appears to be "shared"
(I can only tell this by the title [shared] after the file name at the
top. As I said, I have inherited this file, is there someway to
"unshare" it or do I have to save it as a different file to get rid of
the shared status??

Susan

 

[Susanstef]

Thanks again, Debra. I'll do that.
Susa