Remove Google Sheet rows and columns, crop, trim spaces, and unhide rows with data. Note: replaces "Remove Blank Rows (and more!)" add-on.
Works with:
Need to quickly remove blank rows and columns? Need to crop your sheet with just data? Need to trim cells within a sheet? 

"Remove Rows and Files" provides a quicker way to get rid of those blank rows and columns, as well as, other helpful features.

Note: This add-on replaces "Remove Blank Rows (and more!)" add-on.

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. 

This add-on has been reviewed by Google and was developed by a GDE (Google Developer Expert). It is maintained by SW gApps LLC.

There is a free trial that expires after 7 button clicks. The subscription is billed annually starting from $0.25 USD per user per month ($3/year). Discounts for domains.

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

Features coming soon:
* Delete/hide rows conditionally using date, string, number, or exist.
* Archive/move rows conditionally to another sheet tab.
* Process All Sheet Tabs
* DRIVE: Soon this add-on will work in Google Drive like removing blank files or old active files.

See "Latest News" at: > Products > Remove Rows and Files
Additional information
PricingNot available
Trader status unspecified
Privacy policy
Terms of service
Remove Rows and Files will ask for the permissions shown below. Learn more
Remove Rows and Files will need access to your Google account
This will allow Remove Rows and Files to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu