merge and center in Excel not highlighted
 

I am not able to merge the columns in middle rows. The merge aand center
buttons are not highlighted.

merge and center in Excel not highlighted
 

Nam,

Has your worksheet been protected? This could be one reason that the merge
and centre option appears grayed out. Left click on Tools at the top of the
screen, roll over the Protection option to bring up the sub menu and if one
of the options says 'Unprotect Worksheet' then that is the problem. Left
click to unpretect the sheet and you will be able to merge and center. If
this is the problem dont forget to protect the sheet after you're done to
protect those formulas and layout.

Hope that helps.



"Nam" wrote:

I am not able to merge the columns in middle rows. The merge aand center
buttons are not highlighted.