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

Merge Sheets

Find matching records in two sheets to update relevant rows of data in your main table. Five simple steps guide you through the process.

More about Merge Sheets add-on 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
Sep
03

More tools are added to Ultimate Suite for Excel

Our summer has been busy with developing 3 new tools for Ultimate Suite and with fixing some major and minor bugs. Now you can try the new add-ins for swapping, flipping, and transposing columns, rows, and cells in your table. Continue reading

Sep
01

Count & Sum by Color - the first Ablebits add-in for MAC is out

Do you have add-ins for MAC? This is one of the most popular support requests we get almost every day. It took our developers a while to look into the possibilities to create apps that would work in Excel 2011. Finally, about a week ago we received the long-awaited "Ready for Sale" from the MAC support team and Count & Sum by Color was published. Continue reading

Sep
01

How to insert new columns in Excel

This post looks at how to add up new columns in Excel 2010-2013. Read on to learn shortcuts to insert one or more columns, including nonadjacent ones. Grab and share a special VBA macros to automate adding every other column. Continue reading

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