merge option and Sort options unavailable

%3CLINGO-SUB%20id%3D%22lingo-sub-2772875%22%20slang%3D%22en-US%22%3Emerge%20option%20and%20Sort%20options%20unavailable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772875%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20sheet%20the%20merge%20%26amp%3B%20center%26nbsp%3B%20and%20sorting%20features%20are%20unavailable%20(greyed)%20%2C%20its%20not%20a%20protected%20sheet%20or%20a%20shared%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20appreciate%20if%20anyone's%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ERp%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2772875%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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.