To delete extra rows in Excel, select the row numbers on the left, then choose Home > Delete > Delete Sheet Rows. For blank rows, first identify them using a column that should always contain data; for duplicates, use Excel’s Remove Duplicates command instead. Save a copy before deleting so you can recover records if you select the wrong rows.
What You’ll Need
- A workbook open in Excel for Microsoft 365 on Windows.
- A clear idea of which rows are unwanted: for example, completely blank rows, duplicate records, or a specific group of old entries.
- A backup or a saved copy of the workbook if the data is important. Deleting rows changes the sheet structure, and later edits may make Undo unavailable.
Check whether your data is an Excel table or a regular cell range. Tables have filter buttons in their header row and expand automatically as you add records. The deletion methods below cover both, with table-specific guidance where it matters. If you are unsure what a row contains, inspect it before deleting it; an apparently empty row may include a formula, a note, or data in a column outside the visible part of the sheet.
Step-by-Step
- Save a safety copy. Use File > Save As to create a separate copy, or save your current workbook before making changes. If you only need to remove a few rows and have not made other edits since, Ctrl+Z on Windows can undo a deletion. A saved copy is safer for larger cleanups or when the workbook is shared.
- Decide what extra means in this sheet. Decide whether you are removing specific rows, rows that are entirely blank, rows with a blank value in a required column, or duplicate records. These are different tasks. A row with an empty notes cell is not necessarily an empty row, and two records that share a name may still be valid if another field, such as date or order number, differs.
- Delete a known row or block of rows. Find the row numbers at the left edge of the worksheet. Click a row number to select the entire row. To select several adjacent rows, drag across their row numbers or click the first row number, hold Shift, and click the last. Right-click the selected row numbers and choose Delete, or use Home > Delete > Delete Sheet Rows. Check that the selected rows contain only the records you intend to remove.
- Delete rows that are not next to each other. On Windows, hold Ctrl and click each unwanted row number to select multiple separate rows. Then right-click one of the selected row numbers and choose Delete, or choose Home > Delete > Delete Sheet Rows. Review the highlighted row numbers before confirming. If the rows are difficult to select accurately, delete them one at a time rather than risk removing nearby records.
- Find blank rows using a required column. Choose a column that should contain a value for every real record, such as an ID or order number. Select only the data cells in that column, excluding the header. Go to Home > Find & Select > Go To Special, select Blanks, and choose OK. Excel highlights blank cells within the selected range. Before deleting, make sure those blanks correspond to rows you want gone; a blank in one column does not prove the entire row is empty.
- Delete the rows found by the blank-cell search. With the blank cells in the required column still selected, choose Home > Delete > Delete Sheet Rows. This removes the entire worksheet rows containing those blank cells, including any content in other columns. Check the result immediately. If you accidentally remove records, press Ctrl+Z before doing further work, or reopen the saved copy.
- Use a filter when you need to inspect candidates first. Select your data and choose Data > Filter if filter buttons are not already visible. Open the dropdown for the relevant column and filter for blanks or for the value that marks unwanted records. Review the displayed records. For a regular range, clear the filter before selecting individual row numbers to delete, taking care to select only the intended rows. For a table, right-click a cell in a record you want to remove and choose Delete > Table Rows. Remove records in small groups if you are not sure how the selection behaves in your sheet.
- Remove duplicate records with the dedicated command. Click inside your data, then choose Data > Remove Duplicates. In the dialog, select the columns Excel should compare. Select all columns if only identical full records count as duplicates; select a unique identifier or a chosen set of fields if those define a duplicate for your task. Leave My data has headers selected when the first row contains column names. Choose OK, read the number of duplicate values removed, and inspect the remaining records. Excel keeps one instance and deletes the matching later records.
- Confirm the cleanup. Scan the first and last records in the cleaned range, check important totals or record counts, and make sure formulas still refer to the intended cells. Save the workbook after checking it. If other sheets, charts, or formulas use the deleted records, verify those as well.
On Excel for Mac, the ribbon commands are generally in the same places, though the layout can vary slightly by release. If a keyboard shortcut differs or is not convenient, use the row-number right-click menu or the ribbon. Excel for the web also has row deletion and filtering, but some desktop selection and Go To Special options may be unavailable or behave differently; use the row-number menu or open the workbook in the desktop app for a large cleanup.
Common Mistakes
- Clearing cells instead of deleting rows. Pressing Delete or using Home > Clear removes contents or formatting, but leaves the row in place. To close the gap and shift later rows upward, use Delete Sheet Rows or the table’s Delete > Table Rows command.
- Deleting every row with a blank cell. Go To Special finds blank cells, not rows that are entirely empty. If you select blanks across a wide range, Excel may identify rows that have a missing value in just one field. Limit the search to a column that must be filled, and confirm the matching rows are truly unwanted.
- Choosing the wrong duplicate columns. If you select only a name column, Excel may treat two different people with the same name as duplicates. If you select every column, records with the same ID but slightly different details may both remain. Decide what makes a record a duplicate before running the command, and keep a copy of the original data.
- Selecting cells rather than row headers. Deleting selected cells can open a dialog that shifts nearby cells up or left, misaligning records. Click the numbered row headers and choose Delete Sheet Rows when you mean to remove complete worksheet rows.
- Deleting worksheet rows to remove extra blank space. Excel always has a fixed worksheet grid. Deleting unused rows does not remove the worksheet’s maximum row capacity. It can affect formatting or the used range, but it is not a way to permanently shrink the grid.
Tips
- Convert a consistent data range into a table with Insert > Table before ongoing cleanup. Tables make headers and records easier to identify, and you can filter the data without losing track of the header row.
- Keep a unique ID column when possible. It helps you distinguish records with similar names and gives you a reliable field for identifying blank or duplicate entries.
- Use filters to inspect rows before deleting them. A filter is a viewing tool: it hides nonmatching records rather than removing them, so clear the filter when you want to see the complete dataset again.
- For a large deletion, note the record count before and after. If the change is unexpected, undo it straight away rather than trying to reconstruct missing rows manually.
- When a workbook has formulas, tables, charts, or linked reports, check dependent results after deletion. Excel usually adjusts ordinary cell references when rows are removed, but a workbook may contain references or external links that need separate review.
- On Windows, Ctrl+Z undoes the most recent action. On Mac, use Command+Z. The right-click menu is a good alternative to shortcuts when you want to be certain which row-level command you are choosing.
Troubleshooting
The rows disappeared, but blank space remains. You may have cleared cell contents rather than deleting the rows. Select the numbered row headers and use Home > Delete > Delete Sheet Rows. If you did delete the rows and still see empty-looking space, check whether row height, borders, or formatting makes the remaining rows look blank.
Real records were deleted with the blank rows. Press Ctrl+Z immediately on Windows or Command+Z on Mac, provided you have not performed actions that prevent undo. If undo is no longer available, restore the saved copy or use version history if the file is stored in OneDrive or SharePoint. Repeat the cleanup using a required ID column rather than searching for blanks across all columns.
Go To Special did not find the rows you expected. Confirm that you selected the data cells, not the entire sheet or just the header, before opening Home > Find & Select > Go To Special. Cells containing spaces or formulas that return an empty-looking result are not truly blank, so the Blanks option may not select them. Filter the column to inspect the values, or check the cells directly before deciding how to remove those records.
Remove Duplicates removed too many or too few records. Undo the command, reopen Data > Remove Duplicates, and review the checked columns. Comparing too few columns can merge distinct records; comparing too many can leave near-duplicates behind. Also confirm that the header option is set correctly, since treating a header as data can affect the result.
The Delete command is unavailable or the sheet will not change. The worksheet may be protected. Check Review > Unprotect Sheet; if a password is required, you need the password or help from the workbook owner. If the data is in a shared or coauthored file, confirm you have permission to edit it and that your changes have finished syncing before closing the workbook.
Frequently Asked Questions
How do I delete multiple rows at once in Excel?
Select their row numbers, using Shift for a continuous block or Ctrl-click for separate rows on Windows, then choose Home > Delete > Delete Sheet Rows. Verify the selected rows first.
How do I delete completely blank rows without deleting rows with missing information?
Search a column that should be filled for every valid record, select its data cells, and use Home > Find & Select > Go To Special > Blanks. Delete the sheet rows only after confirming each match is meant to be removed.
What is the difference between Delete and Clear Contents?
Delete Sheet Rows removes complete rows and shifts the content below upward. Clear Contents removes cell values or formulas but leaves the cells and rows in place.
Can I remove duplicate rows but keep one copy?
Yes. Choose Data > Remove Duplicates and select the columns that define a duplicate. Excel keeps one matching record and removes the others. Save a copy first, because the command changes the data directly.
Can I delete extra rows in Excel for the web?
Yes. You can select row numbers and use the context menu to delete rows, and you can filter data to find candidates. If you need Go To Special or a more controlled cleanup, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Can I permanently remove all unused rows at the bottom of a worksheet?
No. Excel worksheets have a fixed grid, so the remaining blank rows are part of the sheet. Deleting them does not eliminate the grid. To keep a workbook tidy, remove unwanted formatting or content only when needed, and avoid treating unused worksheet space as data.
Related
- Count Green Cells in Excel: 3 Reliable Ways to Do It
- Count Days Between Dates in Excel: A Practical Guide
- How to Copy the Upper Cell in Excel with a Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter on Two Columns: A Practical GuideYes. In Google Sheets, create a filter for your data, then apply a condition in each of the…
- How to Insert Color in Excel: Cells, Text, and RulesTo add color in Excel, select the cells, open Home > Font > Fill Color, and choose a…
- How to Make an A5 Booklet in Word: Setup and PrintTo make an A5 booklet in Word for Microsoft 365 on Windows, open Layout > Margins > Custom…
- Why Can’t I Merge Cells in Google Sheets?You usually cannot merge cells in Google Sheets because the selection is not a single, adjacent rectangular range,…
- Excel Goal Seek: How Easy Is It to Use?Yes—Excel Goal Seek is easy to use once you know which three cells to identify: the formula cell,…
- How to Archive Emails in Outlook on the Web EasilyTo archive an email in Outlook on the web, select it in your message list and choose Archive…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.