Forum Discussion
CCDOpsMgr01
Oct 11, 2026Copper Contributor
What could be stopping me from merging columns in Excel ?
Trying to reformat an excel file and I'm not being allowed to merge certain cells/columns and I can't see any obvious reasons why.
2 Replies
- NikolinoDEPlatinum Contributor
To give you an accurate answer without guessing, please share the following details:
- What happens when you try to merge?
Is the Merge & Center button greyed out, or do you get an error? If there’s an error, please copy the exact message. - Which cells or columns are selected?
For example: A1:B1, entire columns A:B, etc. Are they adjacent? - Is the data formatted as an Excel Table?
Click inside the data. If a Table Design tab appears, it’s a table—and tables don’t allow merged cells. - Is the worksheet protected?
Go to the Review tab. Do you see Unprotect Sheet? - What file type is it?
Is it .xlsx, .xls, .csv, etc.? Do you see [Compatibility Mode] in the title bar? - Is the workbook shared or co-authored?
Look for [Shared] in the title bar, or other people editing at the same time. - What operating system and browser are you using?
For example: Windows 11 + Chrome, macOS + Safari. Browser version is helpful if known. - Does the same problem happen in a brand-new blank workbook?
Create one and try merging two cells. - If possible, a screenshot.
Please include the selected range, the Merge & Center button, and any error message.
Once you send these details, the cause can be pinpointed.
- What happens when you try to merge?
- TerioBrass Contributor
Without file or example is hard to reply.
Bye.