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

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:

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

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

New version released: ASAP Utilities 4.2

New version released: ASAP Utilities 4.1.2

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

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

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

Pre-release ASAP Utilities version 4.1.3 RC4

Freeze panes on multiple sheets at once

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

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

Excel 2007 with ASAP Utilities in the ribbon

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

Preview ASAP Utilities ribbon for Excel 2007

Preview ASAP Utilities ribbon for Excel 2007

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

Pre-release ASAP Utilities version 4.1.3 RC2

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

Pre-release ASAP Utilities version 4.1.3 RC1

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

New version released: ASAP Utilities 4.1.2

New version released: ASAP Utilities 4.1.2

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