Power Tools for Google Sheets – V1.16. What's new?

Spring has arrived, bringing us a breath of fresh air, new possibilities, and the latest upgrade to your spring cleaning toolkit — Power Tools V1.16!

Our team has poured countless hours into this update, testing and fine-tuning its every aspect to ensure a seamless experience for you. We've listened to your feedback, and we're proud to say that this release is the result of your invaluable input combined with our team's expertise ;)

We invite you to work smarter, not harder, with these new features and improvements for Google Sheets.

Tip. Install the latest version of Power Tools from the Google Sheets store from the Google Sheets store and get ready to spring into productivity.

NEW: Compare sheets cell by cell for differences

Yet another comparison tool you may think… But think twice ;D This add-on doesn't just look for duplicates or uniques. It compares cells in each row between multiple Google sheets and marks all differences. Compare sheets cell by cell scheme.

There are 2 ways to track those differences:

  • have them highlighted and even described in a status column in each sheet.
  • have everything grouped in one comparison report in another spreadsheet for the whole picture in one place: Comparison report.

Video: how to compare Google Sheets for differences

I believe one demo video speaks better than words, so here are 2 minutes to see this new arrival in action:

This step-by-step guide describes each setting in detail and shows all possibilities offered by the comparison report.

NEW: Merge multiple lookup sheets in one go

Merge Sheets underwent some major changes as well. First and foremost, it finally lets you merge more than 2 sheets at a time: Merge multiple lookup sheets.

You add as many lookup sheets as you need on the 2nd step, and the add-on takes the required data from them one by one to your main sheet: Select several lookup sheets from your Drive.

I'm not going to go over all the details and other new features here since I announced them earlier in this blog post, but here are a few highlights:

  1. Insert additional matching rows. For when you also want to pull those extra rows that belong to the same key value: Additional matching rows right after the row with the same value.
  2. Pull notes along with their values from lookup sheets: Take notes along with their values to the main sheet.
  3. Add sheets from more places of your Drive: Search among shared or starred files.

NEW: Sum or count ALL colored cells

Function by Color now knows how to sum or count not just one but all colors in the range of interest. It builds one formula that returns the names of all colors with their calculated results: Sum all font colors of the range.

The settings are almost the same and you'll find them on the additional tab — All colors: All colors tab in Function by Color.

Tip. Learn more about each setting on the add-on help page.

NEW: Split sheet by any number of rows

The upgrade didn't bypass Split Sheet. It features a new way to split your table: by a certain number of rows: Split sheet by every N rows.

You'll be able to fine-tune the number in 2 ways:

  • enter the exact number to split rows by, e.g. by every 10 rows
  • or specify the groups of rows you'd like to see in separate sheets, e.g. 1-10, 11-50, 51-500

Tip. This detailed tutorial explains all bits.

NEW: Sort by color

Our Power Tools has acquired its own Sort by Color. And it works unlike the Google Sheets built-in tool, so I recommend you check it out anyway: Sort by Color in Power Tools.

Our add-on gathers all colors together and sorts them in the order you specify directly in the add-on: The result of the Sort by Color from Power Tools.

The built-in Google Sheets tool gathers only the rows of the selected color at the beginning of your table: The result of the standard spreadsheets Sort by Color.

So based on your task, you may need one tool or another. Another is in our Power Tools ;) These instructions will help you get started.

IMPROVED: Text tools process multiple non-adjacent ranges

The tools designed to process text — Add, Modify, Remove, Split, Extract — all now handle several non-adjacent ranges: Select multiple non-adjacent ranges by pressing Ctrl on your keyboard.

It means that rather than selecting each column individually and processing them one by one you can change all required columns with one tool in one go: Add text to multiple non-adjacent columns at once.

IMPROVED: Easier conditions in Multiple VLOOKUP Matches

Whenever you need to enter multiple words to see if cells contain/equal to/etc. at least one of them (OR condition), you can now simply copy the list of such words and paste it into the add-on. The tool will take them as parts of your condition automatically: Copy-paste the list of words to the add-on.

IMPROVED: Convert text in parentheses to negative numbers

The Convert tool now turns all text written in parentheses into negative numbers, just like Google Sheets does when you change the Number format: From the text in parentheses to negative number format.

And this is apart from the fact that Convert also recognizes more formats in general, including custom ones!

IMPROVED: Add favorite spreadsheets from your Drive

All add-ons that let you add files from Drive (Merge Sheets, Compare Sheets, etc.) will see your starred items as well. This is super useful if you want to instantly add some files of interest to handle it with the tool: Search among shared or starred files.

Video: Intro to Power Tools

You may also be interested in

Table of contents

Post a comment

Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)