my merge and centre icon is just a shadow, help?

[antarticus]

i am using excel a lot at the moment but am primarily self taught. I have
managed to lock down my merge and centre button so all I can see is a shadow
of the light grey imprint.

How can I release the icon? noting I have tried to customize and drag the
merge back again but as soon as I close the box I again lose the icon?

Urgently needed to finish spreadsheets this weekend!!!

 

[Gord Dibben]

Worksheet is protected?

Workbook is in Shared mdoe?

Either of these will disable merge and center.

Since you are learning I would suggest you quickly unlearn the use of merge
and center.

Causes many problems when copying, pasting, sorting and a host of other
operations.

Explore the use of Center Across Selection and wrap text/autofit rows and
columns.


Gord Dibben MS Excel MVP