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

Excel is used by many people in the business of internet marketing (such as search engine marketing (SEM, SEO) or advertising campaigns (PPC)). They use Excel as an analysis and data-preparation tool to handle their keywords, descriptions, target urls, bids, results, etc.. And although Excel can already to a lot, there are many things that can ...

When you work with a workbook that includes many sheets, you probably want to see as many of them as possible. One way to do this,  is by dragging the 'slider' from the horizontal scroll-bar to the right. That will decrease the size of the horizontal scroll-bar and give more space to show the sheet-tabs: Other tips to ...

The built in method of Excel allows you to only protect one sheet at a time. If you want to protect multiple sheets in Excel you have to protect them one by one. This can take a long time if you have many sheets and even might result in accidentally forgetting one. With this tool protecting ...

"Hi! I couldn't find the following function in ASAP Utilities: Delete cells based on content. Ex.: I would like to delete all cells (content) which is less than 3, greater than 100…. Would be nice when working with statistics." Well, you can already do this in ASAP Utilities, but with an additional step. First you can select those cells ...

Today we received the following email: Let me start by saying how wonderful I think your program is. It saves me a lot of time. I just created 100 sheets and named them from a list using ASAP -great! I then inserted the name of each sheet into a cell within the sheet using ASAP -fantastic! Here's my problem: ...

Every now and then people ask us if it is possible to change the shortcuts that are used by ASAP Utilities. For example: "Hello, is it possible to change the Ctrl + Alt + J shortcut to something else?" Often because people already use the same shortcut for their own macro. Well, you can already ...

I just received the following question from Azad from Australia: Hi, Is it possible to select a number of worksheets and export as a single workbook? As you probably already know, Excel itself doesn't have a option for this. It can be a time consuming job to save each worksheet as a separate workbook. Fortunately it is very ...

We have created a example workbook that shows how to get things done - that are normally not possible at all or difficult in Excel - by using the functions that ASAP Utilities adds. Especially the function to calculate the SUM of cells with a certain color is a popular request and still can't be done ...

In the new version of ASAP Utilities (4.6.4), which is available as a pre-release, we have included a tool to easily splits your data into separate sheets. Sheets » Split the selected range into multiple worksheets... With this tool you can quickly split your data into multiple sheets. You can do this either by value, for example ...

In standard Excel you can not set the height or with of cells in centimeters or inches. Creating square cells is also difficult because Excel uses different units for the width and height of cells. Setting the width and height in centimeters or inches can be helpful if you use the Excel for drawing purposes, such ...

At this moment ASAP Utilities already contains several tools to manage duplicates. However a special tool for duplicate records was still missing... until now! You could already identify or remove duplicated records with a workaround by merging the cell contents into a temporary added column and then use ASAP Utilities' "Conditional row and column select, hide or ...