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 new pre-release of ASAP Utilities is now available: Pre-release version 4.8.1, April 2012 Oh, and we looooove Twitter and especially that people share their enthusiasm! Thank you!  

Unlike Word, Excel doesn't have a similar option to insert a bulleted list. However, you can easily create a similar list in Excel by using a so called "custom number format". That might sound a bit difficult but it really isn't. Just select the list and right-click on any cell in your selection: Then choose "Format Cells..." Now choose "Custom" ...

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

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

We're proud to mention that the free ASAP Utilities Home&Student edition was featured in the January 2011 edition of the German PC Welt in an article about apps (addins) for Microsoft Office. English Translation: "Useful extensions for Microsoft Excel....ASAP Utilities is a collection of Excel macros with several hundred commands for formatting worksheets and highlight records ...

We're proud to mention that the free ASAP Utilities Home&Student edition is featured in the October 2011 edition of the Dutch PC Magazine in an article about apps (addins) for Microsoft Office. English Translation: "Firefox and Crome are well known for it, but Microsoft Office can also be improved with the use of extensions or "add-ins" ...

Quite frequently people ask us how to remove all content before or after a certain character. This is easy to do this with Excel's built-in Find and Replace. In this article I'll show you how. Hi! Does your software have a functionality to remove all content BEFORE a symbol in a column? For example: This: Home + Office > ...

Hello everybody, The pre-release of the new version of ASAP Utilities now available. New exiting tools have been added and several improvements have been made. Do you often work with Excel's Filters or AutoFilters? Did you ever wanted to change your conditional formatting to static formatting (like "copy > paste values" for formulas)? Would you like a way to automatically ...

The new version of ASAP Utilities, 4.7.2 has just been released! We've made several (speed) improvements and included a few new tools. Download ASAP Utilities 4.7.2 View the changes. Many thanks to everyone who has contributed their feedback and tested the pre-release!

I'm proud to mention that the pre-release of the new version of ASAP Utilities is now available. You can download it from here. We've made several (speed) improvements and included a few new tools that are available via ASAP Utilities Options » New tools in development (English only). One of this new tools can be a huge time ...

I wish you all a wonderful new year with lots of health, happiness and prosperity! May the New Year be a good year to you and yours. And we'd like to thank you for your suggestions, enthusiasm and encouragement throughout the past 12 years. We've planned several new exiting and improved tools for ASAP Utilities in 2011. The ...

We're proud to mention that ASAP Utilities is among today's picks in the PC World daily downloads newsletter. This way much more people get to know about our the benefits of ASAP Utilities. Work will be finished much quicker, no more overtime and everybody will be home in time to celebrate the holidays with family and ...

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

We're proud to tell you that the new version of ASAP Utilities is now available. We have made several improvements and added a few new tools that we believe are quaranteed time-savers. See what's new in version 4.6.4 For your information, we have recently joined Twitter too. Our address is http://twitter.com/#!/ASAPUtilities More to come ASAP Utilities will make your work ...