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 ...

Tip: Quickly fill blank cells with value above in Excel

Copy values to empty cells below filled cells in selection

Save 5 minutes a day by using ASAP Utilities to quickly fill blank cells using the data in the cells above. Auto fill empty cells using the data from the cell above When setting up data in Excel it is good practice to ensure that all cells with labels are filled. Empty cells can lead to trouble when ...