Convert columns/rows to Named Ranges, Conditionally Format selection one column/row at a time, or sort horizontally.
Works with:
16K+
Overview
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'.
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Column Tools will ask for the permissions shown below. Learn more
Column Tools will need access to your Google account
This will allow Column Tools 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
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
SCASA Communications
January 19, 2022
Works great for making named ranges!
Is this review helpful?
Yes
No
Profile Picture
A User of Column Tools
March 31, 2020
I have a large spreadsheet shared with a group of 50 colleagues. We needed a tool that allowed us to sort horizontally, something that Google Sheets does not do normally. This add-on has been saved us. As an update: We recently decided to update a row to include hyperlinks. This would not work within the previous version of Column Tools, but after a quick bug report, Victor resolved the issue, much quicker than I would have expected as well. For this wonderful customer service, I am big fan!
Is this review helpful?
Yes
No
Profile Picture
A User of Column Tools
December 19, 2018
It only works if what you sort is only unsorted cells, so if I select a general area of cells sorted how I want some how I don't, it just doesn't sort. Can you fix that?
Is this review helpful?
Yes
No
Profile Picture
A User of Column Tools
July 26, 2018
I love it! Is it possible to have the same function for a row-per-row basis?
Is this review helpful?
Yes
No
Profile Picture
A User of Column Tools
November 28, 2019
It's sad that it can't handle vertical merges :'(
Is this review helpful?
Yes
No
1-5 of 5
Search
Clear search
Close search
Google apps
Main menu