Ultimate Suite of 20+ smart tools

This collection of 20+ quick and reliable tools will automate most of your daily tasks in Excel and increase your productivity at least by 50%!

More about Ultimate Suite for Excel

Remove duplicates in Excel

Duplicate Remover will quickly remove duplicates from your Excel worksheets or find uniques. Search in two Excel tables for duplicated rows, choose any columns for comparison.

More about Duplicate Remover

Merge Excel worksheets

Merge Tables Wizard quickly finds and merges matching data from the lookup Excel table to the main one.

More about Merge Tables Wizard

Combine duplicate rows

Combine Rows Wizard merges data from duplicate rows and pulls relevant unique information onto the same line in your table.

More about Combine Rows Wizard

Remove spaces, change case

With Cell Cleaner you get a quick way to trim excess spaces, change text case, convert text to numbers, remove non-printable characters and line breaks in your spreadsheets, and more.

More about Cell Cleaner

Consolidate multiple worksheets

With Consolidate Worksheets Wizard you can combine multiple Excel worksheets from different workbooks into one easily and quickly.

More about Consolidate Worksheets Wizard

Sum or Count Cells by Color

Count and Sum by Color calculates cell data according to their background or text color.

More about Count and Sum by Color

Merge Excel cells

Merge Excel cells, columns, rows keeping all data even if the selection contains multiple data values with the Merge Cells addin.

More about Merge Excel Wizard

Auto BCC in Outlook

Automatically send BCC (blind carbon copy) or CC in Outlook, create different rules and add exceptions for different e-mail accounts when sending your messages.

More about Auto BCC

Silently monitor outgoing e-mail

With Silent BCC for Microsoft Outlook you will have a BCC copy of every e-mail that leaves your company without sender knowing.

More about Silent BCC for Outlook

Reply to Outlook email with template

With Template Phrases add-in you can instantly insert commonly-typed text into your Outlook e-mails, share your templates with co-workers, use various macros and more.

More about Template Phrases for Outlook

Find and manage Outlook contacts

Use Smart Contacts add-in to have immediate access to your recent and favorite recipients; find and email the needed Outlook contact in a click.

More about Smart Contacts

Check email before sending

Outgoing Email Checker for Outlook will check your email before sending it for conditions you define in the rules.

More about Outgoing Email Checker for Outlook

Get notified on each important email

Important Mail Alert scans incoming emails for your alert key words and pops up a notification each time you get an urgent message.

More about Important Mail Alert

Check links in documents

Link Checker for Microsoft Word will find all broken or suspicious hyperlinks and cross-references in your document.

More about Link Checker for Microsoft Word

Create table templates

Table Template Manager will let you create and apply new table templates in your Word documents.

More about Table Template Manager for Word

Note&Do

Free add-in for Microsoft Word, Excel, PowerPoint and Outlook that comes in two parts: one for taking notes and the other for creating to-do lists in your Office applications.

More about Note&Do

 

Create Office add-ins in .NET

Add-in Express for Office and .NET is your all-in-one framework for developing commercial class extensions for all applications and all versions of the Microsoft Office suite, including Outlook, Excel, Word, PowerPoint etc.

More about Add-in Express for Office and .NET

Develop Office plug-ins in Delphi

Add-in Express for Office and Delphi VCL is the powerful platform for creating fast, compact and easy-deployable COM add-ins, Excel Automation add-ins, RTD servers and smart tags for Microsoft Office 2013-2000.

More about Add-in Express for Office and Delphi

Customize Outlook forms and views

Advanced Outlook View and Form Regions allows Outlook developers to extend Outlook views and forms with any controls in their .NET, VSTO on Delphi projects.

More about Advanced Outlook Regions

Program IE add-ons

Add-in Express for Internet Explorer is your all-in-one framework that offers a simple and quick way to build thread-safe, secure, isolated, deployable and context-sensitive add-ons for IE 6 - 10.

More about Add-in Express for Internet Explorer

Disable Outlook security

Using Outlook Security Manager you can bypass settings and avoid security warnings, alerts or prompts in add-ins and applications that interact with Microsoft Outlook.

More about Security Manager for Outlook

VDProj to WiX Converter

VDProj to WiX Converter is an extension for Visual Studio 2013 - 2005 that lets developers convert their existing Visual Studio setup project to a WiX Setup project in a click.

More about VDProj to WiX Converter

Remove Duplicates

Compare two sheets to delete the same values; dedupe a single table using one of two wizards that come with this add-on.

More about Remove Duplicates for Google Sheets

Split Names

Quickly derive first, last names and titles from the column with mixed names in your table. The add-on is taught to recognize dozens of suffixes and post-nominals for your convenience.

More about Split Names for Google Sheets

Merge Values

Join data from adjacent cells without touching your table. The add-on can copy values horizontally, vertically, or in the entire range, and place the results next to your original cells.

