How to Delete a Row in Google Sheets

Spreadsheets are constantly evolving documents. As projects finish, inventory is sold, or data becomes obsolete, you will frequently need to remove information to keep your sheet clean and organized. While you can easily click a cell and hit the Backspace key to delete the text inside it, that leaves an empty, blank row floating in the middle of your spreadsheet. To truly clean up your document, you need to delete the entire row itself.

How to Delete a Single Row

Deleting a row completely removes it from existence. Any rows beneath the deleted data will immediately shift upward to fill the gap.

1. Open your Google Sheets document.
2. Look at the far-left side of the screen where the row numbers are listed (1, 2, 3, etc.) on a grey background.
3. Locate the number of the row you want to remove (for example, Row 5).
4. Right-click directly on the number “5”.
5. The entire row will highlight in blue, and a drop-down menu will appear.
6. Click on Delete row from the menu.
7. Row 5 will vanish, and the row that was previously number 6 will slide up and instantly become the new row 5.

How to Delete Multiple Rows at Once

If you have a large block of old data you want to purge, deleting them one by one is incredibly inefficient.

1. Click and hold your left mouse button on the first row number you want to delete (e.g., Row 10).
2. While holding the button down, drag your mouse downward to select multiple numbers (e.g., drag down to Row 15). The entire block of rows will highlight in light blue.
3. Right-click anywhere inside the highlighted grey number area.
4. Click on Delete rows 10 – 15 from the context menu.
5. The entire chunk of data will be removed instantly.

Deleting Rows vs. Clearing Rows

It is important to understand the difference between deleting a row and clearing a row.

• Delete row: Removes the physical structure of the row. It destroys the data, the formatting, the background colors, and pulls all data below it upward to close the gap.
• Clear row: (Achieved by highlighting a row and pressing the Delete/Backspace key on your keyboard). This only acts as an eraser. It removes the text and numbers inside the cells, but the row itself—along with its background colors, borders, and structural position—remains exactly where it is.

If you want to maintain the exact spacing of your spreadsheet but simply remove the data, use the “Clear” method. If you want to condense your data and remove the gap entirely, use the “Delete row” method.