Merge Cells Option Grayed Out

[Al Franz]

Using Excel 2007 and the Merge Cells Option is grayed out. I read the help
and said this may occur if cells are within a table, but they are not. The
spreadsheet is also showing SHARED, how can this be removed. Is this the
problem. The spreadsheet is not on a network?

 

[Gord Dibben]

In versions earlier than 2007 you could not merge cells in a shared workbook.

Maybe same in 2007?

Not having the ability to merge cells is a good thing.

They cause no end of problems with copying, sorting, filtering, pasting,
autofitting and a host of others that escape me right now but will become
apparent to you as you attempt to work with merged cells.

They should be avoided if at all possible.

Center Across Selection can be useful in most cases.


Gord Dibben MS Excel MVP

 

[JP]

Can't find the link right now, but you can't edit/create merged cells
in a shared workbook.

HTH,
JP

 

[JP]

LOL, the world would be a better place.

--JP

 

[Al Franz]

How do you change the workbook to non-shared in Excel 2007 ? Thanks.

Can't find the link right now, but you can't edit/create merged cells
in a shared workbook.

HTH,
JP

 

[JP]

Here's what I found on http://tinyurl.com/3xtaqb. You would just
reverse the sharing.

Open your Excel workbook.
On the Review tab, in the Changes group, click Share Workbook.
On the Editing tab, place a check beside the option to Allow changes
by more than one user at the same time. This also allows workbook
merging.
Click the Advanced tab and under Update Changes select Automatically
every. You can use the default value of 15 minutes or change this.
Click OK.

HTH,
JP

 

[carlosmendoza.jr.02]

Using Excel 2007 and the Merge Cells Option is grayed out. I read the help
and said this may occur if cells are within a table, but they are not. The
spreadsheet is also showing SHARED, how can this be removed. Is this the
problem. The spreadsheet is not on a network?

I know that this topic is very old but I had mine working even when the Merge and Center command is grayed out. Just select the cells you want to merge, then press CTRL+M.