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

First of all: Happy new year! I wish you all the best, and less time in Excel and more time doing fun stuff like spending time with friends and family, taking long walks on the beach, swimming with your kids, riding your mountainbike, taking photographs, go geocaching, travel or whatever it is you 'd like to ...

Happy Holidays and Merry Christmas! Lots of love and happiness for you, your co-workers, family and friends. And if you don't celebrate Christmas, have a great weekend!

"Hi Bastien, I am a great admirer of you ASAP-utilities. Great work. I have a little problem with Excel 2010, that I am hoping that you might have a solution to. We have just switched over to the excel-2010 from excel-2003. In the 2003 there was a button to send this sheet to an e-mail. I can’t do that ...

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

We're proud to officially announce the new version of ASAP Utilities! New exiting tools have been added and several improvements have been made. Do you often work with Excel's Filters or AutoFilters? Do you need to export your worksheets as separate workbooks? Did you ever wanted to change your conditional formatting to static formatting (like "copy ...

In addition to my post for yesterday that demonstrated how to save worksheets as separate workbooks, this article will show how how to save several worksheets together in a single new workbook. To save several sheets from your workbook together in a new file, you can do the following in Excel: First select the sheets (you can ...

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