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.
PayPal has fixed a serious vulnerability in its back-end management system that could have allowed...
Rep. Darrell Issa has rolled out a bipartisan bill that would make two key changes to the 1998 H-1B...
Suffering from a marked downtick in demand and oversupply, the prices of photovoltaic modules are...
Amazon is promoting a few minor tech deals today, but the big sales are still a few days away.
While it may seem like half the world is chasing Pokemon right now, a majority of the world’s...
Microsoft said that consumer subscriptions to Office 365 topped 23 million, signaling that the...
AMD is rebooting its server business around chips with the Zen CPU, which will also be used in PCs. AMD...