Tip: Save time with keyboard shortcuts

Add your favorite tools and assign your own shortcuts

"Work 10 times faster" I'm a huge fan of keyboard shortcuts. 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! Reducing the working time by 10 brings you ...

Tip: Save Chart or Range as picture (JPG, PNG, vector etc.)

Turn Excel Data and Charts into JPG PNG GIF EMF

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

Tip: Insert a border or blank row after repeating cell values in a column

Insert a blank row at every change in value in a given column

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

Tip: Save and create a timestamped backup

Save your file and automatically creates a backup copy with time-stamp

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

Tip: Quickly (un)protect all sheets at once

Protect multiple sheets at once...

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

Tip: Quickly change the text-case in all selected cells at once

Change all text to UPPERCASE

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

Tip: Select cells automatically based on their contents, formatting, etc.

Select cells based on their value, lenght, etc.

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

Tip: Quickly add a prefix or suffix to your data

Insert before and/or after each cell in your selection...

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

Tip: Get rid of unwanted spaces in your data

Delete leading, trailing and excessive spaces

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

Tip: Quickly deselect cells from a selected range

Quickly deselect cells from a selected range

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