How to Fix Excel Freezing When Deleting Rows or Columns

Microsoft Excel is widely used for managing large datasets, performing calculations, and organizing information. However, some users encounter a frustrating issue where Excel freezes or becomes unresponsive when deleting rows or columns. This can interrupt workflow and make editing spreadsheets difficult.

This issue usually occurs due to large datasets, corrupted worksheets, excessive formatting, problematic add-ins, or outdated Excel versions. In some cases, Excel may also slow down if there are complex formulas, conditional formatting rules, or hidden objects in the workbook.

If Excel freezes when deleting rows or columns, try the solutions below.

How to Fix Excel Freezing When Deleting Rows or Columns

Work through the following methods until Excel starts working normally again.

1. Restart Excel and Your Computer

Temporary glitches in Excel or the operating system may cause the application to freeze.

1. Close Microsoft Excel completely.
2. Press Ctrl + Shift + Esc to open Task Manager.
3. End any running Excel processes.
4. Restart your computer.
5. Open the workbook again and try deleting rows or columns.

Restarting clears temporary processes that may affect Excel performance.

2. Open Excel in Safe Mode

Safe Mode disables add-ins that may cause Excel to freeze.

1. Press Windows + R to open the Run dialog.
2. Type: excel /safe
3. Press Enter.
4. Open the workbook and test whether deleting rows or columns works.

If the issue disappears in Safe Mode, an add-in may be causing the problem.

3. Disable Excel Add-ins

Problematic add-ins can cause Excel to become unresponsive.

1. Open Excel.
2. Click File > Options.
3. Select Add-ins.
4. At the bottom, choose COM Add-ins from the Manage dropdown.
5. Click Go.
6. Uncheck unnecessary add-ins.
7. Restart Excel.

Disabling conflicting add-ins may fix the freezing issue.

4. Clear Excess Formatting

Excess formatting in large spreadsheets can slow Excel significantly.

1. Select rows or columns that extend beyond your data range.
2. Press Ctrl + Shift + Down Arrow or Ctrl + Shift + Right Arrow.
3. Right-click and choose Delete.
4. Save the workbook.

Removing unnecessary formatted cells reduces workbook size.

5. Remove Conditional Formatting Rules

Too many conditional formatting rules can affect performance.

1. Select the affected worksheet.
2. Go to the Home tab.
3. Click Conditional Formatting.
4. Select Clear Rules.
5. Choose Clear Rules from Entire Sheet.

Reducing conditional formatting may improve performance.

6. Disable Hardware Graphics Acceleration

Hardware acceleration sometimes causes Excel performance issues.

1. Open Excel.
2. Click File > Options.
3. Go to Advanced.
4. Scroll to the Display section.
5. Check Disable hardware graphics acceleration.
6. Restart Excel.

This may stabilize Excel performance.

7. Repair Microsoft Office

Corrupted Office installation files may cause Excel to freeze.

1. Press Windows + I to open Settings.
2. Go to Apps > Installed apps.
3. Locate Microsoft Office.
4. Click Modify.
5. Choose Quick Repair or Online Repair.

Repairing Office may fix application issues.

8. Update Microsoft Excel

Outdated versions of Excel may contain bugs affecting performance.

1. Open Excel.
2. Click File > Account.
3. Select Update Options.
4. Click Update Now.

Updating Excel installs the latest fixes and improvements.

Conclusion

If Excel freezes when deleting rows or columns, the issue is often caused by excessive formatting, problematic add-ins, large datasets, or outdated Office versions. In many cases, opening Excel in Safe Mode, clearing formatting, or repairing Office resolves the problem quickly.

By following the troubleshooting steps above, you should be able to fix the freezing issue and continue editing spreadsheets smoothly in Microsoft Excel.