cannot merge and center

M

Mike

Does anyone know why simple functions in Excel '07 would be unavailable
(icons grayed out) All I want to do is a simple merge and center on an
unprotected, shared workbook and I cannot get the icon on the toolbar to
"light up"

Thanks!
 
G

Gord Dibben

Count yourself fortunate that you are not allowed to "merge" any cells.

I can't speak for 2007 but in 2003 "merge cells" is unavailable for shared
workbooks.

Try Center Across Selection which is allowed.


Gord Dibben MS Excel MVP
 

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

"Merge and center" grayed out in excel form 1
Sharing workbooks limitations - Merged Cells 12
"Center across selection" rather than "Merge cells" 10
Merge and Center when sheet is protected 2
The merge center icon remains gray and does not work. 1
How to Enable merge and center icon on the formating toolbar? 1
"merge and center" grayed out 2
Merge/Unmerge feature to not functioning 5

Top