How do I recover a deleted row in Google Sheets?

1. Undo: press Ctrl + Z (Windows, ChromeOS) or ⌘ + Z (Mac) until the row comes back.

2. Restore an earlier version (computer):

1. Open the spreadsheet and click Last edit at the top right.
2. In the right panel, choose a version from before the row was deleted. Sheets hides unmodified rows by default; click Show unmodified rows to see everything.
3. Click Restore this version, then Restore.

Restoring rolls back every change made after that version, not just the deleted row, and clears the cell-by-cell edit history from before the restore.

3. Copy just the row back (safer when other edits came later): in version history, select the old version, click More > Make a copy, then copy the row from that copy and paste it into the current file.

Good to know:

• Cell edit history (right-click a cell > Show edit history) does not show added or deleted rows, so use version history instead.
• You need permission to edit the file to browse earlier versions.

To avoid the problem, clear a row's contents instead of deleting the row when a sheet has formulas built for a fixed number of rows.