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