logo ASAP Utilities

Solves the most common annoyances in Excel

Excel with ASAP Utilities in it's menu

Version history

A history of the various updates and improvements throughout the years

Awards & Reviews

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

Reviews from users

See what our users are saying about ASAP Utilities

Receive our newsletter

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

Trusted daily by over 26,000 organizations

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

ASAP Utilities released its new version (4.1.1) today!

Date: May 7, 2007

We're proud to officially announce the new version of ASAP Utilities!
You can download 4.1.1, May 7, 2007.
Major reasons for this new version are several bugfixes and a few new and improved utilities.
I would like to thank everybody for their feedback!


Bug fixes:

  • Numbers » Round numbers (not formatting, but changing)...
    If you entered a zero the operation was incorrectly canceled.
    This is now fixed so you can round numbers to zero decimals again.
  • Columns / Rows » Put together rows or columns from several sheets...
    Didn't work and produced an error if one of the selected sheets was protected.
  • Import » Merge files together in a new file...
    Accidentally canceled the operation when you clicked on the 'Pick files and merge' button (After selecting the files you received the error "You cancelled the operation"). Furthermore the import didn't work as expected in Excel 2000. These two bugs were introduced in version 4.1.0 and are now fixed.
  • Select » Conditional select cells...
    Select all numbers between two values, for example all between 1 and 50, didn't work. This is now fixed.
    Select non-empty cells didn't select cells with formulas. This is now corrected
    Select cells with a certain font-size didn't work. This is now fixed.
  • Numbers » Use a significant number of decimals...
    Improved.
  • Range » Paste special with combinations
    Fixed a few bugs that were related to the arithmetic operations
  • Text » Convert dates...
    Better handling/support of dates with month names (mmm and mmmm)
  • General
    A few small bug fixes.

New/improved

  • Columns / Rows » Put together rows or columns from several sheets...
    Improved, now also copies the original column widths to the new sheet
  • Columns / Rows » View and manage hidden rows and columns...
    Display the column titles along with the column numbers
  • Select » Select cells in column with same value (above and below active cell)
    Has been renamed to:
    Select » Select adjacent cells in column with the same value
    Now works on protected sheets too.
  • Select » Select cells in column with same value (below active cell)
    Has been renamed to:
    Select » Select adjacent cells below active cell with the same value
    Now works on protected sheets too.
  • Format » Insert filename in header or footer...
    has been renamed to:
    Insert workbook's path and name in header, footer or cell...
    This utility is now also placed in the Fill submenu
  • Export » Copy sum of selection to clipboard
    Copy the calculated sum of selected cells to your clipboard.
    Just like you can see in the statusbar of Excel.
    Copy the sum to your clipboard
  • Export » Copy average of selection to clipboard
    Copy the calculated average of selected cells to your clipboard.
    Just like you can see in the statusbar of Excel.
    Copy the average to your clipboard
  • Import » Merge files together in a new file...
    I've added the option to exclude the file extensions (such as .dbf or .txt) from the sheetnames.
  • System » Resize the Excel application...
    Resize the Excel application to fixed screen resolutions. This way you can easily test and see how your document or application will look on computers with different screen resolutions. However, the maximum size is limited (by Excel) to your current screen-resolution.
    System » Resize the Excel application...
  • Columns / Rows » Merge column data (join cells)...
    This utility now remembers your last used settings
  • Columns / Rows » Merge row data (join cells)...
    This utility now remembers your last used settings


« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years