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?


--
Susanstef
------------------------------------------------------------------------
Susanstef's Profile: http://www.excelforum.com/member.php...o&userid=35615
View this thread: http://www.excelforum.com/showthread...hreadid=554346

Select the merged cells.

FormatCellsAlignment.

What is in the merge cells option box?

Try clicking it a few times.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 17:16:20 -0500, Susanstef
wrote:


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?

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


--
Susanstef
------------------------------------------------------------------------
Susanstef's Profile: http://www.excelforum.com/member.php...o&userid=35615
View this thread: http://www.excelforum.com/showthread...hreadid=554346

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/as...010801033.aspx


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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
------------------------------------------------------------------------
Susanstef's Profile: http://www.excelforum.com/member.php...o&userid=35615
View this thread: http://www.excelforum.com/showthread...hreadid=554346

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 ToolsShare Workbook
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time.'
Click OK

Susanstef wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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


--
Susanstef
------------------------------------------------------------------------
Susanstef's Profile: http://www.excelforum.com/member.php...o&userid=35615
View this thread: http://www.excelforum.com/showthread...hreadid=554346