How to: Protect multiple sheets at once

Protect multiple sheets at once

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

Pre-release new version & Happy new year!

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

Merry Christmas!

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!

User question: How to send this sheet to an e-mail in Excel 2010?

Sent this Sheet

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

User question: How to delete cells based on content

Select cells based on content, formatting and more...

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

User question: How to enter the same value on multiple sheets (or in multiple cells at once)

Press control+enter to enter the same value in all selected 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: ...

How to: Change the shortcuts used by ASAP Utilities

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

ASAP Utilities released its new version (4.8.0) today!

Facebook

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

How to: Save several worksheets together in a single new workbook

Select the sheets and right-click on one of them

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

How to: Select a number of worksheets and export each as a single workbook

Save worksheets as separate workbooks

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