Forum Discussion
rijas_rp
Sep 22, 2021Copper Contributor
merge option and Sort options unavailable
Hello, 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. Thanks Rp
NikolinoDE
Sep 22, 2021Platinum Contributor
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.
Nikolino
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.