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.

I wish sometimes that all in our life was as easy as using Ultimate Suite. One button serves the dinner and another explains certain life problems. Still, to be individuals, we need to solve issues and devote to the things requiring our attention. Here at Ablebits we are happy to create tools freeing up your time for what is more important to you.

To save more of the time you spend with Excel, we added 3 new tools to Ultimate Suite. Ablebits Data tab welcomed Swap Ranges, Flip Range and Transpose Range. In this article, you'll find a brief description of their functionality.

Try the updated Ultimate Suite for free

If you are too busy with spreadsheets and don't have enough time to implement your long-nurtured ideas, 40+ tools from Ultimate Suite will take care of the most laborious tasks. Take advantage of the free trial download.

  Download new version now  

Swap columns, rows, or cells

Once a colleague of mine misentered some data in an important report. He saw that simple switching of two ranges requires several temporary columns and much copying and pasting. Thus, he offered to create a special add-in for such task.

Here comes Swap Ranges that switches the contents of the selected columns, rows, or cells and preserves formulas and formatting.
Swap columns, rows or cells in your Excel tables

Flip data vertically or horizontally

If you flip data order in your worksheet every now and then, most likely you already know that the process involves hard coding or modifying all columns at once. Now you can reverse exactly the selected data top to bottom or left to right with the help of the Flip Range tool.
Flip data in Excel vertically or horizontally

Convert rows to columns and vice versa

The third tool we added to your Ultimate Suite will modify the layout of your table. When you receive a report and realize that it will work much better if rows become columns, simply employ Transpose Range.
Convert rows to columns and vice versa

We hope that the new tools for range operations will help you save even more time for important things. As always, you are welcome to leave your comments and express your ideas. Be happy and excel in Excel!

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard