This article was co-authored by How.com.vn staff writer, Travis Boylls. Travis Boylls is a Technology Writer and Editor for How.com.vn. Travis has experience writing technology-related articles, providing software customer service, and in graphic design. He specializes in Windows, macOS, Android, iOS, and Linux platforms. He studied graphic design at Pikes Peak Community College.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 1,659 times.
This How.com.vn teaches you how to delete empty rows in Google Sheets using three methods. You can remove empty rows by deleting them individually using a filter, or an add-on that will remove all blank rows and cells.
Steps
Deleting Rows Individually
- Go to https://sheets.google.com in a web browser. If you are logged into Google, this brings up a list of Google Sheets documents associated with your account.
- Log in to Google if you have not already done so.
- Click a Google Sheets document.
- Right-click the row number. Rows are numbered in the grey column to the left.
- Click Delete Row.Advertisement
Using a Filter
- Go to https://sheets.google.com in a web browser. If you are logged into your Google account, this will open up a list of the Google Sheet documents associated with your account.
- Click a Google Sheets document.
- Click and drag to select all of your data.
- Click the Data tab. It's in the menu bar at the top.
- Click Filter.
- Click the green 3-lined triangle icon in the top-left cell.
- Click Sort A → Z. This will move all your empty cells to the bottom.Advertisement
Using an Add-on
- Go to https://sheets.google.com in a web browser. If you are logged into your Google account, this brings up a list of the Google Sheet documents associated with your account.
- Click a Google Sheets document.
- Click the Add-ons tab. It's in the menu bar at the top.
- Click Get Add-ons.
- Enter Remove Blank Rows in the search bar and press ↵ Enter.
- Click + Free. It is across from "Remove Blank Rows (and More)". This add-on has an image of an eraser.
- Click your Google account. If you have multiple Google accounts, you may be asked which account to apply the Add-on to.
- Click Allow.
- Click the Add-ons tab again. It's in the menu bar at the top.
- Select Remove Blank Rows (and More).
- Click Delete Blank Rows/Columns. This will open the add-on options in a column on the right.
- Click the blank gray cell in the top-left of the spreadsheet. This will select the entire spreadsheet.
- You can also press Ctrl+A to select everything.
- Click Delete. This is found in the add-on options for "Remove Blank Rows (and More)".Advertisement
Expert Q&A
About this article
To delete a row in Google Sheets, right-click the row number and select Delete row.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.