Remove Blank Rows

Updated 09/09/2016 Developed by Steve Webster

The undo button conveniently restores the hide, but keep in mind this can only recall one previous hide action. If you need to revert back more than one unhide or undo a delete, use the native sheet's "Undo" (ctrl-z) option or click on "File" > "See revision history" and find the revision you would like to restore.

FAQs

Got too many blank rows or columns scattered in your sheet? Unlike MS Excel that requires six clicks to delete rows within a selected range that includes both blanks and data, simply click once with Remove Blank Rows. Watch the video.

Get it now.

Feedback

Please review FAQs before submitting feedback.

Is this a Google product?

No. However, as an experienced developer and former Google vendor, and Google Apps Script Top Contributor, 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 form and select "Customize for my organization" and provide an email and/or phone number.

How long is the free trial and how much will it cost?

Since March 11, 2014 Remove Blank Rows has been free to use. After adding more features on February 12, 2016, you may now send a $10 gift via a PayPal donate button. Free features will always remain free. Advanced Premium options offer a free trial before purchasing.

As of September 2016, Premium features became available (e.g. Unhide if not blank, Delete/hide conditionally). Free trial: You may try before you buy with 50 uses (e.g. clicking a premium Hide button is 1 use). After the free trial, it cost $0.05 USD per use. Plus, a $1 USD per purchase fee. When your Premium balance reaches zero, you may replenish your account by choosing among: 100 uses for $6 USD; 500 uses for $26 USD; or 1,000 uses for $51.

There are authorization requests. What is your privacy policy?

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).

What issues have been fixed?

Updated on 05/10/2016. Introducing "Premium Options" where you may try them before paying a fee. The fee is on-hold until more features become available. NOTE: The original remove features will always remain free.

Updated on 02/12/2016. New features added. Watch updated demo video to learn more.

  • Remove columns

  • Consider space characters as blanks

  • Process all sheet tabs

Updated on 03/10/2015. 1) Increased selected range row limit from 5,000 to 10,000 rows. 2) Due to Google Issue #4866 [caused blank sidebar], changed code from NATIVE to IFRAME user interface emulation. [Developers, learn how here.]

Updated on 02/12/2015. Increased selected range row limit from 1,500 to 5,000 rows. My concern with the limit is excessive processing time (especially over 5 minutes when Google Apps Scripts are stopped by Google servers). The add-on analyzes or searches for consecutive blank rows within the selected range so it limits the number of calls. However, if someone has thousands of rows that only have a single blank row in between other filled rows, then there are a lot of calls, which means slower processing times.

Updated on 03/16/2014. New feature! Now you can remove blank rows based only within the highlighted selected range. Blanks outside the range are ignored.

Updated on 03/13/2014. Fixed formula and format issues on delete rows. New Unhide button. Click "File" > "See revision history" to undo deletes and more than one hide actions.