Tip: Quickly save just your selection or sheet as a new file

Export selection or active sheet as new file...

Save 5 minutes a day by using ASAP Utilities to quickly export your data in a specific file-format. "Easily export your selected cells in a proper file format" Have you ever wondered why Excel cannot just export just your selected cells to a new file? Or why European users cannot simply create proper CSV files […]

Tip: Quickly clean up your data in Excel

Quickly Clean Up Data and Formatting in Excel

Save 5 minutes a day by using ASAP Utilities to quickly clean up your data in Excel. "Easily optimize and clean your dataset" One of the first things you often need to do, when you import a file or copy information, is clean it up before you can analyse the data. There are many things […]

Tip: An easier way to fix the numbers that Excel doesn't recognize

ASAP Utilities » Numbers & Dates » Convert unrecognized numbers (text?) to numbers

Save 5 minutes a day by using ASAP Utilities to quickly fix the numbers that Excel may not recognize. "Easily make Excel recognize the numbers in your selection" Sometimes Excel fails to recognize numbers properly, which causes unexpected results when you sort, filter, or use formulas. For example, when you import a file that was […]

Tip: Quickly remove spaces from the beginning and end of your data

Delete leading and trailing spaces

Save 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or […]

Tip: Easily COUNT or SUM cells based on their Color

COUNT or SUM cells with a certain color

Save 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. "Did you ever have to SUM by Color or Count by cell Color?" I have a column that needs summed, but only the cells that are green... Working with cell colors can help to make […]

Tip: Quickly round the numbers in selected cells

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 […]

Tip: Quickly reset the last cell and minimize the used range

Quickly reset the last cell on your sheet and minimize the used range

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 […]

Tip: Auto numbering on steroids

Quick numbering on filtered data too

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 […]

Tip: Easy ways to combine the contents of multiple cells

Merge column data (join cells)

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 […]

Tip: Quickly fix the trailing minus sign for negative numbers

Fix trailing minus sign for negative numbers

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 […]