In this article we will show you how to delete empty rows in google sheets in just a few simple steps
For this demonstration an example sheet has been created. Click here to access the link and follow along at home.
Hold down the Ctrl (Cmd for Mac) key on the keyboard and left click on the rows you wish to highlight.
With your selections made, right click the row number of the last highlighted rows. A menu will appear. Click Delete selected rows.
The highlighted rows have been deleted and the data set is now clear of empty rows.
Click and hold down on the bottom right cell, dragging the selection to highlight the full set of data that you wish to edit, including row headers. Or alternatively right click the top row number, hold down and drag to the bottom.
Go to the toolbar and click data, from the dropdown click Create a Filter.
This will now create a filter, an icon will appear in the data header cells confirming this. Click either of the icons for a dropdown menu.
From the dropdown menu under Filter Values select Clear. This will untick all of the data just below the search bar in the dropdown menu.
Re-select (Blanks), ticking it from the options below the search bar and click ok.
All Data in the sheet will now be hidden and only the empty rows will show. These can now be deleted. To do this you need to highlight them by selecting the top row number (not including the row headers) and dragging downwards.
With all empty rows selected, right click the mouse anywhere on them and select Delete selected rows.
Click on the same filter Icon again in the Row header as before. From the dropdown click Select All and then ok to re-display your hidden data.
Data set is now cleared of unused rows and numerical order has been restored to reflect this.
We hope this article has helped you and given you a better understanding on how to delete empty rows in Google Sheets.
You might also like our article on deleting rows in Google Sheets and our tutorial on how to use the keyboard shortcut to delete rows in Google Sheets. On a side note, we also recommend reading our guide on how to get Google Sheets email notifications.
You can try our insurance renewal reminder software as well to optimize your workflow.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
