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