Ablebits blog

Posts tagged "Google Sheets", page 3

Oct

How to count colored cells 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 →

Products
Windows
Ultimate Suite for Excel Shared Email Templates for Outlook Mail Merge for Outlook Link Checker for Word
Mac Os
Text Toolkit for Excel Shared Email Templates for Outlook Mail Merge for Outlook
Outlook Online
Shared Email Templates for Outlook Mail Merge for Outlook
Google Workspace
Add-ons for Google Sheets Add-ons for Google Docs
Ultimate Suite
70+ professional tools for Microsoft Excel

This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays.

Merge multiple worksheets

Compare sheets for differences

Remove duplicates

Merge cells in Excel

Calculate dates and times

Combine sheets by column headers

Trim extra spaces

Count characters and words

Convert text to number

See all tools

Works for: Windows
Read more about Ultimate Suite
Shared Email Templates
Reply to routine emails faster than ever

Do not waste your time on composing repetitive emails from scratch in a tedious keystroke-by-keystroke way. Type your response just once, save it as a template and reuse whenever you want.

Quick replies for routine emails

Fully customizable templates

Gorgeous html-based designs

Dynamic templates with fillable fields

Comfortable template sharing

Custom-tailored bulk mailings

Company and team-wide signatures

Easy user and team management

Works for: Windows•macOS•Outlook Online
Read more about Shared Email Templates
Link Checker for Microsoft Word
Manage links in your document with ease

Find all links in your document, get them verified, correct invalid ones and remove unnecessary entries with a click to keep your document neat and up to date.

Search for all link types

Define link states

Edit multiple hyperlinks at a time

Sort and filter links by different criteria

Works for: Windows
Read more about Link Checker
Text Toolkit for Excel
35+ handy options to make your text cells perfect

Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click.

Trim extra spaces

Convert text to numbers

Count characters and words

Change letter case

Extract text or numbers

Remove text by its position

Split cells by symbol, string, or mask

Replace unwanted characters

Eliminate leading zeros

Swap text in your cells

Find, extract, replace, and remove strings by means of regexes

Merge columns, rows, or cells into one

Combine rows by duplicates

Works for: macOS•Excel Online
Read more about Text Toolkit
40+ tools to boost your Google Sheets
This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets.
Read more about Power Tools Try it for free

Add-ons for Google Sheets

Merge Sheets Function by Color Remove Duplicates Compare Sheets Substring Batch Toolkit Table Styles Advanced Find and Replace See all products

Add-ons for Google Docs

Search & Navigate Doc Tools Styles for Google Docs
Mail Merge
Ideal for newsletters, proposals, and greetings addressed to your personal contacts

Mail Merge is a time-saving approach to organizing your personal email events. It offers:

Customizable and adaptive mail merge templates

Personalized merge fields depending on the recipient or context

Dynamic attachments and images

Mailing lists based on Excel tables

"Send immediately" and "send later" scheduling

Works for: Windows•macOS•Outlook Online
Read more about Mail Merge
Downloads
- Current versions
- Archived versions
Documentation
Support
Blog
About us
Purchase