'Excel Add-ins by Ablebits' category archive

Hotfix for Windows 10 update 1903: Excel and Outlook add-ins

Recently we have received a few reports about problems with our task pane-based add-ins, such as Template Phrases for Outlook or Add Text for Excel. We investigated the problem and found out that Microsoft has prepared us and our users … Continue reading

How to merge two or more tables in Excel

It is a very common situation when different pieces of data are dispersed across many worksheets and workbooks. Fortunately, Excel provides a few tools to combine data from multiple tables into one, and this tutorial will teach you how to use these tools most effectively. Continue reading

Ultimate Suite 2018.4 is out!

We have finally released Ultimate Suite 2018.4. Learn more about the new tools, essential changes, and improvements. Continue reading

Ultimate Suite 2018.3 is released!

I am glad to let you know that we have finally released Ultimate Suite 2018.3. In this post, you will find a list of the essential changes and improvements. Continue reading

Enabled Preview in Windows Explorer causing issues with Excel and Excel add-ins

When you preview Excel files in Windows Explorer, you may experience some difficulties with the Ablebits add-ins and with the Office 365 applications themselves. In this post you'll find out how the problem can be displayed in Excel 2016 and how it can be solved. Continue reading

8 ways to add bullet points in Excel

Excel does not provide a built-in feature to make bulleted lists like most word processors including Microsoft Word do. But that doesn't mean there is no way to insert bullet points in Excel. In fact, there are at least 8 different ways, and this tutorial covers them all. Continue reading

How to load the Ablebits add-in in Office 365 installed from Microsoft Store

In this post we'd like to share the solution to the problem that the Ablebits users have encountered recently. The issue occurs in Office 365 installed from Microsoft Store. If you use this version of Office on your machine, the Ablebits product may not appear in Excel after the installation and you will have to add it manually to the Office application. Continue reading

Ultimate Suite 2018 for Excel: how to get it for free

We are working on a new "secret weapon" to be included in the upcoming update and striving to make its UI perfectly intuitive. For your help we'll happily present you the new Ultimate Suite 2018. Continue reading

Ultimate Suite 2018 is out: get it with the best discount

Ultimate Suite 2018 is out! Stable version, clear and efficient user interface, and wide platform support. In the new Ultimate Suite for Excel 2018 you will find several time-saving brand new tools. Xmas offer: upgrade the Suite with a 60% discount. Continue reading

Video: Excel date formulas made easy

This video will show you how to get Excel date formulas of any complexity without actually writing them. Learn how you can find the number of days between two dates, calculate age, add and subtract dates in Excel with your personal date&time formula assistant. Continue reading

Video: 6 ways to merge Excel sheets with 1 add-in

Combining data from multiple sheets becomes effortless if you have Consolidate Worksheets Wizard for Excel. See all the ways this add-in lets you copy, consolidate, and merge data from your tables. Continue reading

How to capitalize first letter in Excel cells

How can we change the case of the first letter from lower to upper in Excel cells? Do we have to type each character manually into every cell? Not anymore! Today I will share three methods of capitalizing first letters in your table. Continue reading

Excel MOD function to get remainder and more

The Excel MOD function is designed to get the division remainder, but it can do much more than its original purpose. In this tutorial, you will find a few non-trivial uses of MOD in Excel that may prove useful in your worksheets. Continue reading

How to calculate standard deviation in Excel

In statistics, the arithmetic mean and standard deviation are two closely related concepts. But while the former is understood by most, the latter is comprehended by few. The aim of this tutorial is shed some light on what the standard deviation is and how to calculate it in Excel. Continue reading

Enjoy new year with the new versions of Ultimate Suite for Excel and Add-ins Collection for Outlook

It’s that time of year again – the time of resolutions, surprises and gifts. We are celebrating by setting up new goals and releasing new versions of Ultimate Suite for Excel and Add-ins Collection for Outlook. Continue reading

Video: How to remove blank rows in excel

If empty rows interfere with your work in Excel, see how to pick the right way to deal with them and avoid a common mistake. You will learn about a special tool to delete all blank rows in a click, the formula that lets you quickly find them, and a way to remove rows that miss certain records. Continue reading

Video: How to remove line breaks in Excel

See our quick tips for deleting carriage returns from the cells in your Excel table Continue reading

Video: How to merge duplicate cells in Excel

Learn different ways you can combine unique values or sum numbers that refer to the same record in Excel Continue reading

Video: How to find and remove duplicates in Excel

See three simple ways you can find and remove duplicates in Excel: use standard functions, Conditional Formatting, or a special add-in. Continue reading

Video: How to compare two columns in Excel

There are quite a few ways you can find matches and differences between columns. We suggest trying one of three reliable methods described in this video any time you need to compare columns in the same or in different sheets. Continue reading

Pages: 1 2 3