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

Generate random values

Random Number Generator fills the range with unique random numbers, dates, random strings of any length and pattern.

More about Random Number Generator

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

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
Apr
15

Send secure email in Outlook 2010 and 2013 using digital signature

Learn about Outlook digital signature, encrypting email connections with SSL, and other ways to send secure email messages in Outlook 2010 and 2013. Continue reading

Apr
11

Email encryption in Outlook – how to encrypt all or individual messages with digital ID

Learn how to use email encryption in Outlook 2010 and 2013 to protect your email messages against unauthorized reading. What Exchange hosted encryption is and how send secure encrypted emails between Outlook and other emails clients. Continue reading

Apr
04

Writing persuasive request letters: business letter format, tips and samples

Do you know how to write business letters to convince your recipient to respond or act? And what is the correct letter format? Read the article to find the answers as well as examples of persuasive request letters such as character reference, letter of recommendation, request for information, donation /charity request and more. Continue reading

Mar
28

How to quickly move Excel spreadsheets online, share and embed on a web page

With the emergence of Excel Online, you no longer need cumbrous HTML code to export your tables to the web. Just save your workbook online and access it literally from anywhere, share with other users and work on the same sheet all together. Continue reading

Mar
21

How to convert Excel tables to HTML

If you created a pretty Excel table and now want to publish it online as a web page, the simplest way is to export it to an old good html file. In this article, we are going to explore several ways of converting Excel data to HTML, determine pros and cons of each, and walk you through the conversion process step-by-step. Continue reading

Mar
19

Get the new Ultimate Suite and save another 10 minutes every day.

For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading

Mar
19

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

Mar
13

Alternating row colors and column shading in Excel (banded rows and columns)

This tutorial explains how you can alternate row colors in Excel and automatically apply shading to every other row or column in your worksheets. You will also learn a few smart formulas to highlight banded rows and columns with 3 different colors and to shade groups of rows based on a value change. Continue reading

Mar
6

How to convert rows to columns and vice versa, transpose tables in Excel

In this article, you will find several ways to convert rows to columns (or columns to rows) in Excel, whichever you call it, it's the same thing : ) These solutions work in all versions of Excel 2013, 2010, 2007 and lower, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading

Feb
28

The new versions of Duplicate Remover and Merge Cells are out

The most important and hopefully noticeable improvement is a faster start of the add-in. In addition, we have optimized the performance and fixed a few minor bugs. As usually, you can download the new versions from the Trial downloads page of from the Registered users area.

Feb
27

How to split cells in Excel: Text to Columns, Flash Fill and formulas

In this article you will find several options to split cells and entire columns in Excel 2010 and 2013. Examples and screenshots illustrating the use of Text to Columns and Flash Fill features as well as a handful of formulas to separate names, text and numerical values will help you choose the best approach for splitting your data in Excel. Continue reading

Feb
26

How to get email read receipt and delivery receipt in Outlook

Do you want to make sure that people get your emails? Outlook delivery and read receipts will notify you when your message is delivered and opened. In this article you will learn how to track sent messages and disable read receipt requests in Outlook 2010 and 2013. Continue reading

Feb
25

The new versions of Cell Cleaner and Combine Rows Wizard are out!

The most important and hopefully noticeable improvement is a faster start of the add-in. In addition, we have optimized the performance and fixed a few minor bugs. As usually, you can download the new versions from the Trial downloads page of from the Registered users area.

Feb
21

How to print row and column headers of Excel spreadsheets on every page

Today I'd like to tell you about a small but important feature tucked away in Excel 2013 and its previous versions. In this article you’ll learn how to make header rows and column headers print on each page Continue reading

Feb
20

How to create and use e-mail templates in Outlook 2010 and 2013

Rather few people know that email templates exist in Outlook and even fewer know how to create and use them in the right way. In this article you will learn how to create, save and use standard Outlook email templates. You will also find how to reply with template in Outlook 2013, 2010 and lower or automatically add a template of your choosing to all new e-mail messages, replies or forwards. Continue reading

Feb
13

What blind carbon copy is and how to add Bcc in Outlook

Do you know what the blind carbon copy in email messages is and in what way Bcc is different from Cc? Do you know how to automatically add Bcc on all email messages you send in Outlook and how to always Bcc yourself? If not, you will find all the answers in this article. Continue reading

Feb
06

How to merge rows in Excel 2010 and 2013 without losing data

This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading

Jan
31

How to configure Outlook Junk Mail Filter to stop spam email

This article explains how to configure Outlook Junk Mail Filter properly to stop as many junk emails as possible. You will also learn how to keep you filter up to date, take a good message out of the Junk folder and ensure that no legitimate e-mails will get there. Continue reading

Jan
23

How to swap columns in Excel by dragging and other ways to move columns

In this article you will learn a few methods to move columns in Excel tables. You will see how to drag columns with a mouse and how to swap several non-contiguous columns. The latter is often considered unfeasible, but I'll show you a tool that allows moving even non-adjacent columns in Excel 2013, 2010 and lower. Continue reading

Jan
22

How to view, change and remove document properties in Excel 2010 and 2013

The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2010 and 2013. In this article you’ll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet. Continue reading

Jan
21

Working with Maps in Excel 2013

Yes, now it is possible to work with nice charts that have Maps in Excel 2013. In this article you will learn how to create cool reports in Excel. We will show countries, cities and specific geographical points. This article is for newbies who want to learn about this exciting area. Continue reading