Tip: Quickly re-start the last used tool

Start the last used utility again

Save 5 minutes a day by quickly starting the last tool again that you used from ASAP Utilities. "Easily start again the tool you just used" Sometimes you need to use a tool several times in sequence. Instead of having to go through the (sub)menus to find and start the tool again, we've created a shortcut for ...

Tip: Quickly copy page layout settings from one sheet to other sheets

Easily copy a sheet's page and print settings

Save 5 minutes a day by using ASAP Utilities to easily copy your worksheet's page setup settings to your other worksheets. "Easily copy a sheet's page settings to your other worksheets" When you add a new sheet to your workbook then Excel assigns the default page setup settings. In Excel there is no button to quickly copy ...

Tip: Quickly close multiple workbooks at once

Easily close multiple files at once

Save 5 minutes a day by using ASAP Utilities to easily close multiple workbooks at once. "Close multiple or all files at once instead of just one at a time" I often have multiple files open in Excel. I hate having to close each file separately. Is there an easier way? Yes there is, just use: ASAP Utilities » ...

Tip: Sort your data on anything that you can think of

Sort your data basically on anything you can think of

Save 5 minutes a day by using ASAP Utilities to sort your cells on bold, italic, color, font, etc., etc.. "Sort by bold, italic, color, font, month, etc., etc." You can easily sort your data on all kinds of characteristics with: ASAP Utilities » Range » Advanced sorting... With this utility you can sort by: Value Number format Cell Color Cell Color Indexnumber Font ...

Tip: Easily count and/or color duplicate values

Count and optionally color duplicated values

Save 5 minutes a day by using ASAP Utilities to quickly identify the duplicated/repeated values. "How can I see which are the duplicate values?" Just select the cells and then start: ASAP Utilities » Information » Count and/or color duplicates in selection... Do you recognize any of these situations? How can I highlight duplicates in Excel? I need to quickly verify ...

Tip: Quickly save worksheets as separate files

Save worksheets as individual files

Save 5 minutes a day by using ASAP Utilities to quickly save the worksheets in your workbook as separate files. "How can I save my sheets as separate files?" "I have an Excel file with many worksheets. We need to export each worksheet to a separate file. Ideally the file name would be the worksheet's name. Is ...

Just released: ASAP Utilities 5

because it makes YOU rock in Excel!

We're proud to officially announce the new version 5 of ASAP Utilities! Many improvements have been made and Excel 2013 (32-bit) is now officially supported too. Download | See what's new Many thanks to everyone who has contributed their feedback and tested the pre-release! Free upgrade All existing customers get version 5 free of charge! Your existing license will also work ...

Tip: Easily remove leading characters

Save 5 minutes a day by using ASAP Utilities to quickly remove a given number of leading characters from your cells. "How to quickly remove a specified number of leading characters..." Just select the cells and then start: ASAP Utilities » Text » Delete number of leading characters... Do you recognize any of these situations? How can I strip off ...

Tip: Fast calculation on selected cells

Fast calculation on selected cells

Save 5 minutes a day by using ASAP Utilities to quickly get basic info and calculation results on your selection. "How can I get a quick sum, avg, min, max, no of duplicates etc.?" This utility provides info and performs a fast calculation on the selected cells. Just select the cells and then start: ASAP Utilities » Information » ...

Tip: Easily remove certain or several characters at once

Advanced character remove or replace

Save 5 minutes a day by using ASAP Utilities to quickly remove or replace characters in your selection. "How to quickly get rid of multiple characters at once..." With this utility you can remove or replace certain characters in your worksheet or selected cells. You can pick one or more characters from a list, including numbers, letters, special ...