'Excel Add-ins by Ablebits' category archive, page 2
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
Video: Merge two Excel sheets in 6 simple steps
We have introduced some exciting changes to one of our best time-savers. This video will show you how Merge Tables Wizard can quickly and efficiently combine data from two Excel files. No formulas, no redundant work, just 6 simple steps to get the job done. Continue reading
Ultimate Suite compatible with Excel 2016 is out
The worldwide release of Office 2016 caused a lot of buzz among Microsoft users. So have we been moving full steam ahead to announce Ultimate Suite support for the latest version of Excel. Continue reading
Download Ultimate Suite 2016 BETA
Since Microsoft released Excel 2016 and Windows 10 Preview, we have been in a hurry to support them. Thus we are happy to report that we have just released an update of our flagship product Ultimate Suite for Microsoft Excel. … Continue reading
Try out super speedy Merge Tables Wizard BETA and share your feedback
What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading
Excel IF statement with multiple AND/OR conditions, nested IF formulas, and more
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
More tools 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
Three brand new tools for your Excel
We added 3 new tools to Ultimate Suite for Excel. They are Count and Sum by Color, Unpivot Table and Create Cards. Read on to learn how you can calculate cells by color, flatten your summary tables, and convert your data into label cards. Continue reading
Excel: How to add a hyperlink to another sheet
In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading
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
Meet the new Ultimate Suite release
Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading
Video how to: consolidate duplicate rows keeping unique data only
Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading
Take your Ultimate Suite to the next level
There is a lot of different software around us. Some of it really simplifies life, and some of it just doesn't. I want our Suite to fall under the first category. As this year started, I began collecting all the feedback our customers send to us to understand how we can make Ultimate Suite your reliable assistant in Excel... Continue reading
Got Office 2013? Ablebits add-ins are in!
Are you always the first to try new stuff? Here's something you'll like: all our add-ins support Microsoft Office 2013 starting today! Continue reading
Trim Spaces app for Excel - remove trailing and leading spaces
If you already moved to Office 2013 and miss Trim Spaces in your Excel, follow simple steps to regain the tool for finding and removing leading and trailing spaces in your worksheets... Continue reading
Excel Add-ins Collection by Ablebits: Faster and better
Lots of Excel users like Ablebits Add-ins Collection for its ability to speed up many tedious and time-consuming tasks they perform daily in Excel. There’s no limit to perfection, so our developers have been working hard on the collection optimization and finally introduced some really dramatic changes... Continue reading
