Column Tools is an increasingly inaccurately named tool that provides some useful tools for working with columns (and now rows) that are missing from Google Sheets. Currently there are four tools in this package.
The first tool is to apply conditional formatting on a column-by-column or row-by-row basis. Once you've applied your conditional formatting rules to the first column/row of a bunch, select that one plus the others you want to apply it to. The same conditional formatting rules will be applied to each column/row in your selection. This is useful if your columns/rows have different maxima and minima that you want to highlight.
The second tool is to create Named Ranges named after the first cell in each column or row. Select a bunch of columns or rows, and it will set each column/row to be a Named Range, with the name set to the value in the first cell in that column/row.
Both functions work with a single block selection, or multiple selection areas.
The third tool is to sort a range or an entire sheet horizontally using a specified row (please note this has not been tested extensively - use with care and please report any issues).
The fourth and latest tool flattens a sheet into two columns. This is useful for some database-like operations. You could think of this as an 'un-pivot'.
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
