'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
