Check out the store for many more

Remove Blank Rows (and more!)

80,030 users


Got too many blank rows or columns scattered in your sheet? Delete or hide them with 1 click. Watch the video.
* * * NEW Premium Options with Free Trial * * *

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.

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.

Updated on 09/09/2016:
More free options. 1) Crop empty ending rows/columns, 2) Remove/trim spaces within cells.
Premium options available with free trial. 1) Unhide if not blank, 2) Delete/hide rows conditionally.

Updated on 05/09/2016:
Not only remove rows and columns, and now crop and unhide tools. More premium options coming soon.

Updated on 02/12/2016:
Optionally, remove columns, consider space-bar characters as blanks, process all sheet tabs at once.

Updated on 04/09/2015:
Fixed recent unexpected broken links to website and video.

Updated on 03/10/2015:
Increased range selection rows maximum to 10,000.

Updated on 02/12/2015:
Increased range selection rows maximum to 5,000.

Updated on 04/23/2014:
Increased range selection rows maximum up to 1,500.

Updated on 03/16/2104:
New feature. Choose between "All rows must be blank" or "Only rows within the range" (ignores row cells outside of highlighted selected range).

Updated on 03/13/2014:
Fixed formula and format issues. New Unhide button. Click "File" > "See revision history" to undo deletes.


Version: 38
Updated: November 16, 2017
Language: English (United States)