Filed under: ASAP Utilities on January 25th, 2012 by Bastien | No Comments »
Huge speed improvement in the "Select » Select cells based on content, formatting and more..." utility due to a new developed algorithm.
The utility now works much much faster with large data-sets too.
Now available for download
Filed under: ASAP Utilities on January 25th, 2012 by Bastien | No Comments »
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on January 13th, 2012 by Bastien | No Comments »
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 your sheets is much easier en furthermore a lot faster:
ASAP Utilities » Sheets » Protect multiple sheets at once...
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on January 13th, 2012 by Bastien | No Comments »
Filed under: ASAP Utilities on January 6th, 2012 by Bastien | No Comments »
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 do.
The pre-release of the new version of ASAP Utilities is now available.
Filed under: ASAP Utilities on January 6th, 2012 by Bastien | No Comments »
Filed under: General on December 23rd, 2011 by Bastien | No Comments »
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!
Filed under: General on December 23rd, 2011 by Bastien | No Comments »
Filed under: General, How to on November 21st, 2011 by Bastien | No Comments »
"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 in the 2010, and I have asked many “experts” and they are all saying that it’s not possible in the 2010.
Do you know a way to solve this or get my button back??"
Yes, don't worry, you can still do this in Excel 2010.
Microsoft hasn't removed it but just made it difficult to find (for no apparent reason)
Ron de Bruin, an expert on Excel, has written an excellent article on how to bring it back:
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm
In Excel 2002-2010 you have a option in the User Interface to mail a selection or worksheet in the body of the mail.
Excel 2002-2003 : You find this button next to the save icon in the Standard toolbar or use File>Send to>mail recipient.
Excel 2007-2010 : Microsoft hide it (It is not in the Office button>Send menu or in BackStage View)
But you can add this option to the QAT (Quick Access Toolbar)
Filed under: General, How to on November 21st, 2011 by Bastien | No Comments »
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on November 18th, 2011 by Bastien | 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 can select those cells with the following tool, and then just hit the DEL key:
Select » Select cells based on content, formatting and more...
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on November 18th, 2011 by Bastien | No Comments »
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities on November 16th, 2011 by Bastien | 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 -fantastic!
Here's my problem:
In sheet one, I'd like to enter a formula in A2 and be able to copy it to A2 in the other 99 sheets. Can ASAP help me with this?
I'd also like to be able to do this with a value in A3.
Well, this can already be done with just Excel.
If you want to enter the same formula on all 100 sheets, just select all the sheets and then enter the formula in A2... However, instead of pressing Enter at the end, press Control+Enter at the end. That way the formula will be entered in all selected cells, also the same cell-address on the other selected sheets.
You can also use this Ctrl+Enter to enter the same value in all selected cells on the same sheet.
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities on November 16th, 2011 by Bastien | No Comments »
Filed under: ASAP Utilities, how to with ASAP Utilities on November 3rd, 2011 by Bastien | 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 do this easily the past 8 years (already since version 3.0.6 from September 2003)
You can easily change the shortcut to whatever you like via:
ASAP Utilities » Favorites & Shortcuts » Organize your favorite tools...
By using and customizing the Favorites menu and assigning your own shortcuts you can quickly access the tools you use the most frequently. And in Excel 2000, 2002 and 2003, you can also create a toolbar with your favorites tools.
Filed under: ASAP Utilities, how to with ASAP Utilities on November 3rd, 2011 by Bastien | No Comments »
Filed under: ASAP Utilities on October 26th, 2011 by Bastien | No Comments »
We're proud to officially announce the new version of ASAP Utilities!
New exiting tools have been added and several improvements have been made.
... the new version that will do all this and more.
Many thanks to everyone who has contributed their feedback and tested the pre-release!
[ PS. 
Do you use Facebook and do you like ASAP Utilities? ]
Filed under: ASAP Utilities on October 26th, 2011 by Bastien | No Comments »
Filed under: How to on October 21st, 2011 by Bastien | Comments Off
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:
Filed under: How to on October 21st, 2011 by Bastien | Comments Off
Bad Behavior has blocked 135 access attempts in the last 7 days.
