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! We invite you to work smarter, not harder, with these new features and improvements for Google Sheets. Continue reading
In this article, I share all tips on how to make a table in Google Sheets. I'll go through native formatting tools and review one special add-on that you can use as a shortcut to paste styles to your sheets. Continue reading
Table Styles add-on has been a part of our Google Sheets arsenal for a long time. The time has come: the time for a major upgrade :) Version 2.0 brings a fresh simplified design (way better and user-friendlier looks) and opens up new possibilities to format your Google tables. Continue reading
Meet the brand new version of our Merge Sheets add-on – 2.0! New features and improvements to make your merge in Google Sheets even more precise and tailored to your liking. Continue reading
Did you know that when you merge 2 Google sheets you can not only update records in one column but also pull whole related columns and even non-matching rows? Today I will show you how it's done with VLOOKUP, INDEX/MATCH, QUERY functions and the Merge Sheets add-on. Continue reading
Today's blog post features all ways to merge 2 Google Sheets. You will use VLOOKUP, INDEX/MATCH, QUERY and Merge Sheets add-on to update cells in one sheet from records from another one based on matches in common columns. Continue reading
There are different ways to deal with duplicates in Google spreadsheets. But highlighting them is the best way to spot them instantly. Here you'll learn how to color duplicate cells, columns, and rows while ignoring or taking their first occurrences into account. Continue reading
Looking for a simple way to find duplicates in Google Sheets? How about 7 ways? :) That's all you need for numerous use cases :) I will show you how to use formula-free tools (no coding — promise!), conditional formatting and a few easy functions for avid formula fans. Continue reading
When you work with a large Google spreadsheet, you may find yourself constantly filtering the table to get only particular datasets. Wouldn't it be best to split all info into multiple separate sheets or even files in Drive? If so, today I invite you to split your sheets and spreadsheets together. Pick the way you want to get your data and follow the steps described there. Continue reading
This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading
Despite lots of perks offered by Google Sheets, it also has its drawbacks. A clear example of that is the shortage of simple tools to manage text. Are we bound to add or replace text in Google Sheets manually or with complex formulas? Not anymore. :) We've filled this gap with simple one-click tools. Allow me to introduce them to you in this blog post. Continue reading
In this article, you will learn about two ways of replacing all formulas with their results in a spreadsheet. Continue reading
If you ever needed to split text from one cell into separate columns or turn the table around so that columns become rows, this is your lucky day. Today I'm going to share a few quick tips on how to do that. Continue reading
It's time to talk about the ways of calculating time in Google Sheets. We'll discuss the ways of finding time difference in detail, see how to sum dates and time together, and learn to display only date or time units and set them apart completely. Continue reading
Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading
If you color-code your data in Google Sheets, you've probably noticed the lack of standard formulas that summarize this kind of information. In this article you will learn how to use our add-on to count and sum cells by color. Continue reading
