Fix Excel 2019 Crashing When Merging Cells
Question details
The user needs to troubleshoot Excel 2019 when merging cells causes the application to crash.
- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- The user is merging cells in an Excel 2019 workbook and needs to determine whether the crash is caused by the workbook, an add-in, an outdated installation, or a system issue.
- Observed behavior
- Excel 2019 closes or crashes when the user attempts to merge cells.
Open a new blank workbook and test Home > Merge & Center to determine whether the problem is limited to one file. Also check whether Excel and Windows have pending updates before changing add-in or repair settings.
Test the workbook and disable Excel add-ins
Use this solution when merging works in a blank workbook or when Excel may be affected by an incompatible add-in.
A damaged workbook or COM add-in can cause Excel to crash during otherwise supported operations such as merging cells. Testing in Safe Mode helps separate add-in-related problems from workbook or installation issues.
Open Excel 2019, select Blank workbook, enter sample text in two cells, and choose Home > Merge & Center. If the blank file works, the original workbook may be damaged.
Press Windows + R, type excel /safe, and select OK. Open the affected workbook and test Home > Merge & Center again.
In Excel, select File > Options > Add-ins. At the bottom, set Manage to COM Add-ins, select Go, clear the add-in checkboxes, and choose OK. Restart Excel and test the merge operation.
If merging fails only in one file, create a new workbook and copy the affected data into it using Paste Special or regular paste, then try Home > Merge & Center.
Update Windows and repair Office 2019
Use this solution when Excel crashes in multiple workbooks, including blank files, after add-ins have been ruled out.
Use WPS Office as a lightweight alternative for spreadsheet editing
If Excel 2019 continues to crash, WPS Office provides a free, lightweight spreadsheet editor with a familiar interface and strong Microsoft Office format compatibility. Open or migrate the workbook in WPS Spreadsheets and continue editing without relying on the affected Office installation.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or desktop shortcut.
- 2. Open the workbook: In WPS Spreadsheets, select Menu > Open and choose the affected XLS or XLSX workbook.
- 3. Merge the cells: Select the adjacent cells, open the Home tab, and choose Merge Cells or Merge and Center.
Frequently Asked Questions
Why does Excel 2019 crash only when I merge cells?
The merging command is supported, so a crash may indicate a damaged workbook, incompatible add-in, outdated Office installation, or graphics and system conflicts. Test the same action in a blank workbook and in Excel Safe Mode.
How can I open Excel 2019 in Safe Mode?
Press Windows + R, enter excel /safe, and select OK. Safe Mode prevents most Excel add-ins from loading, which helps determine whether an add-in is causing the crash.
What should I do if merging crashes Excel in only one workbook?
Create a new workbook and copy the data from the affected file into it, then try Home > Merge & Center. If the problem remains, the original workbook may need repair before further editing.
How do I repair Microsoft Office 2019?
Open Control Panel > Programs > Programs and Features, select Microsoft Office 2019, choose Change, and run Quick Repair. If the problem continues, use Online Repair when available.
