The fastest way to delete a row
Right-click on the row number on the left side of the spreadsheet — the gray column that shows 1, 2, 3, and so on. A menu will appear. Click Delete. The row disappears, and all rows below it move up one position.
That is the complete process. Excel removes the row and shifts everything underneath it automatically. You do not need to select anything else or confirm the deletion — it happens immediately when you click Delete.
If you want to delete multiple rows at once, click the first row number, then hold Shift and click the last row number you want to remove. All rows between them will highlight in blue. Right-click and select Delete, and they all vanish at once.
Key Takeaways
- Right-click the row number on the left side and select Delete to remove that row instantly.
- All rows below the deleted row move up automatically — you do not have to move them yourself.
- To delete multiple rows, click the first row number, hold Shift, click the last row number, then right-click and select Delete.
- If you delete a row by mistake, press Ctrl+Z immediately to undo and bring it back.
- Clearing a row (removing only the content, not the row itself) is different from deleting it — use Clear Contents if you want to keep the empty row.
Deleting a row using the menu instead of right-clicking
If right-clicking does not work on your computer or you prefer using the menu, you can delete a row from the top toolbar. First, click the row number to select the entire row — it will turn blue. Then go to the Home tab at the top of Excel, find the Delete button in the toolbar (it usually has a small arrow next to it), and click it.
A small menu appears with options. Click Delete Sheet Rows. The row is removed the same way as the right-click method — everything below it shifts up.
The menu method takes one extra step, but some people find it easier to see what they are doing. Both ways produce the exact same result.
The difference between deleting and clearing
Deleting a row removes the entire row from the spreadsheet. Clearing a row removes only the content inside it — the empty row stays in place. This matters because deleting shifts all your other rows up, while clearing does not change the structure of your spreadsheet.
If you want to remove only the data but keep the row itself (for example, to preserve spacing or formatting), right-click the row and select Clear Contents instead of Delete. The row number stays where it is, but everything in that row becomes blank.
Most people delete rows when they want to remove data entirely and do not care about keeping empty space. Use Clear Contents only if you have a specific reason to keep the row itself.
What happens to formulas when you delete a row
If other cells in your spreadsheet contain formulas that refer to the deleted row, those formulas will break. For example, if cell C5 contains the formula =SUM(A1:A10) and you delete row 5, the formula updates automatically to =SUM(A1:A4,A6:A10) — it skips the deleted row and keeps calculating the remaining cells.
However, if a formula refers directly to a cell in the deleted row (like =A5*2), that formula will show an error after you delete the row. Before you delete, check whether any other cells depend on the row you are about to remove. You can do this by clicking a cell in the row and looking at the formula bar to see if other cells reference it.
If you are not sure, use Ctrl+Z to undo the deletion immediately after you delete. Excel will restore the row and all formulas to their original state.
Undoing a deletion if you made a mistake
If you delete a row and realize you made a mistake, press Ctrl+Z on your keyboard (or Cmd+Z on a Mac). The row comes back instantly with all its original data. You can undo multiple deletions by pressing Ctrl+Z several times — each press takes you back one step.
This works only if you undo immediately after the deletion. Once you close the file or perform many other actions, Excel may not be able to undo the deletion. For this reason, if you are deleting rows from an important spreadsheet, take a moment to double-check that you are deleting the right rows before you right-click.
If you have already closed the file without saving, the deleted row is gone permanently. Excel does not recover deleted rows from closed files. Always save a backup of important spreadsheets before you delete large sections.
Deleting rows with specific content or conditions
If you want to delete all rows that contain a certain word or number, you can use Excel's filter feature to show only those rows, then delete them all at once. Click any cell in your data, then go to the Data tab and click Filter. Small dropdown arrows appear in the header row. Click the arrow in the column you want to filter, uncheck the items you want to keep, and click OK. Now only the rows matching your filter show on screen.
Select all the visible rows (click the first row number, hold Shift, click the last row number), right-click, and select Delete. Only the filtered rows are removed — the hidden rows stay in place. After deletion, click the filter arrow again and select Clear Filter to show all remaining rows.
This method is useful when you need to remove many rows that share something in common, like all entries from a certain date or all rows with a blank cell in a particular column. It is faster than deleting rows one at a time.
Deleting rows in Excel on a phone or tablet
On Excel for iPhone or iPad, tap and hold the row number until a menu appears, then tap Delete. On Excel for Android, tap the row number to select it, then tap the trash icon or the three-dot menu and select Delete.
The process is similar to the desktop version, but the buttons and menus look different because of the smaller screen. If you are working with a large spreadsheet on a phone, it is usually easier to use a computer instead — deleting rows on a small screen can be error-prone.
Frequently Asked Questions
Can I delete a row without losing the data in it?
Yes. Instead of deleting the row, use Clear Contents to remove only the data while keeping the row itself. Right-click the row and select Clear Contents. The data disappears but the row stays in place. If you want to move the data somewhere else first, copy the row before you delete it.
What if I delete the wrong row by mistake?
Press Ctrl+Z immediately to undo the deletion. The row comes back with all its original data. This works as long as you undo right away — if you perform other actions first, you may not be able to recover the row.
Does deleting a row affect other sheets in the same workbook?
No. Deleting a row only affects the sheet you are currently working on. Other sheets in the same workbook are not changed. However, if another sheet contains a formula that refers to the deleted row, that formula will show an error.
Can I delete a row if it is frozen?
Yes, but you need to unfreeze it first. Go to the View tab, click Freeze Panes, and select Unfreeze Panes. Then you can delete the row normally. After deletion, you can freeze rows again if needed.
How do I delete an entire column instead of a row?
The process is identical. Click the column letter at the top (A, B, C, and so on), right-click, and select Delete. The entire column is removed and all columns to the right shift left. To delete multiple columns, click the first column letter, hold Shift, click the last column letter, then right-click and select Delete.