Office Apps Freezing

Fix Excel 2016 Freezing When Unmerging Cells

Ayan MasoodAyan Masood Nov 20, 2026 868 views

Question details

Troubleshoot Excel 2016 becoming unresponsive when unmerging a large range of cells.

Fix Excel 2016 Freezing When Unmerging 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.
Before you start

Identify the affected range and check whether Excel displays an error message. Save any open work before closing Excel for the Safe Mode test.

Solution 1Recommended

Test Excel Safe Mode and disable COM add-ins

Use Safe Mode to check whether an add-in is contributing to the freeze.

1
Start Excel in Safe Mode

Right-click the Windows Start button, select Run, enter excel /safe, and select OK.

2
Test the unmerge operation

Open the affected workbook, select the range, and choose Home > Merge & Center > Unmerge Cells.

3
Disable COM add-ins

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.

4
Identify the add-in

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 Excel Safe Mode and disable COM add-ins
Exiting Safe Mode: Close Excel and start it normally to exit Safe Mode.
Free Microsoft Office alternative

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.

Use familiar spreadsheet controls to merge and unmerge cellsOpen and edit Microsoft Excel XLS and XLSX filesMove existing spreadsheet work to a lightweight office suiteUse WPS Office for free
microsoft office alternative - wps office

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.