"Add-ins for Excel" category
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 Add Text for Excel. We investigated the problem and found out that Microsoft has prepared us and our users a surprise in the 1903 … 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
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: 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 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
Video: How to change text case in Excel
In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading
Video: How to remove extra spaces in Excel
Learn how to trim leading and trailing spaces, delete all blanks between numbers, and remove extra spaces between cell values in Excel using standard functions or a special add-in. Continue reading
What's new in Ultimate Suite - the latest changes in our top add-in for Excel
Ultimate Suite has become even better. We improved Consolidate Worksheets Wizard and Remove Characters, added the Clear Formatting, Split Text, Add Text add-ins and re-implemented Column Manager. Read this article to learn more. Continue reading
Video: how to merge and combine rows in Excel
This video will show four different solutions for merging rows of data, blocks of rows, or duplicate records from different lines in your table. Learn what formulas and tools you can use to combine rows in Excel and keep all important information intact. Continue reading
Video: Three ways to merge columns in Excel without losing any data
We often need to combine columns in Excel to get names, addresses, and similar records in one cell. As there are no built-in tools for merging values from multiple columns, see three ways you can go in this video. Continue reading