Save 5 minutes a day by having ASAP Utilities quickly round the numbers for you. "Easily apply rounding to all numbers in your selection" It is a common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with this approach is that it can display totals that don't appear ...

Save 5 minutes a day by using ASAP Utilities to quickly reset the used range on your worksheet. "Easily reset the last cell on your sheet" Have you ever been frustrated when Excel acts as if the active area of your worksheet is significantly larger than the actual area where you have data? Sometimes the last cell of ...

The new and improved version of ASAP Utilities has just been released! Based on the feedback we received, we've added many improvements to make your work in Excel easier, faster and more fun. Newsletter, see what's new http://www.asap-utilities.com/newsletter-2014-01.php Download the new version 5.1 You can download this new version from: http://www.asap-utilities.com/download.php If you have a license then you can download this new ...

We're happy to announce that the latest pre-release of the new version 5.1 of ASAP Utilities is now available. Many improvements have been made. If you use Excel 2013 or 2010 you will also see speed improvements when editing data formatted as Tables. We tested this pre-release thoroughly and have now made it available to you to help ...

Save 5 minutes a day by using ASAP Utilities to quickly insert a series of values into your cells. "Easily insert a series of values" Sometimes you need a bit more flexibility than Excel offers with its built-in Fill tool. For example to restart the count when a certain value is reached, add a pre-fix or suffix, auto ...

Save 5 minutes a day by using ASAP Utilities to quickly combine the contents of multiple cells into once cell. "Is there a quick way to merge the contents of multiple cells?" We were recently asked: "Does ASAP have a quick alternative for merging the contents of many cells into a single one? Using ampersands or Excel's ...

Save 5 minutes a day by using ASAP Utilities to quickly fix numbers with a trailing minus sign. "How can I flip the minus sign and make it a real negative number?" We were recently asked: "I have downloaded a report that shows negative numbers as follows: 123.25- How can I make the negative symbol appear on the left?" Just ...

Save 5 minutes a day by using ASAP Utilities to quickly remove all hidden rows and/or columns. "How can I quickly remove all hidden rows?" We were recently asked: "Does ASAP have a feature to convert filtered results 'in place' to convert a spreadsheet into just the filtered results? I know I can do it manually by ...

Save 5 minutes a day by using ASAP Utilities to quickly select or filter by strikethrough formatted cells. "How can I filter for items that have a 'Strikethrough'?" Strikethrough formatting (my struck through text) is often used to mark tasks as being completed or items to be ready for removal. The quickest way to apply this type ...

Save 5 minutes a day by using ASAP Utilities to quickly transpose your single column into a table. "How to quickly change a long list to a table?" Have you ever had data in a single column that you manually needed to "Copy > Paste Special > Transpose" over and over again to get it into a ...

Save 5 minutes a day by using ASAP Utilities to insert English formulas you found as examples. "How to use English formula examples in your local Excel version?" On the Internet you can find an enormous amount of useful formulas for Excel. Most of these examples use the "international" formula notation. They use English function names, a comma ...

Save 5 minutes a day by using ASAP Utilities to quickly change your text to uppercase. "How to quickly capitalize all text" Have you ever had data in a worksheet where all the text was all lowercase? Then you had to retype it all to get it into uppercase? No more! Just select the cells and then start: ASAP ...

Save 5 minutes a day by using the built in Search-tool to quickly find the tool from ASAP Utilities that helps you. "Easily find the tool that can help you" You can't find the tool that you used previously? Or you don't know if a specific tool exists in ASAP Utilities? Don't worry, our built-in search-tool will help ...

Save 5 minutes a day by using ASAP Utilities to easily test how your workbook looks with other display settings. "Easily see how your template/model looks to other users" When you develop a template, you'll have to keep in mind that the information that you can see on screen, isn't always what other users see. Some information ...

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

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

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

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

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

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

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

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

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

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

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