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

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

Save 5 minutes a day by using ASAP Utilities to automatically fit the row height on merged cells too. Make the AutoFit Row Height work on merged cells Strangely, when using the AutoFit feature in Excel it completely ignores merged cells. In standard Excel, you cannot use the AutoFit feature on a row that contains a cell merged ...

Save 5 minutes a day by using ASAP Utilities to quickly strip the leading zeros from your numbers. Quickly remove the leading zeros from numbers Some programs export numbers with leading zeros. You quickly fix these numbers with: ASAP Utilities » Numbers & Dates » Change not recognized numbers (text?) to numbers Do you recognize any of these situations? I have ...

Save 5 minutes a day by using ASAP Utilities to quickly remove all the empty rows in your dataset. "Easily delete all empty rows that are in between" One of the most common tasks in Excel is deleting blank rows. Whatever type of data you may have in Excel, there are many occasions where you will also ...

Save 5 minutes a day by using ASAP Utilities quickly switch to full screen and back. "Easily switch between Full Screen and Normal View in Excel" When working in Excel often you want to see as much of your data/model as possible and the Full Screen mode can help you with that. However, Excel doesn't have a ...

Save 5 minutes a day by using ASAP Utilities to quickly extend your selection all the way down to the end of your data. "Easily select all the way down without the mouse/scrolling" The downside of Excel's shortcut Control+Shift+Down Arrow, is that it extends your selection down till the first empty cell that is found. However, an ...

Save 5 minutes a day by using ASAP Utilities to quickly change the sign of numbers for you. "Easily change the sign of numbers" Sometimes when you're working with amounts or if you have copied data from several sources, you need to change the negative numbers to positive or the other way around. Instead of using helper ...

Save 5 minutes a day by using ASAP Utilities to export or edit your cell comments. "Easily export or edit cell comments" Ever needed to quickly see/extract the value from cell comments? Did you ever had to resize/reposition all comments by hand? Ever got frustrated because Excel's find and replace doesn't work in comments? You can quickly do all this ...