merge option and Sort options unavailable

New Contributor



In my sheet the merge & center  and sorting features are unavailable (greyed) , its not a protected sheet or a shared sheet.

I would appreciate if anyone's help.




1 Reply


Since you are informing that the file is not locked / protected and not shared

... could be one of these.


First, check the line break in the format settings and see if it works.


Second, Mark cells - Right mouse button - Format cells - Alignment tab - Horizontal - Center over selection.


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.