Quickly reset the last cell and minimize the used range

April 13, 2017 0

Quickly reset the last cell on your sheet and minimize the used rangeSave 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 […] Read More

Auto numbering on steroids

April 12, 2017 0

Quick numbering on filtered data tooSave 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 […] Read More

Easy ways to combine the contents of multiple cells

April 11, 2017 0

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

Quickly fix the trailing minus sign for negative numbers

April 10, 2017 2

Fix trailing minus sign for negative numbersSave 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 […] Read More

Easily insert an English formula in your non-English Excel version

April 3, 2017 0

Easily paste English formulas into your local Excel version, such as for example a Dutch Excel versionSave 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 […] Read More

Easily change the text in selected cells to UPPERCASE

March 30, 2017 0

Easily make text uppercaseSave 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 […] Read More

Tip: Quickly find the tool you need

March 24, 2017 0

Easily search, find and run the tools from ASAP UtilitiesSave 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 […] Read More

Tip: Test your model/template in different screen resolutions

March 21, 2017 0

Quickly test how your model or template will look on computers with different screen resolutionsSave 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. […] Read More

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

August 25, 2015 0

ASAP Utilities » Numbers & Dates » Convert unrecognized numbers (text?) to numbersSave 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 […] Read More

1 2
Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips