'Google Sheets add-ons' category archive, page 2

Columns in Google Sheets - move, merge, hide and freeze columns in a spreadsheet

Today I invite you to learn a little bit more about columns in Google Sheets. Did you know that you can move and hide columns in your spreadsheet? And what about freezing and merging them? Let's explore these functions together! Continue reading

Date and time in Google Sheets: enter, format and convert dates and time in your sheet

Today we dig into the ways of working with dates and time in Google spreadsheet. See the ways of inputting date and time values into your table, learn why you may need to convert them to decimal, and find out about custom number formats Google tables offer. Continue reading

Google Sheets Chart Tutorial

Whether you analyze business indicators, make presentation or write a report, charts and graphs will help your audience to understand complex dependencies and regularities. This tutorial will teach you different ways to build charts and graphs in Google Sheets to make your presentations informative and impressive. Continue reading

Back to Basics: Google Sheets for newbies

It's not a secret that most people are used to work with the data tables in MS Excel. However, now it has a worthy competitor. Allow us to introduce you to Google Sheets. Continue reading

Google Sheets VLOOKUP with examples

A widespread opinion is that VLOOKUP is one of the most difficult and obscure functions. But that's not true! In fact, it's easy to do VLOOKUP in Google Sheets, and in a moment you will make sure of it. Continue reading

Google Sheets IF function - usage and formula examples

Get to know Google Sheets IF function better with this tutorial: when is it used, how does it work and how it contributes to a much simpler data processing. Formula examples are included! Continue reading

How to combine duplicate rows, merge values, and add subtotals in Google Sheets

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

How to Automate Your Spreadsheets with Zapier

Spreadsheets today aren't just static documents with data carefully managed on one computer. With Google Sheets and Excel's companion web app, your spreadsheets can get work done while you're away. Learn how you can automatically pull your data into a Google Sheets spreadsheet and set up workflows with Zapier. Continue reading

Video: How to merge cells and preserve original values in Google Sheets

See how you can quickly combine the cells with all their data in Google Sheets. Join text in columns, rows, or ranges with simple and flexible settings that our free add-on offers. Continue reading

Advanced search and quick replacements in Google Sheets

Learn about our recent addition to Power Tools that lets you perform advanced search in the entire spreadsheet, export rows with all found values, and replace any records you need. Continue reading

Video: How to remove duplicates in Google Sheets

Learn how to work with Remove Duplicates add-on for Google Sheets: quickly find unique entries, compare two columns or even tables for duplicate rows. Continue reading

How to get more Google Docs templates

When creating typical documents like an invoice or resume, you can get a much bigger choice of templates than the standard few files. Let's look at the add-ons that provide nice Google Docs templates and well-organized Google Sheets templates, learn how you can quickly replace custom fields and work with your docs more efficiently. Continue reading

How to count cells by color in Google Sheets

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

Ablebits add-ons go to the cloud

Have you heard the news? Ablebits add-ons are now available in the new Google Sheets. Use this exclusive opportunity to try out your favorite tools in the cloud for free! See the first add-ons that made the move and let us know what you think. Continue reading

Pages: 1 2