In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at Crop Sheet by Eric Koleda.
Crop Sheet allows you to quickly crop a Google Sheet tab by your own selection or by the data in your sheet tab.
With over 1,000,000 installs this is a simple Google Workspace Add On that completes a specific job well.
What’s the alternative? A somewhat slower process of removing outer columns and rows by a whole lot of clicking, shortcut commands and time wasted.
Eric was a Developer Relations Infrastructure Manager at Google before moving to Coda.io (An all-in-one document tool for collaboration) as their Developer Advocate. I’d be pretty confident in this add on. 😉
You can also find the code for Crop Sheet on GitHub.
Check it out on the Google Workspace Marketplace: Crop Sheet
Check out more Episodes of GWAOw! here!
Have you ever wanted to split a list of Google Sheet rows in two by odd or even? Or had a time when you wanted to display all items in a range by odd or even ids in two separate lists?
You don’t have to do this manually, we can work smart and create a formula for each of these scenarios to easily separate your data.
In this tutorial, we will cover three scenarios:
- Separate a range of data by odd and even rows.
- Separate a range by odd and even where a selected column has a list of numerical ids.
- Separate a range by odd and even where a selected column contains a list of alphanumeric ids.
If you want to play along, you can get a copy of the starter sheet here:
Odd and Even | Starter Google Sheet*
*Contains Easter Eggs.
Continue reading “Displaying Odd and Even Row Data in Google Sheets”