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

  • Thread starter Thread starter antarticus
  • Start date Start date
A

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!!!
 
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
 
Back
Top