Tip: Easily strip leading zeros from your numbers

Strip leading zeros

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

Tip: Quickly remove blank rows from a long list

A quick way to delete blank rows in Excel

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

Tip: Quickly toggle Full Screen with the F11 key

Use the F11 key to switch between full screen and normal view

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

Tip: Quickly extend your selection down to the end without scrolling

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