The fastest way to delete a row

Right-click on the row number on the left side of the spreadsheet. A menu will appear with several options. Click "Delete row" and the row disappears when ready. That is the whole process — no confirmation dialog, no undo button that appears separately. The row is gone, but you can still undo the deletion by pressing Ctrl+Z (or Cmd+Z on Mac) if you change your mind within a few seconds.

If you need to delete multiple rows at once, click on the first row number, then hold Shift and click on the last row number you want to remove. All the rows between them will highlight in blue. Right-click anywhere in the selected area and choose "Delete rows" — note that it now says "rows" plural. Google Sheets will remove all of them at once.

Key Takeaways

  • Right-click the row number on the left edge and select "Delete row" to remove a single row when ready.
  • To delete multiple rows, click the first row number, hold Shift, click the last row number, then right-click and choose "Delete rows".
  • Deleted rows cannot be recovered after you close the spreadsheet without saving, so use Ctrl+Z when ready if you make a mistake.
  • Deleting a row shifts all rows below it upward, so any formulas or references that point to specific row numbers will change.

What happens to the data below when you delete a row

When you delete a row, every row below it moves up by one position. If you delete row 5, what was row 6 becomes row 5, row 7 becomes row 6, and so on. This matters if your spreadsheet contains formulas that reference specific rows by number.

For example, if you have a formula in cell C10 that says =SUM(C1:C9), and then you delete row 3, that formula automatically becomes =SUM(C1:C8). Google Sheets adjusts the reference for you. However, if you have a formula that points to a specific cell like =C5, and you delete row 5, the formula will now point to whatever moved into row 5 — which might not be what you intended. Always check your formulas after deleting rows to make sure they still calculate what you need.

Using the menu instead of right-clicking

If right-clicking does not work on your device or you prefer using the menu bar, you can delete a row through the Edit menu. First, click on the row number to select the entire row. Then click "Edit" in the menu bar at the top, and look for "Delete rows" in the dropdown. This method works the same way as right-clicking.

On some devices or browsers, the right-click menu may not appear or may show different options. Using the Edit menu is a reliable backup method that works the same way everywhere.

Clearing a row instead of deleting it

Sometimes you want to remove the data from a row but keep the row itself in place. This is useful if you have formulas or formatting that depend on specific row numbers. To clear a row without deleting it, click on the row number to select it, then press the Delete key on your keyboard. The row stays where it is, but all the data inside it disappears.

The difference matters: deleting removes the row and shifts everything below it up. Clearing removes only the contents and leaves the row structure unchanged. If your spreadsheet has 100 rows and you clear row 50, you still have 100 rows. If you delete row 50, you have 99 rows.

Recovering a deleted row

If you delete a row by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo. This works as long as you have not performed any other actions since the deletion. Google Sheets keeps a short undo history, so you can usually go back several steps.

If you have already closed the spreadsheet or performed many other actions, the deletion cannot be undone through the undo button. However, if the spreadsheet is shared or stored in Google Drive, you may be able to view the version history. Click "File" in the menu bar, then "Version history" to see previous versions of the spreadsheet. You can open an older version and copy the data you need, though you cannot restore it directly into the current version.

Deleting rows in a shared spreadsheet

When you delete a row in a spreadsheet that other people can edit, the deletion happens for everyone when ready. There is no separate approval step. If someone else is looking at the spreadsheet at the same time you delete a row, they will see it disappear from their screen.

If you are worried about accidentally deleting something important, ask the spreadsheet owner to limit editing permissions. Some people can be set to "Viewer" only, which means they can see the spreadsheet but cannot make changes. Others can be set to "Commenter", which lets them suggest changes without actually making them. These settings are found in the "Share" button at the top right of the spreadsheet.

Frequently Asked Questions

Can I delete a row and keep the data somewhere else?

Yes. Before you delete, select the row, copy it (Ctrl+C or Cmd+C), and paste it into another spreadsheet or document. Then delete the row from the original spreadsheet. This way you have a backup of the data before it is removed.

What if I delete the wrong row by accident?

Press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the deletion. This works as long as you have not done anything else since. If you have already performed other actions, check the version history by clicking File, then Version history, to see if you can restore an earlier version of the spreadsheet.

Does deleting a row affect columns or formulas in other sheets?

If you have a formula in a different sheet that references a specific row number in the deleted sheet, that formula will adjust automatically. For example, if Sheet2 has =Sheet1!C5 and you delete row 5 in Sheet1, the formula becomes =Sheet1!C4. Always check formulas in other sheets after deleting rows.

Can I delete a row if I only have view permission?

No. If you can only view the spreadsheet, the right-click menu will not show a delete option. You will need the spreadsheet owner to give you editor permission, or you can ask them to delete the row for you.