To delete a row that is hidden in Excel for Microsoft 365 on Windows, enter its row number in the Name Box (for example, 12:12), select the entire row, then choose Home > Delete > Delete Sheet Rows. This removes the row and its contents; it is different from unhiding a row, which only makes it visible again. Save a copy first if the data matters, and confirm you have the correct row before deleting it.
What You’ll Need
- The Excel workbook open in the desktop app, with permission to edit it.
- The hidden row number, if you already know it. If you do not, you can reveal hidden rows or use Find to locate a distinctive value.
- A saved copy or a recent backup if the row contains information you might need later. Excel’s Undo can usually reverse a deletion immediately, but it is not a substitute for a backup.
The instructions below are for Excel for Microsoft 365 on Windows. Row deletion works similarly in Excel for Mac, but the ribbon layout and keyboard shortcuts can differ. Excel for the web also supports deleting rows, though some context-menu options may be arranged differently.
Step-by-Step
- Check whether the row is truly hidden. Look at the row numbers along the left edge of the worksheet. If the numbering jumps, such as from 11 to 13, row 12 is hidden. A row may also be hidden because a filter is active or because rows have been grouped and collapsed. Those cases need a little care: a filtered-out row is not necessarily the same as a manually hidden row, and deleting it may affect the underlying table data.
- Identify the row you intend to remove. If you know its row number, note it down. If you do not, inspect the surrounding data or use Ctrl+f to search for a unique word or value in the row. Check the column headings and neighboring records so you do not mistake a hidden row for a different entry. When a filter is active, consider clearing it temporarily so you can inspect the full list before deciding what to delete.
- Select the hidden row using the Name Box. The Name Box is the small field to the left of the formula bar; it often displays the active cell address, such as A1. Click in that field, type the row reference as a range, such as
12:12, and press Enter. Excel selects the entire row 12 even though it is not currently visible. For another hidden row, replace 12 with its row number. If the Name Box is not visible, use Ctrl+g to open Go To, enter the same reference, and press Enter. - Verify the selection before deleting. Look at the Name Box or the highlighted row selection to confirm the intended row number. If you used Go To, check that you entered a row range such as
12:12, not a cell address such asA12. Selecting A12 alone and deleting it would affect a cell, not necessarily the whole worksheet row. If you are unsure, press Esc and repeat the selection rather than guessing. - Delete the entire worksheet row. On the Home tab, choose Delete in the Cells group, then choose Delete Sheet Rows. Excel removes the selected row and shifts the rows below it upward. The hidden row is deleted even though you could not see it. You can also right-click a selected row header and choose Delete, or select the whole row and press Ctrl+- (the minus key) on Windows. If a dialog appears, choose Entire row and confirm.
- Check the rows and data around the deletion. Look at the former neighboring rows and verify that the expected record is gone and that the rest of the worksheet still lines up. Because deleting a sheet row shifts cells upward across the full width of the sheet, check other columns too, especially if the worksheet contains separate blocks of data side by side. If the wrong row disappeared, press Ctrl+z immediately to undo, then select the correct row.
- Save the workbook after checking it. Use Ctrl+s on Windows when you are satisfied. If the deletion was made in a shared or cloud workbook, make sure the workbook has finished saving before closing it. Do not rely on Undo after closing the workbook or after making many later edits.
If the hidden row is part of an Excel table
A table row and a worksheet row are not always the same thing for editing purposes. If you only want to remove one record from a formatted Excel table, first make the record visible, click a cell in that table row, right-click, and choose Delete > Table Rows. This removes the table record without deleting unrelated cells elsewhere on the worksheet. If you choose Delete Sheet Rows instead, Excel removes the full worksheet row, which can also shift or remove adjacent data outside the table. For a hidden table record, clear or adjust the filter first, locate the record, and then use the table-row command.
If the row is hidden by a filter or outline
A filter hides records that do not meet its criteria; it does not change their row numbers. To inspect filtered-out records, open the filter arrow in the relevant column and choose Clear Filter From, or use Data > Clear to clear filters on the sheet. This makes the records visible but does not delete them. If the row is collapsed under an outline, use the outline controls beside the row numbers to expand that group, then select the intended row. Once visible, delete it using the method that suits the data: Delete Sheet Rows for a whole worksheet row, or Delete > Table Rows for a table record.
Common Mistakes
- Choosing Hide instead of Delete. Right-clicking a row header and choosing Hide only conceals the row. Its values remain in the workbook and can be shown again. To remove it, use Delete, not Hide.
- Deleting a cell instead of a row. If only a cell such as A12 is selected, pressing the Delete key clears its contents; it does not delete the worksheet row. Select the row reference, such as
12:12, or click the row header before using Delete Sheet Rows. - Assuming hidden means filtered out. A row hidden by a filter may become visible when the filter changes. Clearing the filter is not the same as deleting that row. Review the data first and remove only the record you intend to remove.
- Deleting a worksheet row when you only meant to remove a table record. A full-row deletion can affect formulas, notes, or unrelated data in the same row outside the table. Use Delete > Table Rows when the target is a record in a table and surrounding worksheet cells must stay put.
- Deleting several rows without checking the selection. If you select a range that includes visible and hidden rows, Excel may delete every row in that range. Confirm the row references before applying the command, particularly when filters or grouped rows are involved.
- Expecting the Delete key to remove the row. The Delete key usually clears cell contents. Use Home > Delete > Delete Sheet Rows, the row-header context menu, or Ctrl+- after selecting the full row.
Tips
- Use the Name Box when row numbers are known. Typing
25:25selects all of row 25, even if it is hidden or far down the sheet. You can enter a range such as25:28to select several consecutive rows, but double-check the range because all of those rows will be removed. - Make a temporary copy before a large cleanup. Use File > Save As to create a separate copy, or duplicate the worksheet if appropriate. This gives you a safer way to compare the result if you are removing many rows or cleaning imported data.
- Use Find to identify a record, not to assume its row is visible. Ctrl+f can help locate a unique value. Once you have identified its row, confirm the row number and select the full row before deleting. Searching is especially useful when a hidden row contains a name, reference number, or distinctive description.
- Use the right shortcut for your computer. On Windows, Ctrl+- opens the delete command for a selected row or cell range. On Mac, select the row and use Control+- where supported, or use Home > Delete > Delete Sheet Rows; keyboard behavior can depend on the keyboard and Excel version. On either platform, the ribbon command is the clearest option if the shortcut does not behave as expected.
- Keep formulas and references in mind. Excel adjusts many formulas when rows are deleted, but inspect totals, charts, named ranges, and linked sheets afterward. A formula may still calculate while no longer including the records you intended, especially if it refers to a fixed range.
- Prefer filtering or hiding if you only need a cleaner view. Deleting is permanent in the workbook after the action can no longer be undone. If you may need the data later, keep the row and use a filter or hide it instead.
Troubleshooting
The Name Box does not accept the row reference. Click directly in the Name Box, not the formula bar, and enter a reference with a colon, such as 12:12. Press Enter. If the field is hard to find, use Ctrl+g, type 12:12 in the Reference box, and press Enter. Make sure the workbook is not in cell-edit mode; press Esc once and try again.
I cannot tell which row number is hidden. If the row numbers jump, the missing number identifies it. If several rows are hidden, select the range you need by its row numbers in the Name Box. If rows are hidden at the top or bottom of the sheet, use Go To to select the likely row reference rather than relying on the row headers. You can also temporarily unhide rows: select the row headers immediately above and below the hidden range, right-click the selection, and choose Unhide. For a hidden first row, select row 2 and use Home > Format > Hide & Unhide > Unhide Rows.
Unhide is unavailable or does not reveal the row. The row may be excluded by a filter or contained in a collapsed outline. Clear the filter from the relevant column, or expand the outline using its plus sign or level buttons beside the row numbers. Also check whether the worksheet is protected: go to Review and look for Unprotect Sheet. If you do not have the password or permission, ask the workbook owner before trying to change the sheet.
Excel deletes the wrong cells or shifts data unexpectedly. Undo at once with Ctrl+z on Windows or Command+z on Mac. Then check whether you selected a cell, a table row, or a full worksheet row. Use the row reference in the Name Box and choose Delete Sheet Rows only when the entire worksheet row should be removed. If data beside the table should remain in place, make the target record visible and delete it with the table-row command instead.
The row is still missing after I deleted it. Deleting a row shifts the rows below it upward, so the next row takes its place; the row numbers do not leave a gap. If you still see a gap in the numbering, another row may be hidden. If the record seems to remain, a filter, duplicate entry, or another copy of the data may be involved. Clear filters and search for the record again before repeating the deletion.
I am using Excel for the web or Mac. In Excel for the web, select the row using its header or the Name Box if available, then use the row context menu to delete it; the exact menu placement can differ from the Windows desktop ribbon. In Excel for Mac, you can use the Home tab’s Delete options or the row-header context menu. If a Windows shortcut does not work on Mac, use the visible menu command instead.
Frequently Asked Questions
Can I delete a hidden row without unhiding it?
Yes. Enter its row reference, such as 12:12, in the Name Box or Go To box, then choose Home > Delete > Delete Sheet Rows. Confirm the row number before deleting.
Does deleting a hidden row remove its contents permanently?
It removes the row and its contents from the worksheet. You can usually restore it immediately with Undo, but after more edits or closing the workbook, recovery may not be possible. Keep a backup if you might need the information.
What is the difference between deleting and hiding a row?
Hiding keeps the row and its data in the worksheet but removes it from view. Deleting removes the row and shifts the rows beneath it upward. Choose Hide if you only want to simplify what is displayed.
Can I delete every hidden row at once?
There is no single safe command that means “delete all rows hidden for any reason.” Rows may be hidden manually, filtered out, or collapsed in an outline, and those situations can represent different data. Identify the rows you intend to remove, clear filters if needed, and review the selection before deleting.
Why does the Delete key clear data instead of removing a row?
The Delete key clears the contents of selected cells. To remove the row structure, select the entire row and choose Delete Sheet Rows, or use the row-header context menu. Ctrl+- on Windows is another option when the full row is selected.
Will Excel update formulas when I delete a row?
Excel often adjusts formulas that refer to deleted cells, but you should check totals, charts, named ranges, and formulas on other sheets. A deletion can change the data included in a calculation, even if the formula itself still looks valid.
Related
- How to Copy Border Formatting in Excel to Other Cells
- Copy and Paste in Excel While Keeping Formatting
- Copy and Paste Split Cells in Excel: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- CSV vs Excel: File Differences, Uses, and LimitationsCSV is a plain-text format for storing rows of data, while Excel is spreadsheet software that can store…
- How to Add a Logo as a Watermark in WordTo add a logo as a watermark in Microsoft Word, open the document in the desktop app and…
- Employee Schedule Template for Google Sheets: SetupAn employee schedule template in Google Sheets is a reusable spreadsheet for assigning shifts, tracking hours, and sharing…
- How to Add a Shared Mailbox Folder in Outlook 365To add a shared mailbox folder in Outlook, first get permission to the mailbox or folder, then add…
- How to Accept a Calendar Share in OutlookTo accept a calendar share in Outlook, open the sharing invitation in your email and select Accept or…
- Excel Data Validation Rules: How They Work and When to Use ThemExcel data validation rules control what users can enter in selected cells, using limits such as a number…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.