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.

Options:
* 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: www.SWgApps.com > Products > Remove Rows and Files