All of a sudden my Excel’s Merge and Center icon became grayed out. I cannot activate it at all. Is there anything I can do to make it work? I am using Excel 2010.
There are several reasons which can cause this to happen:
1. Editing option has been turned on for multiple users:
When this happens, several options will be disabled by Excel. If you happen to use Excel mostly at work in a network environment, then there is a possibility that this feature may get turned on by a network user. To disable this feature click on: Review Tab -> Share Workbook Icon -> Uncheck the option shown in the image below.
2. Your worksheet is protected: The Merging and Centering feature may get disabled due to a protected worksheet. To unprotect a worksheet click on: Review -> Protect Sheet icon or Protect Workbook icon and select appropriate options.
3. Clear Formatting: Sometimes special formatting can limit functionalities of cells. To clear all formatting, perform the following: Home Tab -> Towards the right you will see an Eraser type of icon. Click on the icon and select Clear Format.
Hopefully the steps above solve your problem.
19 thoughts on “Excel Merge and Center Icon is Grayed Out, Not Functional”
Good evening, I just wanna thank you for this answer!!, THANK YOU VERY VERY MUCH, it was VERY helpful. THANKS A BUNCH.
thanks a lot..reason no 1 was identified in my system and it worked after unchecking..!
Good one, very helpfull
Thanks. Problem solved
thank you !!
It worked 🙂
It worked. Thank you
thax a lot
thanx a lot, i worked
Thank you.. 🙂
Thanks a lot
It work….Thank you.so much.. .
The first option worked. Thanks!
problem solved using the first option.
Problem solved by 1st option
It Worked. I wasted Two hours in this exercise. Now due to your help it worked.
I am glad that you were able to fix it 🙂
it worked ! thank you
Most welcome 🙂