SW Apps; Sandcastle Software
•  389,751
Overview
Got too many blank rows scattered in your sheet? Delete or hide them with 1 click. Watch the video.
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
Language:
Sort by:
Profile Picture
A User of Remove Blank Rows
March 14, 2020
I love this add-on and hope it comes back to life soon. In the meantime, you can select and delete rows and columns to the right and bottom of your data table. This isn't as fancy but is a workaround to shrink some simple data tables for printing. To Delete All Columns to Right of Data - First, select the first empty column at the right of your data, then hold Shift+Control and tap Right Arrow - Second, select 'Delete columns X - Y' from the edit menu. Delete All Rows Below Data - First, select the first empty row at the bottom of your data, then hold Shift+Control and tap Down Arrow - Second, select 'Delete rows X - Y' from the edit menu.
Is this review helpful?
Yes
No
Profile Pciture
A user of Remove Blank Rows
June 13, 2020
Google wont let me install
Profile Pciture
A user of Remove Blank Rows
May 27, 2020
Google wont let me install
Profile Pciture
A user of Remove Blank Rows
May 12, 2020
When will this be fixed! Its so helpful!
Profile Picture
A User of Remove Blank Rows
February 12, 2020
Sign in with Google temporarily disabled for this app!
Is this review helpful?
Yes
No
Profile Pciture
A user of Remove Blank Rows
May 11, 2020
Looks like it's been 3 months and it still hasn't been approved by Google?
Profile Pciture
A user of Remove Blank Rows
May 7, 2020
Power Tools ran out for me as well. Still waiting for this to be approved
Profile Pciture
A user of Remove Blank Rows
April 21, 2020
The power tools app only has a limited free use time which for me has expired :(
Profile Pciture
A user of Remove Blank Rows
March 17, 2020
While we're waiting for this app to be approved, the alternative app Power Tools also has this feature (buried among its many features)
Profile Picture
Éamonn Roarke
December 11, 2019
Just added this and Google wont allow the APP to authenticate, I see below that there is a review process since Nov 2019 for authentication. Can you update us on progress of this review and when we can use the app
Is this review helpful?
Yes
No
Profile Pciture
A user of Remove Blank Rows
February 10, 2020
As of FEB 10, still wont download. Google Authentication issue. So stupid.
Profile Pciture
A user of Remove Blank Rows
February 3, 2020
Same "Error" 03-Feb-2020
Profile Pciture
A user of Remove Blank Rows
January 21, 2020
Developer: Waiting on Google Review and acceptance.
Profile Picture
A User of Remove Blank Rows
November 25, 2019
Hasn't worked once since I installed it
Is this review helpful?
Yes
No
Profile Pciture
A user of Remove Blank Rows
May 27, 2020
Delete
Profile Pciture
A user of Remove Blank Rows
December 7, 2019
New installs from late November 2019 are experiencing an issue because Google is asking the developer to resubmit for approval. This may take a couple of weeks. Sorry for the inconvenience.
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
July 26, 2019
Cheap-
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Pciture
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
Profile Picture
A User of Remove Blank Rows
November 15, 2018
Awesomely useful! Shows the potential of gApps. Hopeful for more easy to use solutions like this. BRAVO!
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Blank Rows
July 7, 2018
wow love it!
Is this review helpful?
Yes
No
Profile Picture
Mehul Mistry
June 28, 2018
Unhide if not blank is a really neat feature.
Is this review helpful?
Yes
No
1-10 of 50
Additional information
SW Apps; Sandcastle Software
Terms of Service
Search
Clear search
Close search
Google apps
Main menu