merge and center in Excel not highlighted

N

Nam

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

Pyrite

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top