Remove Blank Rows - Google Workspace Marketplace

SW Apps; Sandcastle Software

• 437,228

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:

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

Robert Samia

August 5, 2020

Sweet work-around. Love it! Thank you much!!

A user of Remove Blank Rows

June 13, 2020

Google wont let me install

A user of Remove Blank Rows

May 27, 2020

Google wont let me install

A user of Remove Blank Rows

May 12, 2020

When will this be fixed! Its so helpful!

A User of Remove Blank Rows

February 12, 2020

Is this review helpful?

Yes

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?

A user of Remove Blank Rows

May 7, 2020

Power Tools ran out for me as well. Still waiting for this to be approved

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 :(

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)

É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

A user of Remove Blank Rows

February 10, 2020

As of FEB 10, still wont download. Google Authentication issue. So stupid.

A user of Remove Blank Rows

February 3, 2020

Same "Error" 03-Feb-2020

A user of Remove Blank Rows

January 21, 2020

Developer: Waiting on Google Review and acceptance.

A User of Remove Blank Rows

November 25, 2019

Hasn't worked once since I installed it

Is this review helpful?

Yes

A user of Remove Blank Rows

May 27, 2020

Delete

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.

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

A User of Remove Blank Rows

July 26, 2019

Cheap-

Is this review helpful?

Yes

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

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