Bastien - ASAP Utilities Blog

The following video will demonstrate you how to sort by color in Excel by using ASAP Utilities. It is not possible to sort by color in Excel. However we find that many people use colors to "tag" certain cells that need to be processed later. The example in the video show a list of keywords such as my ...

ASAP Utilities General

Macro: Export each column to a separate sheet

Oct 9, 2007 Bastien 0 Comment

Last week I got a question from Danielle: "I have a spreadsheet with 75 columns each containing between 48 to 50 rows. I would like to be able to export each column to either a separate sheet or a separate file. Sort of like the export worksheets as separate files function. Does this ...

ASAP Utilities how to with ASAP Utilities

Video: How to remove leading zeros in Excel with ASAP Utilities

Oct 8, 2007 Bastien 0 Comment

The following video will demonstrate you how to remove (or trim) leading zeros from numbers within a range in Excel by using ASAP Utilities. This utility also works for numbers that are not recognized by Excel or are proceeded with an apostrophe (such as '2). You can usually recognize these numbers because they are left-aligned: The following video ...

ASAP Utilities

Pre-release ASAP Utilities version 4.2.1 RC2

Oct 5, 2007 Bastien 4 Comment

(Re) build the ASAP Utilities favorites menu toolbar

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. I have also experienced some crazy things with customizing the ribbon (qat) and empty Excel dialogboxes due to dynamic labels (getLabel). I will write more about that in a separate post. New/improved Fill » Random numbering of ...

ASAP Utilities how to with ASAP Utilities

Video: How to select/find unique values in a selection in Excel with ASAP Utilities

Oct 3, 2007 Bastien 0 Comment

The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities. The video demonstrates how to select the color names that appear only once in the list: Note: This old video is no longer available and will in 2021 be replaced with a new version in a modern ...

ASAP Utilities how to with ASAP Utilities

Video: How to to list filenames in a folder in Excel with ASAP Utilities

Oct 2, 2007 Bastien 0 Comment

The following video will demonstrate you how to list filenames in a folder in Excel by using ASAP Utilities. It is a perfect tool for creating catalogs of the files of your CD's and DVD's. The video will demonstrate how to import the contents of a folder and shows you how you can easily select a certain folder ...

ASAP Utilities

New version released: ASAP Utilities 4.2

Sep 25, 2007 Bastien 0 Comment

Today I have released the new version of ASAP Utilities. This new version is improved in severals ways. I would like to thank everybody for their feedback the past months! » What's new » Versions History » Download I have changed the version number from 4.1 to 4.2 because the ASAP Utilities menu is now nicely integrated into the Excel ...

ASAP Utilities

Pre-release update: Default filename in 'Export selection or active sheet as new file…'

Sep 13, 2007 Bastien 0 Comment

Export selection or active sheet as new file: default filename

I have just put a new pre-release online which updates the utility Export » Export selection or active sheet as new file.... The default proposed filename now contains the name of your workbook and the selected sheet. If you have chosen to export a range of cells instead of the entire sheet, the proposed filename also ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC4

Sep 13, 2007 Bastien 0 Comment

Yesterday I have published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. Two new utilities Sheets » Freeze panes on multiple sheets at once Freeze panes on all or all selected sheets at once bases on your current selection. Normally in Excel you can only do this one one sheet ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC3 (Excel 2007 ribbon)

Aug 30, 2007 Bastien 2 Comment

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. The major change in this version is in combination with Excel 2007 where ASAP Utilities now has its own tab in the ribbon. Preview with the blue (Excel default) theme: Preview with the black theme: A screenshot of ...

ASAP Utilities

Preview ASAP Utilities ribbon for Excel 2007

Aug 28, 2007 Bastien 2 Comment

I am currently working on an Excel 2007 ribbon-menu for the new ASAP Utilities. Right now the ASAP Utilities menu is visible in the Add-ins tab but the new version will have its menu integrated in the ribbon. Preview of the new ASAP Utilities menu A preview of the new ASAP Utilities ribbon in Excel 2007: More information ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC2

Aug 10, 2007 Bastien 0 Comment

Screenshot - Insert current date and time with seconds

I have made a few improvements to ASAP Utilities based on the advice of several people. Added: Fill » Insert current date and time with seconds Insert the current date and time into the active cell. Unlike Excel's built in shortcut "Control+:" this utility also inserts the seconds. (timestamp) By default this utility can be started with the shortcut ...

ASAP Utilities

Pre-release ASAP Utilities version 4.1.3 RC1

Jul 19, 2007 Bastien 0 Comment

Added the options to select cells with a certain number format

Just when you think everything is right a new bug pops up... This afternoon I have released a pre-release of the new version that solves a bug in the Paper Saver utility. There was an error in the progress-display that caused an error when starting the utility and therefor made it impossible to use. This is ...

ASAP Utilities

New version released: ASAP Utilities 4.1.2

Jul 16, 2007 Bastien 0 Comment

Today I have released the new version of ASAP Utilities. This new version is improved in severals ways. I would like to thank everybody for their feedback the past months! » What's new » Versions History » Download Up next: A special ASAP Utilities menu in the Excel 2007 ribbon. (However, only a very small percentage of the Excel people ...

ASAP Utilities

New version in progress – pre-release 4

Jul 10, 2007 Bastien 2 Comment

I have been working on the new version of ASAP Utilities today and I've just released another preview version, ready for download and testing. New ASAP Utilities Options » Start the last used utility again... This will re-start the last run utility used in ASAP Utilities. For example if the last utility you used was 'Export selection as HTML ...

General

Excel file loads slowly the first time that it is opened in Excel

Jul 10, 2007 Bastien 0 Comment

General Excel question: Recently I have been getting this same question by several customers. If they open a file in Excel, the first time it takes a very long time. If they then save the file and open it again it loads much faster. This occurs when you open an Excel file that has been made in ...

ASAP Utilities General

Fix the slow startup of Excel 2007

Jul 9, 2007 Bastien 61 Comment

Recently I have been receiving a few emails about people telling me that their Excel 2007 would startup very slowly with ASAP Utilities installed. The delay also occurred without ASAP Utilities if they click on an Excel file from within the Explorer: If I click on an xls file Excel opens with a blank window which delays... If ...

ASAP Utilities

New version in progress – pre-release 3

Jul 9, 2007 Bastien 0 Comment

I have just released a third preview-version of the new version of ASAP Utilities. This version solves a few more bugs and expands the Text Convert dates... utility with the option to change the case of the new dates: This new version will probably officially be released as a new version at the beginning of July. More information ...… Read more...

ASAP Utilities

PCtipp: Obercooles Programm – Excel-ABC: 29 Tipps

Jul 4, 2007 Bastien 0 Comment

Last month the Swiss computer magazine PCtipp wrote an article with 29 useful tips for Excel. ASAP Utilities was one of their tips. They gave it a great title (which made me dance around in the office for a while!). The full article is available on their website: www.pctipp.ch www.pctipp.ch/archiv/archivj.asp?yy=2007&ii=06

ASAP Utilities

New version in progress – pre-release 2

Jul 4, 2007 Bastien 0 Comment

I have just released a second preview-version of the new version of ASAP Utilities. This version solves a few more bugs. Furthermore the User Guide is now included in the setup and accessible from within the ASAP Utilities menu. I hope this way more people will be aware of the User Guide and spend some time reading it to ...

ASAP Utilities

New version in progress – pre-release

Jun 27, 2007 Bastien 2 Comment

I have just released a preview-version of the new version of ASAP Utilities. This version solves nearly all the bugs that have been reported so far. Furthermore some utilities we added or improved. This new version will probably officially be released as a new version at the beginning of July. More information and download: //www.asap-utilities.com/faq-questions-answers-detail.php?m=149 At this moment the ...

General

Microsoft: Description of the undiscovered tips about Excel

Jun 21, 2007 Bastien 2 Comment

Microsoft has written an article on how some things in Excel can be done without the use of macro's. An interesting list. However I remember that back in 1999 when I use their approach to "Exclude duplicate items in a list" I found out that this was limited to approximately 1000 unique items. This article describes some ...

ASAP Utilities

"I use this tool all the time, how can I access it faster?"

May 28, 2007 Bastien 0 Comment

Last week I received the following question: "Is it possible to display a tool icon amongst the normal excel icons. I use the "Find and remove external links" all the time and would like to have it closer to hand and not first open ASAP Utilities/System/........... Thank you for this great Software" In stead of adding it to the ...

General

How to increase the number of undo levels in Excel

May 28, 2007 Bastien 0 Comment

By default, Excel keeps track (allocates RAM) of 16 "undo" levels. Undo levels provide an undo history for most actions that you perform in Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. If the undo history is set to zero, no memory is allocated for undoing ...

ASAP Utilities how to with ASAP Utilities

Video: Apply a formula to selected cells (*10) with ASAP Utilities

May 16, 2007 Bastien 1 Comment

The following video will demonstrate you how to apply a formula to your selected cells in Excel with ASAP Utilities. A quick alternative for creating extra columns or use the copy-pastespecial methods. In the example I show you how to quickly multiply all cells in your selection with 10. Note: This old video is no longer available and ...