How to Enable merge and center icon on the formating toolbar?

G

Guest

In the formating toolbar Merge and Center Icon is in disable condition. So
that i could not merge the required cells which i want.
Could u please help me in this issue to enabling that icon in the formating
toolbar.
 
B

Bernie Deitrick

Jyothi,

Unprotect the worksheet, and that button will become available.

HTH,
Bernie
MS Excel MVP
 

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

Similar Threads

Center across selection 2
cannot merge and center 2
"Center across selection" rather than "Merge cells" 10
The merge center icon remains gray and does not work. 1
Conditional Formating on Several Cells 6
Merge and Center when sheet is protected 2
"Center Across Selection" icon in excel 2003 1
Merging cells in Pivot tables 1

Top