Unhiding rows is usually what you need, not deleting them

When rows disappear in Excel, they are almost always hidden rather than deleted. A hidden row takes up no space on screen but the data still exists in the file. Before you delete anything, unhide the rows first to see what is actually there — you may find you need that data.

To unhide rows, select the rows on either side of the gap (click the row number, hold Shift, click another row number), right-click, and choose Unhide. The hidden rows reappear. If rows at the very top or bottom are hidden, click the first visible row number, hold Shift, and click the last visible row number to select everything, then unhide.

If you are certain you want to permanently remove rows — not just hide them — you delete them the same way you delete any row: select it, right-click, and choose Delete. Deletion removes the row and shifts everything below it up. Hiding just removes it from view.

Key Takeaways

  • Hidden rows still contain data; unhiding shows them again without losing anything.
  • To unhide rows, select the rows around the gap, right-click, and choose Unhide.
  • Deleting a row permanently removes it and shifts all rows below it upward.
  • If you cannot see the Unhide option, select a wider range of rows that definitely includes the hidden ones.

How to select hidden rows before unhiding them

The tricky part is selecting rows you cannot see. Excel will not let you click a hidden row directly, so you have to select the visible rows around it.

Click the row number just above the gap where rows disappeared. Hold Shift and click the row number just below the gap. Right-click anywhere in the selected area and choose Unhide. All hidden rows between those two points reappear at once.

If hidden rows are at the top of the sheet (before row 1 is visible), click row 1, hold Shift, and click any row further down, then unhide. If hidden rows are at the bottom, select from some visible row down to the last row number you can see, then unhide.

When rows hide automatically in Excel

Rows hide most often when someone uses the AutoFilter feature. AutoFilter adds dropdown arrows to the header row and lets you filter which rows display. When you filter, Excel hides the rows that do not match your filter criteria — they are not deleted, just hidden until you change the filter.

To see all rows again after filtering, click the dropdown arrow in any column header and choose Clear Filter, or go to the Data menu and click Clear. This unhides all the filtered-out rows.

Rows can also hide if someone manually hid them (right-click a row, choose Hide) or if a macro or script hid them automatically. The unhiding process is the same regardless of how they got hidden.

Deleting rows permanently instead of unhiding

If you have unhidden the rows and confirmed you want to remove them, select the row or rows you want to delete. Click the row number on the left to select the entire row. To select multiple rows, hold Shift and click another row number, or hold Ctrl and click individual row numbers to select non-consecutive rows.

Right-click the selected row number and choose Delete. Excel removes those rows and moves everything below them up to fill the space. The data is gone permanently — this action cannot be undone if you close the file without saving, but if you save first, the deletion is permanent.

If you delete by mistake, press Ctrl+Z when ready to undo, as long as you have not performed other actions since the deletion.

The difference between hiding and deleting

Hiding a row removes it from view but keeps the data in the file. The row still counts toward your file size, formulas can still reference it, and you can unhide it anytime. Hiding is useful when you want to focus on certain data without losing the rest.

Deleting a row removes it completely. The data is gone, formulas that referenced it will show an error, and you cannot get it back unless you undo when ready or restore from a backup. Deletion is permanent once you save the file.

Most of the time when rows seem to vanish, hiding is the cause, and unhiding solves it. Delete only when you are certain the rows contain data you no longer need.

Selecting all rows at once to unhide everything

If you want to unhide all hidden rows in the sheet at once, click the box in the top-left corner where the row numbers and column letters meet. This selects every cell in the sheet. Right-click any row number and choose Unhide. Every hidden row reappears.

You can also select all rows by pressing Ctrl+A, then right-click and unhide. This is faster than trying to figure out which specific rows are hidden.

Frequently Asked Questions

Can I unhide rows if I do not know where they are?

Yes. Press Ctrl+A to select all cells, right-click any row number, and choose Unhide. This unhides every hidden row in the sheet at once, regardless of where they are located.

What happens to formulas when I delete a row?

Formulas that reference a deleted row will show a #REF! error. If the formula added up a range that included the deleted row, the sum will be lower. Unhiding is safer if you might need the data later.

Can I delete hidden rows without unhiding them first?

Yes, but you cannot see what you are deleting. Select the rows around the hidden ones, right-click, and choose Delete. The hidden rows and the selected visible rows will all be deleted. It is safer to unhide first so you know what you are removing.

Why do my rows keep hiding when I do not want them to?

AutoFilter is probably active. Check the Data menu — if you see a filter icon or the columns have dropdown arrows, click Data and then Clear to turn off filtering and unhide all rows.

Is there a keyboard shortcut to unhide rows?

No built-in shortcut exists, but you can select the rows and right-click to unhide. Selecting all rows with Ctrl+A and then unhiding is the fastest method if you want to show everything at once.