How to Delete Rows on Google Sheets on PC or Mac

Written by Travis Boylls

This wikiHow teaches you how to delete rows in Google Sheets.

Steps

1
Go to https://sheets.google.com in a web browser. If you're logged in with your Google account, this opens a list of the Google Sheet documents that are associated with your Google account.
- Log in to your Google account if you aren't logged in automatically.
2
Click the Google Sheet document you want to open.
- You can also click
  to start a new Google sheet.
Advertisement
3
Click the row number you want to delete. It's on the left side of the page. The row should be highlighted in blue. You can also select multiple rows at once:
- Hold ⇧ Shift and click another row number to select all the rows in between.
- Hold Ctrl (on PC) or ⌘ Command (on Mac) and click another row number to add that row to your selection.
4
Click the Edit tab in the menu bar at the top.
5
Click Delete row(s). This option will list the row number or range you highlighted. This will clear all the data in the row(s) and move any rows below it to take its place.
- You can also press Delete instead of using the menus options to delete the selected rows.
Advertisement