Fix Excel 2016 Freezing When Unmerging Cells
Question details
Troubleshoot Excel 2016 becoming unresponsive when unmerging a large range of cells.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows; version not provided
- Scenario
- The user wants to unmerge a range containing approximately 500 cells.
- Observed behavior
- Excel becomes unresponsive during the unmerge operation.
Identify the affected range and check whether Excel displays an error message. Save any open work before closing Excel for the Safe Mode test.
Test Excel Safe Mode and disable COM add-ins
Use Safe Mode to check whether an add-in is contributing to the freeze.
Right-click the Windows Start button, select Run, enter excel /safe, and select OK.
Open the affected workbook, select the range, and choose Home > Merge & Center > Unmerge Cells.
If the operation works in Safe Mode, close Excel and reopen it normally. Select File > Options > Add-ins, choose COM Add-ins next to Manage, and select Go. Clear the custom add-in checkboxes and select OK.
Retry the unmerge operation. If it works, return to File > Options > Add-ins > COM Add-ins > Go and re-enable add-ins one at a time, testing after each change.

Test smaller ranges and a new workbook
Compare a smaller selection and a new workbook to narrow down whether the issue depends on the range or file.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for Excel formats, making it easy to move spreadsheet work to another application. It does not repair an Excel 2016 installation.

Frequently Asked Questions
How do I start Excel 2016 in Safe Mode?
Right-click the Windows Start button, select Run, enter excel /safe, and select OK. Close and reopen Excel normally to exit Safe Mode.
What if unmerging works in Safe Mode?
Restart Excel normally and go to File > Options > Add-ins. Select COM Add-ins next to Manage, select Go, and disable custom add-ins. Test again, then re-enable them one at a time to identify a possible cause.
How can I tell whether the workbook is involved?
Create a blank workbook through File > New, merge a small selection, and then use Home > Merge & Center > Unmerge Cells. Compare the result with the affected workbook.
Where can I find my Office 2016 build information?
In Excel, select File > Account and look under Product Information. Record the version and build when requesting further support.




