Remove Rows & Files
Remove Rows & Files add-on
Sheets: Got too many blank rows or columns scattered in your sheet? Delete or hide them with 1 click. Watch the video.
Drive: Got too many files in Drive and want to find blank files and remove them? (coming soon).
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.
More features like crop, unhide, and conditional options. Learn more here.
Need a custom add-on? Contact us.
NOV 30 2020: Going from old to new .. When add-ons launched 5+ years ago, Remove Blanks Rows was introduced. Recently, Google has introduce a new type of add-on, Google Workspace Add-ons (GWAO). This new type is card-based with an improved user interface. As a result, there are now two versions of Remove Blank Rows, the old and the new GWAO version. Soon the old version will be removed so please use the new GWAO version going forward.
Is it free? The new version has a 7 button clicks free trial. Maintaining and supporting over 400,000 installs without revenue is challenging. To show your "love" and support for this popular add-on, please consider paying the reasonable fee of $0.25/month per user (paid annually). Discounts for domain organizations.
Note Domain Installation: According to Google, Workspace add-ons are not fully rolled out yet for all customers (completed about mid January 2021). However, you can switched to quick release cycle in the Admin Panel. Tip: if the Sheets right vertical icon panel displays the plus (+) sign, then you know its rolled-out.
Delete/Hide blank rows or columns.
Consider space characters as blanks.
Crop ending empty rows/columns: This sheet tab.
Remove/trim spaces within cells: This sheet tab.
Unhide if NOT blank.
Coming soon for GWAO version:
Delete/hide rows conditionally using date, string, number, or exist. Then select the column letter.
Archive/move rows conditionally to another sheet tab.
Process All Sheet Tabs
DRIVE: Soon this new add-on will work in Google Drive like removing blank files or old active files.
Your feedback is most welcomed. Support link is available in sidebar.
Would you like to send SMS text messages from Google Sheets? Try the Text gBlaster (SMS Texting) add-on.
"Exceeded maximum execution time": This may occur if it takes longer than 45 seconds to delete rows, because of Google's execution quota limits. We will update the add-on to speed this execution time and/or batch the process. Expected to be resolved by January 8, 2021. In the mean time, shorten the range of rows.
The Remove Blank Rows add-on requires access to the active spreadsheet only. There is no collection of user data. The three services that invoke authorizations from the user are Spreadsheet service (to hide or delete rows in active sheet), Script Properties service (new version announcements), and External service (paying for Premium options using secured Stripe service). Learn more on the Privacy page.
Is this a Google product?
No. However, as an experienced developer and former Google vendor, and GDE (Google Developer Expert), best practices were followed to ensure user friendliness and results.
What is "Select a range"?
Simply highlight the desired rows. Watch the video for an example.
I need to "undo" more than one iteration. How?
You are correct that the Remove Blank Rows "Undo Hide" button was designed with one convenient undo iteration. For more iterations for both Undo Hide and Delete:
Click the sheet's "File" > "See revision history".
Click the "Show more detail revisions" button.
Review each revision history item (from top to bottom) until you find the desired revision.,
Click the link "Restore this revision".
OR, click the sheet's "Undo" (ctrl-z) multiple times.
Not all blank rows were deleted or hidden. Why?
Review the row in question, and if you find that all cells are indeed blank (make sure the font color has not given the illusion of a blank cell), then use the Feedback form to report the issue and provide a link to your spreadsheet (or a copy of it) for troubleshooting purposes. Also, watch the demo video.
How can my organization get a customized version?
Submit the request in the Feedback (Support) form and select "Customize for my organization" and provide an email and/or phone number.
What issues have been fixed?
None reported at this time.