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

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

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

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

On Sat, 30 May 2009 02:36:01 -0700, antarticus
wrote:

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