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...
Android is better than ever, but it's still not perfect. These are the things we wish were included in...
MIT researchers have found a way to transfer wireless data using a smartphone at a speed about three...
Going back to school? Here are some of the best laptop backpacks for every situation, whether you're...
Aug. 25 marks the 25th anniversary of Linux, the free and open source operating system that's used...
Legacy ciphers such as triple-DES and Blowfish are vulnerable to Sweet32 attacks, which let attackers...
As big data initiatives gain steam at organizations, many companies are creating “data lakes” to...