ASAP Utilities puts all sorts of tools you've wanted or never imagined onto one Excel ribbon.
Excel add-in ASAP Utilities piles so many features onto Excel, it can make you dizzy. You can convert text to uppercase, lowercase, or proper case (first word capitalized), merge and import multiple files, and copy a selection to the clipboard as HTML. Jobs that you could already do get grouped logically into one place. For instance, the Vision Control dialog box lets you hide and unhide gridlines, page breaks, tabs, and scroll bars. You can easily reverse the order of selected cells, fill a range with random numbers, and change hyperlinks to hyperlink() formulas.
The ASAP selection tools alone are enough to turn any Excel power user into an ASAP Utilities addict. You can select the cell with the smallest or largest number, select all cells containing an error, inverse the selection, and select the same block of cells on every page in the file.
This Excel add-in puts all of these options, and many more, on a new Excel ribbon. This pull-down menu-filled ribbon is a bit crowded, but you can make your favorite tools more accessible. The first item on that ribbon is a configurable pull-down menu called "My favorite tools."
And should your number crunching get too frustrating, you can relieve the tension with the Funny (error) messages tool, which simply displays make-believe, whimsical error messages. I just got "Runtime Error 60 at 417A:32CF: Incompetent User."
Note: This software is free for personal use only. Business users must pay $49 at the end of a 90-day trial period.
This story, "Supercharge Excel with ASAP Utilities" was originally published by PCWorld.
Windows 10's cumulative updates have ballooned in size, and a similar bloat will affect the Windows 7...
The attacks that overwhelmed the internet-address lookup service provided by Dyn today were well...
In a federal lawsuit, Apple asserted that nearly all the iPhones, chargers and cables it...
A Chinese electronics component manufacturer says its products inadvertently played a role in a massive...
AT&T said it will acquire Time Warner for US$85.4 billion, reflecting a continuing trend for the...
Apple and IBM this week released their first iOS app for academia. IBM Watson Element for Educators is...