How to Delete a Row in Google Sheets (Easiest Method)
There are a variety of different reasons you might want to delete a row from your Google Sheets spreadsheet—whether to reflect a change in the relevant data, correct a mistake, or remove unused rows to simplify and clean up the document. Thankfully, Google makes it easy to delete a row in Sheets. We’ll show you how to use the easiest methods to delete a row in Google Sheets.
How to Delete a Row in Google Sheets
When you want to remove a row from your Google spreadsheet, choose one of the methods below and follow the simple steps.
The simplest way to delete a row from a Google Spreadsheet is by using the edit menu.
1. Select the Row you Wish to Delete
Hover your cursor of the row number at the leftmost, horizontal axis of the spreadsheet and click to select the whole row. Alternatively, you can simply select any cell in the row.
2. Open the Edit Menu
With the row selected, move your cursor to the horizontal menu atop your spreadsheet and select “Edit.”
3. Select “Delete”
With the edit menu open, move your cursor down to choose “Delete.” Once selected, a submenu will appear.
4. Choose the row from the menu
The delete sub menu is populated by contextual information, filling in the relevant data based on your selections with the mouse. With Row 10 selected, the menu’s second option will remove the whole row from your spreadsheet
Delete a Row Using the Right-Click Button
The right-click button offers a different way of quickly and easily removing a row.
1. Select the row you wish to delete
The first step is the same, whether you’re using the mouse or the edit menu. You can also use this method to delete multiple rows in Google Sheets. Just select all the ones you want to get rid of during this stage.
2. Press the Right Click Button
With your row selected, pressing the right click button will produce a contextual menu.
3. Choose “Delete Row” from the menu
Scroll down the contextual menu to locate the “Delete Row” option. Simply select it and click, and your excess row will disappear.
Using Keyboard Shortcuts While Deleting a Row in Google Sheets