logo ASAP Utilities

Sit down and relax while ASAP Utilities does the rest!

Sit down and relax, while ASAP Utilities does the rest!

Supported Excel versions

ASAP Utilities 7 works with the Windows editions of:
  • Excel 2000
  • Excel 2002/XP
  • Excel 2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016
  • Excel 2019
  • Excel 2021
  • Excel 365 Desktop

How it helps you

Examples of how ASAP Utilities saves you time in Excel

Who are our clients?

Our list of clients exceeds 23,500 organizations in more than 140 countries.

Press

Read the awards & reviews from magazines, newsletters and radio shows.

RSS Feed

These news items are also available as an RSS feed

Receive our newsletter

Receive an email as soon as a new version of ASAP Utilities is released

ASAP Utilities new version 3.09 released

Date: April 21, 2005

News from the Netherlands!

It is our pleasure to introduce to you the new ASAP Utilities.
Again, several magazines, newsletters and a book have written very positive about our time-saver utility for Excel.

My thanks goes out to each and every one of you for your support, help and tips. Unfortunately we're not able to reply to all the emails we receive, but we read them all.

Click here to go to the download page.

ASAP Utilities is (as always) free and contains no spyware !
We make you the company's excel guru!


What's new in 3.09:

  • Menu
    A few specific ASAP Utilities functions have been placed in the submenu ASAP.
  • ASAP :: Find you utility (search help)
    Search through the entire menu and descriptions of all ASAP Utilities. If you don't enter a search phrase it will list all tools.
  • Select :: Conditional select cells
    - select odd rows
    - select even rows
    - select visible cells
    - select where font is strikethrough


  • Select :: Conditional row and column select, hide or delete
    - select odd rows
    - select even rows
  • Range :: Find / Replace in all sheets
    Besides the normal text you can now also search and replace a few special characters:
    - line feed (alt+enter, chr(10)) ? use {lf}
    - carriage return, chr(13) ? use {cr}
    - horizontal tab, chr(9) ? use {t}
  • Columns/rows :: Delete all hidden rows and columns
    Removes all hidden rows and columns on the active sheet. Useful when you want to pass to clean up the file before distributing and delete all unnecessary information. Be careful when you have formula's with references to data in the hidden cells.
  • Export :: Export selection or activesheet as new file
    Added the option to directly export to clipboard in space-delimited format.
  • Information :: File and selection info.
    Returned the information in A1-reference style. New is that it now looks at your settings. If you use the R1C1 reference style it will show it in that format.
  • System :: Find and remove external links
    Search is now also performed in all rangenames. If you delete a range-name with an external reference and have used it on you sheet, the error value '#NAME' is displayed in the cell or cells that use the defined name.
  • Web :: Optimize web import
    Has been renamed to Clean web import
Bug fixes:
  • Spell check on the menu and tools description
    Some annoying spell-errors were corrected. It will most likely still have errors but forgive us, we're Dutch, English is not our native language.
  • Numbers :: Convert formulas to their values
    Took a very very long lime when you selected then entire worksheet (A1:IV65536).
  • System :: Find and remove external links
    Returned an error when you selection on a worksheet was not a range but e.g. a chart.
  • Sheets :: Protect all sheets
    Returned an error when your workbook contained other sheets than just worksheets. Now you can also protect other sheet-types (like charts) Returned an error when you had a group of sheets selected.
  • Range :: Find / Replace in all sheets
    Returned an error on hidden sheets. These sheets are now excluded from you search. A label shows you if there are hidden sheets.
  • Fill :: Quick numbering of cells
    If your selection started on row nr 1 and you choose "restart numbering if the value in the column changes" the follwing error ocurred: "Application-defined or object-defined error.


« back


Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
© 1999-2021 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook