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
Aug
27

Excel VLOOKUP not working – solutions for N/A, NAME and VALUE errors

The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel 2013, 2010, 2007 and 2003, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading

Aug
21

How to remove rows based on a cell value: shortcuts, VBA macros, delete every other row

This article lists several ways to delete rows in Excel 2010-2013 based on a cell value. In this post you'll find hotkeys as well as Excel VBA. Delete rows automatically or use the standard Find option in combination with helpful shortcuts. Continue reading

Aug
19

4 ways to do a case-sensitive vlookup in Excel

The tutorial explains how to make Excel VLOOKUP case-sensitive, demonstrates a few other formulas that can look up case in Excel and points out strengths and limitations of each function. Continue reading

Aug
14

The new improved version of Template Phrases for Outlook is out!

We released a new version of Template Phrases for Outlook 2013-2003. Some major and minor bugs are fixed and new macros are added. Now the file with your templates is moved to a new storage base which largely improves Outlook memory usage. Read on to learn more. Continue reading

Aug
12

INDEX & MATCH functions in Excel – a better alternative to VLOOKUP

This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. Continue reading

Aug
07

Relative and absolute cell references in Excel conditional formatting rules

Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run. Continue reading

Aug
06

How to hide and group columns in Excel

This tutorial shows how to hide columns in Excel 2010-2013. You will see the standard Excel Hide columns functionality in action as well as learn to group and ungroup columns with Outline. Continue reading

Aug
05

How to use VLOOKUP & SUM or SUMIF functions in Excel

In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria Continue reading

Jul
30

How to unhide and show hidden columns in Excel

From this article, you'll learn how to unhide columns in Excel 2010-2013. It will teach you to show all hidden columns or just the ones you select. Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed. Continue reading

Jul
29

Advanced VLOOKUP formula examples: 2-way lookup with multiple criteria

In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading

Jul
25

How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2010 - 2013. Continue reading

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