Tip: Quickly fill blank cells with value above in Excel

Copy values to empty cells below filled cells in selection

Save 5 minutes a day by using ASAP Utilities to quickly fill blank cells using the data in the cells above. Auto fill empty cells using the data from the cell above When setting up data in Excel it is good practice to ensure that all cells with labels are filled. Empty cells can lead to trouble when ...

Tip: 'AutoFit Row Height' on merged cells too

Autofit rowheight also on merged cells

Save 5 minutes a day by using ASAP Utilities to automatically fit the row height on merged cells too. Make the AutoFit Row Height work on merged cells Strangely, when using the AutoFit feature in Excel it completely ignores merged cells. In standard Excel, you cannot use the AutoFit feature on a row that contains a cell merged ...

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 Do you recognize any of these situations? I have ...

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 will also ...

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 have a ...

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. However, an ...

Tip: Quickly make numbers positive or negative

Easily change the sign of numbers

Save 5 minutes a day by using ASAP Utilities to quickly change the sign of numbers for you. "Easily change the sign of numbers" Sometimes when you're working with amounts or if you have copied data from several sources, you need to change the negative numbers to positive or the other way around. Instead of using helper ...

Tip: Quickly edit or export cell comments

Easily extract or edit cell comments

Save 5 minutes a day by using ASAP Utilities to export or edit your cell comments. "Easily export or edit cell comments" Ever needed to quickly see/extract the value from cell comments? Did you ever had to resize/reposition all comments by hand? Ever got frustrated because Excel's find and replace doesn't work in comments? You can quickly do all this ...

Tip: Quickly insert multiple sheets at once

Insert multiple sheets (uses the cell values as sheet names)

Save 5 minutes a day by using ASAP Utilities to quickly create or copy worksheets. "Easily insert many worksheets or worksheet-copies" The standard method to create a series of worksheets with custom names is to add them and then rename them one by one. This can be a time-consuming task. If you already have a list of the ...

Tip: Quickly sort your sheets by their value or tab-color

Sort sheets by their value or color

Save 5 minutes a day by using ASAP Utilities to quickly sort your sheets. "Sort your sheet-tabs - the easy way" If you have a lot of worksheets in a workbook then it is sometimes easier to have them in alphabetical order. However, Excel itself has no built-in option to sort sheets - not even the new ...