More about Merge Values for Google Sheets

Find & Replace

Add a sidebar for advanced search and replacement capabilities when working with your spreadsheet data.

More about Find & Replace for Google Sheets

Random Generator

Create unique raffle numbers and passwords, random dates within a certain time period, and get almost any type of data in the selected range using this Google Sheets add-on.

More about Random Generator for Google Sheets

Find Fuzzy Matches

Quickly check your table data for misprints. The add-on will list groups of fuzzy matches for you to review and correct.

More about Find Fuzzy Matches for Google Sheets

Power Tools

Get a set of smart solutions you have been missing: split text to columns, automatically sum numbers in every column, change case, polish up data format, get rid of unwanted characters.

More about Power Tools for Google Sheets

Table Styles

Apply style templates to data in your spreadsheets. The add-on comes with a set of pre-supplied table styles and the possibility to create your own.

More about Table Styles for Google Sheets

Join us on Facebook

Click Like and get 10% discount on all our products right now!

Customers say

I love the program!

I love the program, and I can't imagine using Excel without it! Ultimate Suite saves me many hours of effort with the projects I manage within Excel. The program paid for itself the first day I used it. You created a really great set of tools for use within Microsoft Excel. Thank you!!!
Robert Madsen

One word... WOW!

I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS!
Dave Brown

Featured customers

Ablebits.com featured customers
Jul
22

How to enable macros in Excel 2010-2013

This tutorial teaches how to enable macros in Excel. You'll also find step-by-step instructions showing how to disable macros in Excel or turn them on via Message bar and Backstage view. In addition you'll find a tip to run a macro even if all macros are disabled and get a link to a piece of code that gets users enable macros in a workbook. Continue reading

Jul
21

How to insert page numbers in Excel 2010-2013

This article explains page numbering in Excel 2010-2013. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly. Continue reading

Jul
17

Excel VLOOKUP tutorial for beginners - syntax and formula examples

This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading

Jul
15

How to insert and remove page breaks in Excel

The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2010-2013, where to find the Page Break Preview, hide and show the marking lines. Continue reading

Jul
10

How to use Excel COUNTIFS and COUNTIF with multiple criteria

The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading

Jul
09

How to rotate charts in Excel - rotate bar, column, pie and line charts

This post describes how to rotate a chart in Excel 2010-2013. You'll learn different ways to spin bar, column, pie and line charts including their 3-D variations. Besides, you'll see how to reverse the plotting order of values, categories, series and legend. Those who often print graphs and charts will read how to adjust the sheet orientation for printing. Continue reading

Jul
08

Transform your crosstab to list with Unpivot Table for Excel

If you’ve been searching the web for an easy and flexible way to unpivot data in Excel, you are in the right place at the right time. Ablebits have just released a new tool for Ultimate Suite. This little add-in will easily convert your crosstab table to a normalized list. Continue reading

Jul
02

COUNTIF in Excel - count not blank cells, greater than, with multiple criteria

The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading

Jul
01

Three brand new tools for your Excel

We added 3 new tools to Ultimate Suite for Excel. They are Count and Sum by Color, Unpivot Table and Create Cards. Read on to learn how you can calculate cells by color, flatten your summary tables, and convert your data into label cards. Continue reading

Jun
24

How to freeze panes in Excel 2013 and 2010 to lock rows and columns

In this short tutorial, you will learn how to quickly lock header row and first column in Excel. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. These tips work equally well in all modern versions of Excel 2013, 2010 and 2007. Continue reading

Jun
19

3 ways to count empty cells in Excel

If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading

Jun
18

How to count non-empty cells in Excel 2010, 2013

This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading

Jun
17

How to conditionally format dates in Excel – built-in rules and formulas

See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading

Jun
14

Easily print comments in Excel

In this article you’ll learn how to print comments in Excel 2010-2013, and other versions. Read this post if your task is to get cell notes printed at the end of the spreadsheet or if you need to copy them to paper as displayed in your table. Continue reading

Jun
13

Fastest ways to insert multiple rows in Excel 2010-2013

Inserting multiple rows in Excel may be one of the numerous tasks you come across daily. In today’s article, I hope to inspire shortcut-oriented users by showing some really quick ways to add new rows in Excel. You’ll also see how to solve this task using standard menus and Ribbon buttons and how to add empty rows between multiple data lines. Continue reading

Jun
12

How to import contacts to Outlook from Excel in 3 steps

In this article, I'll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading

Jun
10

Excel formulas for conditional formatting based on another cell

This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading

Jun
06

What are Excel sparklines and how to insert them to analyze your data

Do you know what Excel sparklines are and how helpful they can be? Read this article and find the answers to these questions. You will learn how to insert sparklines in Excel 2010 – 2013; change their type, style and color; highlight the most important points and remove sparklines from cells. Continue reading