If Excel stops responding while deleting rows, first give it a little time: removing rows can trigger lengthy recalculation or updates to tables, formatting, and formulas. If it remains frozen, protect a copy of the workbook, then troubleshoot calculation, workbook complexity, and add-ins before repeating the deletion.
Why deleting rows can freeze Excel
Deleting a row is more involved than clearing its visible values. Excel must remove the cells and adjust affected references, ranges, tables, charts, names, and other workbook features. In a large workbook, that work can take long enough for Windows to label the application Not responding even though Excel is still processing.
Recalculation is a frequent cause. A deleted row may affect formulas on many sheets, and formulas that depend on large ranges or volatile functions can require additional work. Conditional formatting, data validation, pivot tables, external links, and extensive formatting can also add overhead. A workbook stored on OneDrive or a network location may need to synchronize changes as well.
The size of the visible data is not the only factor. A sheet that looks small can contain formatting or formulas far below the area you use, while a workbook with many sheets can have dependencies that are not obvious from the active tab. A pause does not necessarily mean the file is damaged, but repeatedly clicking Delete or closing Excel immediately can make recovery harder.
What to do while Excel is unresponsive
Stop clicking and wait briefly, especially if the workbook is large or the deletion affects many rows. Watch for the title bar to become responsive again, the status bar to change, or disk activity to settle. Excel may finish the operation without further input. Avoid pressing Delete repeatedly: queued commands can produce unexpected changes once the program catches up.
If Excel becomes responsive, save the workbook under a new name before trying another deletion. Use File > Save As and create a separate working copy. If it remains stuck for an unusually long time and Windows offers no recovery, you may have to close it. On Windows, press Ctrl+Shift+Esc to open Task Manager, select Microsoft Excel, and choose End task only as a last resort. Unsaved changes since the last save may be lost.
After reopening Excel, check for the Document Recovery pane and open the most recent recovered version. You can also look under File > Info for workbook recovery options, including Recover Unsaved Workbooks when available. Recovery is not guaranteed, so first preserve any recovered copy with a different filename rather than overwriting the original.
Delete only the rows you intend to remove
Before retrying, confirm what kind of deletion you need. Pressing the Delete key clears cell contents; it does not remove worksheet rows or shift cells upward. To remove entire worksheet rows in Excel for Microsoft 365 on Windows, select the row numbers, right-click the selection, and choose Delete. You can also use Home > Delete > Delete Sheet Rows. Save first, then delete a small test selection if you are unsure how formulas or layout will change.
If the data is an Excel table, use the table-row deletion command when you mean to remove records from the table. Right-click a selected table cell and choose Delete > Table Rows. This removes table records without treating the action as an instruction to remove unrelated worksheet content across the same row.
Be especially careful with filters. A filtered list hides some records, but those records still exist in the worksheet. Check the visible selection and the filter state before deleting entire worksheet rows; otherwise, you may remove hidden records you intended to keep. For important data, test on a copy or add a temporary marker column so you can verify which records are selected.
Check workbook size and complex features
If deleting a few rows works but deleting a large block hangs, the operation may simply be too demanding for the workbook. Try smaller batches in a copy and save between batches. This can make it easier to identify whether one particular range, sheet, or dependency is responsible. It also limits how much work must be repeated if Excel freezes again.
Look for formulas that refer to entire columns, such as calculations over A:A, when only a smaller data range is needed. Large ranges can increase calculation work, especially when many formulas depend on them. Check for conditional-formatting rules applied to whole columns, excessive custom formatting, and formulas copied far below the actual records. Do not delete features blindly: first check whether the workbook relies on them.
Other features can contribute to delays. A pivot table may need refreshing after source data changes; external links can depend on files or network locations; and a workbook with many objects or sheets can take longer to update. If the file is stored in a synchronized folder, wait for synchronization to finish or make a local copy for diagnosis. Keep the original intact until you know the local copy behaves as expected.
Test whether formula recalculation is the bottleneck
For a workbook with extensive formulas, you can temporarily change calculation to manual in a saved copy. In Windows Excel, choose File > Options > Formulas. Under Calculation options, select Manual, then confirm and test the row deletion. This can help distinguish recalculation time from other causes, but it does not make the workbook permanently fixed: displayed formula results may be out of date until you recalculate.
After the edit, press F9 to calculate formulas in open workbooks, or use Formulas > Calculate Now. Shift+F9 calculates the active worksheet. If the workbook still appears stuck during recalculation, allow time for the calculation to complete before saving or closing. Then return to File > Options > Formulas and restore Automatic calculation unless you have a deliberate reason to use manual mode.
Calculation mode can affect other open workbooks in the same Excel session, not just the file you are troubleshooting. That is another reason to note the original setting and restore it. On Mac, calculation controls are available through Excel > Preferences > Calculation in current Microsoft 365 versions; menu wording can differ slightly by release. Keyboard shortcuts also differ, so use the Formulas tab if a Windows shortcut does not apply.
Isolate add-ins and Excel installation problems
If the problem happens in several workbooks, test whether an add-in or Excel itself is involved. On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain startup features and add-ins disabled. Open a copy of the workbook and try a small deletion. If it works in Safe Mode but not in a normal session, an add-in or startup customization may be a factor.
To review COM add-ins, go to File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and choose Go. Record which items are enabled, then disable them one at a time and restart Excel to identify a possible conflict. The route and available add-ins differ on Mac; check Excel > Settings or Preferences and the relevant Add-ins controls. Do not remove an add-in you need without checking with its provider or your organization.
If Excel freezes across unrelated files even after add-ins are ruled out, update Microsoft 365 and consider repairing Office. In Windows, use Settings > Apps > Installed apps, select Microsoft 365, choose Modify, and try Quick Repair first. Online Repair is a more substantial option and may require internet access. Save work and close Office apps before repairing. On a managed work computer, ask your IT administrator before changing installation settings.
Recover safely and prevent another freeze
Once Excel responds, save a clean copy with a new filename and verify the data before continuing. Check formulas near the deleted rows, totals, table boundaries, and any reports or charts that use the affected range. If the workbook is in OneDrive or SharePoint, Version History may let you restore or inspect an earlier version. Confirm that you are restoring the intended file and version; reverting can discard later edits.
- Save a separate copy before deleting a large block or changing calculation settings.
- Remove only the necessary rows, and use table-row deletion for table records.
- Use smaller batches when a large deletion repeatedly stalls.
- Keep formulas and formatting scoped to the data they actually need.
- Close unused workbooks and applications to leave more system resources for Excel.
- After troubleshooting, restore the original calculation setting and check that results are current.
AutoRecover can help with unsaved work, but it is not a substitute for saving. Its recovery interval and available files depend on Excel settings and what was saved before a crash. For important workbooks, use regular saves and keep a separate backup or cloud version history rather than relying on a single recovery mechanism.
Frequently Asked Questions
Should I wait or force-close Excel when it says Not responding?
Wait if the operation may still be progressing, particularly for a large workbook. If it remains unresponsive and you must close it, use Task Manager as a last resort and expect that unsaved changes may be lost. Reopen Excel and check Document Recovery.
Why does deleting one row take so long?
That row may affect formulas across multiple sheets, extensive conditional formatting, a table, or linked data. A workbook with formatting or formulas far beyond the visible records can also require more work than its appearance suggests.
Does pressing Delete remove a row in Excel?
No. The Delete key clears selected cell contents. To remove worksheet rows, select their row numbers and choose Delete, or use Home > Delete > Delete Sheet Rows.
Will changing calculation to Manual fix the workbook?
It may reduce the delay caused by recalculation during editing, but it does not repair other performance problems and can leave displayed results outdated. Recalculate and restore Automatic mode when finished.
Can I delete rows from a filtered list safely?
Yes, but verify exactly which records are selected. Filters hide records rather than remove them, so deleting entire worksheet rows without checking can affect hidden data. Work on a copy when the selection is important or difficult to verify.
Why does Excel freeze when deleting rows in only one workbook?
That points toward something specific to that file, such as its formulas, formatting, tables, links, or size. Compare behavior in a copy, test smaller deletions, and inspect workbook features before concluding that Excel itself is faulty.
Related
- How to Add a Transition to a Photo in PowerPoint
- Debt Snowball Budget Spreadsheet: Build and Use One
- How to Add a Transition Effect to a Shape in PowerPoint
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Line in Microsoft Word: 5 Easy WaysTo insert a quick horizontal line in Word, type three hyphens on an otherwise blank paragraph and press…
- Basic Excel Table With Data: How to Build and Use OneA basic Excel table with data is a rectangular set of related records organized under a single header…
- Excel Table Absolute References: How They WorkExcel tables do not use dollar signs to make structured references absolute: a reference such as Orders[Amount] continues…
- Excel You Can’t Paste This Here: Causes and Fixes ExplainedExcel’s “You can’t paste this here” message usually means the destination does not match the copied cells or…
- Excel Consolidate Cells: Merge or Combine Data?In Excel, “consolidate cells” can mean merging cells into one larger cell, joining the contents of several cells,…
- Save an Excel Workbook as a Copy Without Replacing ItTo save a separate copy of an Excel workbook in Microsoft 365 for Windows, open the workbook and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.