Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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!!!
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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!!!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the difference between merge and centre and merge across Jabu Excel Discussion (Misc queries) 4 April 3rd 23 04:40 PM
Merge and Centre Hardeep kanwar Excel Discussion (Misc queries) 3 February 27th 09 09:38 AM
merge & centre - tricky Q KRK New Users to Excel 6 July 1st 08 12:22 PM
Find repeat and than merge and centre Hardeep_kanwar[_2_] New Users to Excel 21 May 30th 08 05:54 AM
undue merge and centre ED New Users to Excel 3 March 31st 06 08:45 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"