Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on September 12th, 2013 by Bastien | Comments Off on Tip: Easily keep only the filtered results

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on September 12th, 2013 by Bastien | Comments Off on Tip: Easily keep only the filtered results
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on August 12th, 2013 by Bastien | 2 Comments »

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on August 12th, 2013 by Bastien | 2 Comments »
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on August 5th, 2013 by Bastien | Comments Off on Tip: Easily transpose 1 column into multiple rows, creating a table

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on August 5th, 2013 by Bastien | Comments Off on Tip: Easily transpose 1 column into multiple rows, creating a table
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 28th, 2013 by Bastien | Comments Off on Tip: Easily insert an English formula in your non-English Excel version

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 28th, 2013 by Bastien | Comments Off on Tip: Easily insert an English formula in your non-English Excel version
Filed under: General on June 28th, 2013 by Bastien | Comments Off on Insert random dates and times in Excel

We just received the following question:
"Would it be possible to add random date and times?"
Yes, this can (already) be done with just Excel.
We might add a tool for it in ASAP Utilities that will ask you for the input in the future, but it isn't hard to do yourself with the combination of a few ...
Filed under: General on June 28th, 2013 by Bastien | Comments Off on Insert random dates and times in Excel
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 17th, 2013 by Bastien | Comments Off on Tip: Easily change the text in selected cells to UPPERCASE

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 17th, 2013 by Bastien | Comments Off on Tip: Easily change the text in selected cells to UPPERCASE
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 7th, 2013 by Bastien | Comments Off on Tip: Quickly find the tool you need

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on June 7th, 2013 by Bastien | Comments Off on Tip: Quickly find the tool you need
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 31st, 2013 by Bastien | Comments Off on Tip: Test your model/template in different screen resolutions

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 31st, 2013 by Bastien | Comments Off on Tip: Test your model/template in different screen resolutions
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 17th, 2013 by Bastien | 1 Comment »

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 17th, 2013 by Bastien | 1 Comment »
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 10th, 2013 by Bastien | Comments Off on Tip: Quickly copy page layout settings from one sheet to other sheets

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 ...
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day on May 10th, 2013 by Bastien | Comments Off on Tip: Quickly copy page layout settings from one sheet to other sheets