App Icon
New "REMOVE ROWS and FILES" add-on replaces this add-on. Please install this new add-on here: https://workspace.google.com/marketplace/app/remove_rows_and_files/727322459637
By:
Works with:
507,820
Overview
* * * * * * * * * * * * * * *
New "REMOVE ROWS and FILES" add-on replaces this add-on, per the developer of both :)

Please install this new add-on here: 
https://workspace.google.com/marketplace/app/remove_rows_and_files/727322459637

Learn more here: 
https://sites.google.com/swgapps.com/publicnew/products/remove-rows-files?authuser=0
* * * * * * * * * * * * * * *

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.
Additional information
PricingNot available
Developer
Support
Privacy policy
Terms of service
Remove Blank Rows will ask for the permissions shown below. Learn more
Remove Blank Rows will need access to your Google account
This will allow Remove Blank Rows to :
View and manage spreadsheets that this application has been installed in
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Andrew Carbaugh
July 18, 2016
Removing rows is one thing, but this does far more than just that. The ability to include/exclude rows with partial data, and the hide vs. delete is tremendous. Well done. If you've ever had to delete hundreds or thousands of non-contiguous rows in a Google Sheet, you will appreciate it (even if it's just a few rows, the price is right...free). But donation toward this is well worth it too.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
August 28, 2017
great! remove the unneeded empty rows in all my tabs. considering that i have multiple tabs, close to hundred, or more, this is a time saver! highly recommended!
Is this review helpful?
Yes
No
Profile Picture
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?
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
April 7, 2015
We've created a sheet that contains data in 60 of its 100 rows, where the remaining (61 through 100) will be completed colaboratively by our users. I wish to delete all rows from 101 down, but am unable to with the Add-On since it deletes 61 through 100 as well. Manually deleting the remaining thousands of rows using 'edit' is just too time consuming.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
November 11, 2015
Did the trick (in just one click). Sorry for the horrible rhyme, the Add-on is really good.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
December 13, 2015
Awesome for those who use sheets regularly. Thanks a lot for creating this add one and saving lot of time of lot of people.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
March 8, 2015
This addon did not meet my needs in that it removed unblank cells in columns adjacent to a selected range, and I did not want it to touch anything outside said range. However, the developer contacted me and said he is writing another addon which will do what I need by shifting cells up like I imagined when I downloaded the addon. The addon does work great if you are planning to remove whole rows from your sheet, which is probably the more common application. I have been using Excel 2013 at work and I incorrectly assumed this addon would function exactly the same way.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
March 13, 2015
It worked perfectly, can be updated with more flexible ranges but as of now, it does the required trick.. Thanks to the developer!
Is this review helpful?
Yes
No
1-10 of 52
Search
Clear search
Close search
Google apps
Main menu