How To Delete Rows In Google Sheets

Google Sheets is a popular free online tool that allows you to create and edit spreadsheets directly in your web browser. One of the common tasks you may often perform is deleting rows. If you are new to Google Sheets or merely seeking a quick refresher, this blog post will walk you through the process of deleting rows in Google Sheets.

Deleting a Single Row

The simplest action you might want to perform is deleting a single row. Here’s how:

  1. Open your Google Sheet and select the row you want to delete by clicking the row number on the left.
  2. Right-click to open the context menu.
  3. Select Delete row.

And, voila! You have just deleted a row in Google Sheets.

Deleting Multiple Rows

If you wish to delete multiple rows simultaneously, follow these steps:

  1. Select the first row you want to delete.
  2. Hold down the Shift key and click the last row you want to delete. This action will select all rows in between inclusively.
  3. Right-click on any of the highlighted rows.
  4. Select Delete rows.

Your selected rows are now deleted!

Deleting Rows Using Google Apps Script

If you frequently need to delete specific rows, you can automate the process using Google Apps Script. Here’s an example:

           function deleteRows() {
              var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');

This script will delete the 5th row in the spreadsheet named ‘Sheet1’. To delete multiple rows, you can call the deleteRow() function multiple times.


Deleting rows in Google Sheets is straightforward and intuitive, whether you’re removing a single row, multiple rows, or using Google Apps Script for automation. Now that you’ve mastered this skill, you can keep your spreadsheets clean and organized more efficiently!

Stay tuned for more Google Sheets tips and tricks. Happy spreadsheeting!