Aug
9
Ultimate Suite 2018.4 is out!
I am happy to let you know that we have finally released Ultimate Suite 2018.4. To download it, just click the link below :)
Download Ultimate Suite for Excel 2018.4
General improvements
- The latest updates of Excel 2007 - 2016 and Windows 7 - 10 are completely supported including Windows 10 (update 1803) and Excel 2016 (update 1807).
- We've done hundreds of tests and can say for sure: this release is more stable than ever. Functional correctness and reliability are the goals we have achieved.
- Now the unified Select Range experience is included in all Ultimate Suite wizard add-ins.
New tools
- Compare Multiple Sheets highlights differences in two or more Excel worksheets. You can search for differences in values, formulas, or formatting:
- Cross-Sheet Cell Operations is a great assistant if you need to edit the same cell across several sheets, create references, copy, or sum same cells.
- Cross-Sheet Range Operations lets you copy same ranges in multiple sheets and aggregate either all same ranges together, or each one separately.
You will find these two utilities under one button, Cross-Sheet Operations:
Improved features
Now all the tools are even more speedy and efficient.
Overall, we have fixed 228 bugs, made 87 improvements, and implemented 16 new features:
| Tool | New | Improved | Fixed |
| Add Text | 3 | ||
| Calculate | |||
| Change Case | |||
| Column Manager | 1 | 2 | |
| Combine Sheets | 1 | 4 | |
| Comments Manager | 3 | 1 | |
| Compare Multiple Sheets | 1 | 3 | 4 |
| Compare Two Sheets | 1 | 7 | 14 |
| Compare Tables | 1 | 3 | |
| Consolidate Sheets | 1 | ||
| Convert Formulas | |||
| Convert Text | 1 | ||
| Copy Address | 2 | ||
| Copy Sheets | 1 | 1 | |
| Count Characters | 3 | 3 | |
| Count Words | 3 | 3 | |
| Create Cards | 2 | 1 | |
| Cross-Sheet Cell Operations | 1 | 4 | 25 |
| Cross-Sheet Range Operations | 1 | 7 | |
| Date and Time Formula Wizard | 1 | 1 | |
| Date Picker and Calculator | 4 | 4 | |
| Delete Blanks | |||
| Duplicate Remover | 1 | 3 | 7 |
| Extract Text | 1 | 2 | |
| Fill Blank Cells | 2 | 6 | |
| Filter | |||
| Find and Replace | 4 | ||
| Find Broken Links | 1 | 1 | |
| Find Similar Cells | 3 | ||
| Find Typos | 1 | 7 | |
| Flip | |||
| Fuzzy Duplicate Finder | 1 | 1 | |
| Insert Pictures | 1 | ||
| Merge Cells | 1 | 1 | 1 |
| Merge Duplicates | 1 | 4 | 9 |
| Merge Two Tables | 0 | 20 | |
| Quick Dedupe | 4 | ||
| Random Generator | 2 | 3 | |
| Remove Characters | 3 | ||
| Select by Value | 2 | 1 | |
| Select Randomly | 1 | ||
| Select Special Cells | |||
| Select with the Same Value/Font/Color | |||
| Shuffle | |||
| Split Names | 1 | ||
| Split Table | 2 | 6 | |
| Split Text | 3 | ||
| Sum by All Colors | 1 | 11 | |
| Sum by One Color | 2 | 7 | |
| Swap | 1 | ||
| Sync Selection | 1 | ||
| Table of Content | |||
| Transpose | 1 | ||
| Trim Spaces | 1 | ||
| Unpivot Table | 1 | ||
| VLOOKUP Wizard | 1 | 2 | 4 |
| Watermarks | 1 | 5 | |
| Workbooks Manager | 2 | 3 | |
| Core Features | 3 | 24 | 43 |
| TOTAL | 16 | 87 | 228 |
Excel formulas
CSV
Excel functions
Print
Financial functions
Vlookup
Merge data in Excel
SumIf
CountIf
Excel Compare
If statement
Excel Charts
Pivot Table
Conditional formatting
Excel formatting
Excel duplicates
Excel date
Excel tips
Excel macro
Outlook
Google Sheets
Outlook duplicates
Shared email templates
Category: Ablebits news
Table of contents
2 responses to "Ultimate Suite 2018.4 is out!"
Hi I discovered a small bug in the merge cells function. One of the options when merging columns is to separate the merged items by different symbols in the new merged column. If I select the "-" one, it does not appear.
Hello, Charles,
Thank you for contacting us. I’m really sorry that you are having difficulty with our add-in.
Our support team has just replied to you via email. Please check your Inbox and provide us with the requested details.
We'll do our best to help you.