How to delete row in Google Sheets?

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: To delete a row in Google Sheets, simply select the row number, right-click and choose ‘Delete row.’ Alternatively, use the ‘Edit’ menu after selecting the row(s). Quickly undo any mistakes with Ctrl + Z.

This guide provides a clear, step-by-step process on how to delete rows in Google Sheets.

Step 1: Open Your Spreadsheet

Start by opening the Google Sheet document where you need to delete rows. Ensure you have the correct editing permissions if it’s not your personal document.

Step 2: Select the Row(s) to Delete

Click on the row number on the left side of the row you want to delete. For multiple rows, click and drag across the row numbers, or use the Shift key to select a range of rows.

Step 3: Deleting the Row(s)

Right-click on one of the highlighted row headers. A context menu will pop up. Click on ‘Delete row’ (or ‘Delete rows’ for multiple). The selected row(s) will be removed from your sheet.

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

Alternative Method: Using the Menu Bar

You can also delete rows via the menu bar. With your row(s) selected, go to the ‘Edit’ menu, and then click ‘Delete row’ (or ‘Delete rows’).

Step 4: Undoing the Deletion

If you accidentally delete the wrong row, you can quickly undo this action. Press Ctrl + Z (Command + Z on Mac) to undo the last action. Alternatively, you can use the ‘Undo’ button in the Google Sheets toolbar.

Tips for Deleting Rows in Google Sheets:

  1. Check Data Dependencies: Before deleting any row, ensure it’s not linked to other data or formulas within your spreadsheet.
  2. Data Backup: Consider creating a copy of your data before performing bulk deletions, especially in shared documents.
  3. Utilize Filters for Large Data Sets: For large spreadsheets, use filters to find and delete rows more efficiently.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies