merge option and Sort options unavailable

Copper Contributor

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

1 Reply

@rijas_rp 

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.