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.
Works with
Install
Overview
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.

Premium features:
Includes unhide if NOT blank, conditional delete or hide, and archive/move conditionally.
Reviews
A User of Remove Blank Rows
October 3, 2019
When you google something you wish existed, and find out it does. This is an unbelievable fix for something every sheet program should automatically have already! No more 1000 page printouts of empty boxes, finally you can bring sheets to a meeting in printed form.
Submit reply
Cancel
John Piechowski
June 9, 2019
Be careful with this add-on. I have tried to remove it and it will not remove from sheets. Now I'm concerned about what access it has to my files.
Submit reply
Cancel
A user of Remove Blank Rows
September 20, 2019
The add-on has a FEEDBACK link. Please submit with contact info so I can help you remove the add-on. NOTE: Removal is a Google process and not this add-on. Your data is always safe when using this add-on. Kind Regards, Steve Webster, Developer of this add-on
Gracie Walters
April 5, 2017
Helped So much with over 3000 rows! Thanks
Submit reply
Cancel
Justin Hurley
March 29, 2017
used to work but then randomly stopped
Submit reply
Cancel
A user of Remove Blank Rows
April 4, 2017
You may submit a feedback form within the add-on sidebar. It works when I use it.
A User of Remove Blank Rows
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
A User of Remove Blank Rows
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
A User of Remove Blank Rows
February 7, 2017
Works!
Submit reply
Cancel
A User of Remove Blank Rows
December 13, 2016
Works great for single use. Can you auto hide and unhide rows as data is added?
Submit reply
Cancel
A user of Remove Blank Rows
December 14, 2016
Thank you for the 5-star review! You may click the "Feedback" link within the add-on to submit your requests.
A User of Remove Blank Rows
November 24, 2016
Excellent add-on. Works as expected.
Submit reply
Cancel
Srikanth Silla
October 17, 2016
Works crisp!!
Submit reply
Cancel
1-10 of 40
Additional information
Search
Clear search
Close search
Google apps
Main menu