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
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

Hi Julian,

 

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

 

Regards,

Haytham

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies