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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
"Work 10 times faster" We are huge fans of keyboard shortcuts. It allows us to do our work more efficiently. Studies calculate that using keyboard shortcuts allows to work 10 times faster than working with the mouse. The time you spend looking for the mouse and then getting the cursor to the position you need is lost time! ...
Save 5 minutes a day by using ASAP Utilities to quickly save your chart or range as a picture file. "Easily save your chart or range as a picture file" Excel itself has no built-in option to save a chart as a picture (unlike Word, that does have it) But fortunately there are add-ins such as ASAP Utilities ...
Save 5 minutes a day by using ASAP Utilities to quickly insert borders or empty rows between repeated values. "Quickly recognize groups of data" Groups of repeated values are easier recognizable if they are separated by an empty row, border line or color. You can quickly do that with the following tool: ASAP Utilities » Columns & Rows » Detect ...
Save 5 minutes a day by using ASAP Utilities to create multiple backup-versions of your file. "You can never have too many backups" If you often work with large spreadsheets then you know how frustrating it can be to lose data because of a stupid mistake. I like to have different versions of a file, so that I ...
Save 5 minutes a day by using ASAP Utilities to quickly protect or unprotect multiple sheets in a single step. "Have all your worksheets (un)protected in one go" In Excel, individual worksheets can only be protected one sheet at a time. It is not possible to protect multiple worksheets in a single step. The same limit applies ...
If you type a portion of your data in the wrong case, then you won't have to retype it. If you received a workbook from others that is in the wrong case, then please remember that there is a quick way to correct this. Save 5 minutes a day by using ASAP Utilities to quickly change the ...
Save 5 minutes a day by using the "Select » Select cells based on content, formatting and more..." tool: Quickly select certain cells automatically? You can have cells selected automatically for you, with the following tool: ASAP Utilities » Select » Select cells based on content, formatting and more... Especially when you need to select more than a dozen ...
Save 5 minutes a day by using the "Fill » Insert before and/or after each cell in your selection..." tool: Quickly add a prefix or suffix to all selected cells at once You can quickly insert any value in front or after every cell in your selection, with: ASAP Utilities » Fill » Insert before and/or after each ...
Save 5 minutes a day by using the "Text » Delete leading, trailing and excessive spaces" data cleanup tool: Quickly remove all unnecessary spaces With: ASAP Utilities » Text » Delete leading, trailing and excessive spaces Remove all spaces from the beginning and end of your data and replace duplicated spaces between words with a single space. Do you ...
Save 5 minutes a day by using the "Select » Deselect cells..." tool: Quickly deselect cells from a selected range With: ASAP Utilities » Select » Deselect cells... You can quickly deselect cells from a selected range, something that is normally not possible in Excel. Do you recognize this? "If I select rows 1, 2, 6, 10 and 18 then ...
Save 5 minutes a day by using the "Apply formula/calculation to selected cells..." tool: Quickly apply a calculation to all selected cells at once With: ASAP Utilities » Formulas » Apply formula/calculation to selected cells... With this utility you can quickly perform a calculation on all selected cells at once. There are many situation in which we think this ...
Hello everybody, We've scheduled a new series of posts/tutorials.
Every week, on Tuesday, we'll give you a "tip of the week" to show you how to benefit from one of the tools in ASAP Utilities.
By spending a minute a week to read it, we'll help you to save many hours of work.
Since most people like to get ...
We're proud to officially announce the new version of ASAP Utilities!
New time-saving tools have been added and several improvements have been made. Download | See what's new Many thanks to everyone who has contributed their feedback and tested the pre-release!