Forum Discussion

rijas_rp's avatar
rijas_rp
Copper Contributor
Sep 22, 2021

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

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Sep 22, 2021

    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.

     

     

     

Resources