How to Delete Rows on Google Sheets (PC or Mac)

Table of contents:

How to Delete Rows on Google Sheets (PC or Mac)
How to Delete Rows on Google Sheets (PC or Mac)
Anonim

This article explains how to delete one or more rows on Google Sheets.

Steps

Delete Rows on Google Sheets on PC or Mac Step 1
Delete Rows on Google Sheets on PC or Mac Step 1

Step 1. Visit https://sheets.google.com using a browser

If you are logged in with your Google account, the list of associated documents will open.

Log into your account if it doesn't happen automatically

Delete Rows on Google Sheets on PC or Mac Step 2
Delete Rows on Google Sheets on PC or Mac Step 2

Step 2. Click on the Google Sheets document you want to open

  • You can also click on

    Android_Google_New
    Android_Google_New

    to create a new sheet.

Delete Rows on Google Sheets on PC or Mac Step 3
Delete Rows on Google Sheets on PC or Mac Step 3

Step 3. Click on the number of the row you want to delete

It is located on the left side of the page. The row should be selected and turn blue. You can also select multiple lines at a time as follows:

  • Hold down ⇧ Shift and click on another row number to select all the rows in between;
  • Hold down Ctrl (on PC) or ⌘ Command (on Mac) and click on another line number to add it to the selection.
Delete Rows on Google Sheets on PC or Mac Step 4
Delete Rows on Google Sheets on PC or Mac Step 4

Step 4. Click on the Edit tab in the menu bar at the top of the screen

Delete Rows on Google Sheets on PC or Mac Step 5
Delete Rows on Google Sheets on PC or Mac Step 5

Step 5. Click Delete Selected Rows

This option allows you to view the selected row or range of rows. All the data inside them will be deleted and the underlying rows will be moved to take the place of the removed ones.

Recommended: