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

Posted on February 27th, 2013 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day | Comments Off on Tip: Easily strip leading zeros from your numbers

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

Posted on February 20th, 2013 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day | Comments Off on Tip: Quickly remove blank rows from a long list

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

Posted on February 12th, 2013 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day | Comments Off on Tip: Quickly toggle Full Screen with the F11 key

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

Posted on February 6th, 2013 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, save 5 more minutes a day | Comments Off on Tip: Quickly extend your selection down to the end without scrolling