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

Posted on January 13th, 2012 by Bastien
Filed under: ASAP Utilities, How to, how to with ASAP Utilities | No Comments »

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

Posted on November 18th, 2011 by Bastien
Filed under: ASAP Utilities, How to, how to with ASAP Utilities | No Comments »

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

Posted on November 16th, 2011 by Bastien
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities | No Comments »

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

Posted on November 3rd, 2011 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | No Comments »

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

Posted on October 20th, 2011 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 3 Comments »

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

Posted on December 1st, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | Comments Off

In addition to my previous post, a short video that shows a demonstration of the new "Split the selected range into multiple worksheets..." utility. The video is in HD quality and for best quality I recommend to watch it on full screen: The above video is without sound. For me this is also a test [...]

Posted on October 25th, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 9 Comments »

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

Posted on October 25th, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 2 Comments »

In standard Excel you can't 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 [...]

Posted on February 23rd, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 1 Comment »

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

Posted on February 18th, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 1 Comment »