Help & Support
Send Feedback
Remove Blank Rows
Got too many blank rows scattered in your sheet? Delete or hide them with 1 click. Watch the video.
sites.google.com/site/swgapsp
224,039 users
Works with
Install
Overview
* * * NEW Premium Options with Free Trial * * *

Do you have Sheets that contain nagging blank rows or columns and it takes a lot of time to delete or hide them and not to mention the risk of accidentally deleting the wrong rows or columns? If you do, get this add-on to quickly get rid of them. Once you have the add-on, click the video demo link.

Authorizations:
A one-time Google Sheets authorization is required from you to grant the add-on permissions to update your sheet.

About the developer:
Steve Webster is a trusted recognized Google Apps Script Top Contributor (TC), Google Drive TC, Google Docs TC, a former Google vendor, and guest blogger on Google Apps Developer Blog.

Updated on 09/09/2016:
More free options. 1) Crop empty ending rows/columns, 2) Remove/trim spaces within cells.
Premium options available with free trial. 1) Unhide if not blank, 2) Delete/hide rows conditionally.

Updated on 05/09/2016:
Not only remove rows and columns, and now crop and unhide tools. More premium options coming soon.

Updated on 02/12/2016:
Optionally, remove columns, consider space-bar characters as blanks, process all sheet tabs at once.

Updated on 04/09/2015:
Fixed recent unexpected broken links to website and video.

Updated on 03/10/2015:
Increased range selection rows maximum to 10,000.

Updated on 02/12/2015:
Increased range selection rows maximum to 5,000.

Updated on 04/23/2014:
Increased range selection rows maximum up to 1,500.

Updated on 03/16/2104:
New feature. Choose between "All rows must be blank" or "Only rows within the range" (ignores row cells outside of highlighted selected range).

Updated on 03/13/2014:
Fixed formula and format issues. New Unhide button. Click "File" > "See revision history" to undo deletes.
Reviews
April 5, 2017
Helped So much with over 3000 rows! Thanks
Submit reply
Cancel
March 29, 2017
used to work but then randomly stopped
Submit reply
Cancel
April 4, 2017
You may submit a feedback form within the add-on sidebar. It works when I use it.
March 26, 2017
Did not work well with multiple tabs and sheets. In process of constantly refreshing my screen to no avail. Lots of potential for smaller sheet work, but not at the level I need it.
Submit reply
Cancel
March 10, 2017
needed this to delete all the empty cells in a selected column and it worked perfectly. Saved me a lot of time.
Submit reply
Cancel
February 7, 2017
Works!
Submit reply
Cancel
January 6, 2017
Worked like a charm!
Submit reply
Cancel
December 13, 2016
Works great for single use. Can you auto hide and unhide rows as data is added?
Submit reply
Cancel
A Google User
January 6, 2017
Did you get this answered? Dying to find a way to have empty rows deleted from a referenced array that sometimes has many rows full and sometimes none....
December 14, 2016
Thank you for the 5-star review! You may click the "Feedback" link within the add-on to submit your requests.
November 24, 2016
Excellent add-on. Works as expected.
Submit reply
Cancel
October 17, 2016
Works crisp!!
Submit reply
Cancel
July 21, 2016
Works perfectly
Submit reply
Cancel
1-10 of 42
Additional information
Search
Clear search
Close search
Google apps
Main menu