Home

Restoring "Merge & Center" disabled in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-276262%22%20slang%3D%22en-US%22%3ERestoring%20%22Merge%20%26amp%3B%20Center%22%20disabled%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20in%20which%20Merge%20%26amp%3B%20Center%20has%20been%20disabled.%26nbsp%3B%20I%20cannot%20establish%20why%20or%20how%20this%20has%20been%20achieved%20and%20need%20to%20restore%20the%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-276262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277350%22%20slang%3D%22en-US%22%3ERe%3A%20Restoring%20%22Merge%20%26amp%3B%20Center%22%20disabled%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277350%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20addition%2C%26nbsp%3B%3CSPAN%3EMerge%20%26amp%3B%20Center%20is%20disabled%20if%20you%20stay%20within%20the%20table%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276331%22%20slang%3D%22en-US%22%3ERe%3A%20Restoring%20%22Merge%20%26amp%3B%20Center%22%20disabled%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276331%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Julian%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20two%20possible%20causes%20for%20this%20and%20have%20been%20discussed%20%3CA%20href%3D%22https%3A%2F%2Fexcel.tips.net%2FT005398_Merge_and_Center_Not_Available.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Julian White
Occasional Visitor

I have a spreadsheet in which Merge & Center has been disabled.  I cannot establish why or how this has been achieved and need to restore the function.

2 Replies
Highlighted

Hi Julian,

 

There are two possible causes for this and have been discussed here.

 

Regards,

Haytham

Highlighted

In addition, Merge & Center is disabled if you stay within the table

Related Conversations
Matching date input to the formatted date display
Erikstg in Excel on
1 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
13 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
1 Replies