ASAP Utilities Changelog

What's new in ASAP Utilities 8.5.0

Feb 29, 2024
  • New/improved:Text › 7. Change Case (with options)...
  • Improved the "Set words to preserve/exclude" setting.
  • In addition to a space, it now also detects separate words based on any of the following characters: . ' ] ) ) { } : [ ( ; "
  • General:
  • Fixed some known small issues and made a few small improvements. Developed a fix for the issue where Excel sometimes stopped displaying the ASAP Utilities progress bar during processing.

New in ASAP Utilities 8.4.1 RC 1 (Jan 15, 2024)

  • Text › 7. Change Case (with options):
  • Improved the "Set words to preserve/exclude" setting.
  • In addition to a space, it now also detects separate words based on any of the following characters: . ' ] ) ) { } : [ ( ; "
  • ASAP Utilities Options › 1. Settings, language and contact information:
  • Microsoft Office's Visual Basic for Applications (VBA) still does not natively support mouse wheel scrolling in UserForms.
  • This has been a request to Microsoft for many years already. Users requested it to us too, and since Microsoft still hasn't implemented it, we investigated and implemented a workaround for this in ASAP Utilities.
  • You can now enable this via the option:
  • "Enable Mouse Wheel Scrolling (Added at users request - Experimental, may crash Excel on some systems)"
  • There appears to be a bug in certain Excel 365 builds which currently may cause this new functionality to crash Excel, so be careful when you try it the first time.
  • To try it, just enable the option, and then for example choose ASAP Utilities › Info... If that crashes Excel (sometimes you see a cryptic error 35010), go back to the options and turn off this setting until you have updated your Excel version/build.
  • General:
  • Fixed some known small issues and made a few small improvements.

New in ASAP Utilities 8.4.0 (Jan 3, 2024)

  • New/improved:
  • Export in JSON format:
  • While Excel can import data in JSON format, it cannot natively save in this format.
  • Now, with ASAP Utilities, you can export to JSON.
  • JSON, or JavaScript Object Notation, is a lightweight format for storing and transporting data, often used in web applications for data exchange.
  • Saving your data in JSON-format has been added to the following tools:
  • Export › Export selection or active sheet as new file... Export › Export worksheets as separate files
  • Import data from copied Word Table without splitting cells at line breaks:
  • Via ASAP Utilities › ASAP Utilities Options › 11. New tools in development (English only)
  • When you copy a table from Word to Excel, Excel splits cells with line breaks into separate cells.
  • This tool helps you transfer your table to Excel while maintaining its original structure.
  • General:
  • Fixed some known issues and made a few small improvements.
  • Bug fixes:
  • Sheets › Reset Excel's last cell:
  • Fixed a bug that was introduced in version 8.3 where, if your dataset didn't begin in row 1 or column A, it could mistakenly delete one or more rows or columns of data at the end of your dataset.

New in ASAP Utilities 8.4.0 RC 3 (Dec 29, 2023)

  • New/improved:
  • Export in JSON format:
  • While Excel can import data in JSON format, it cannot natively save in this format.
  • Now, with ASAP Utilities, you can export to JSON.
  • JSON, or JavaScript Object Notation, is a lightweight format for storing and transporting data, often used in web applications for data exchange.
  • Saving your data in JSON-format has been added to the following tools:
  • Export › Export selection or active sheet as new file... Export › Export worksheets as separate files...
  • Save your dataset in JSON format
  • Save Excel sheets in JSON format
  • Import data from copied Word Table without splitting cells at line breaks
  • Via ASAP Utilities › ASAP Utilities Options › 11. New tools in development (English only)
  • When you copy a table from Word to Excel, Excel splits cells with line breaks into separate cells.
  • This tool helps you transfer your table to Excel while maintaining its original structure.
  • General:
  • Fixed some known issues and made a few small improvements.
  • Bug fixes:
  • Sheets › Reset Excel's last cell:
  • Fixed a bug that was introduced in version 8.3 where, if your dataset didn't begin in row 1 or column A, it could mistakenly delete one or more rows or columns of data at the end of your dataset.

New in ASAP Utilities 8.3.0 (Nov 15, 2023)

  • General:
  • Some ribbon icons have been refined to look sharper on displays with a Windows Display Scale setting over 200%.
  • All forms in our app now use a modern font, aligning with the one Excel uses.
  • This offers a subtle upgrade from the standard font found in xlam add-ins, aiming for a more harmonious user experience.
  • We've addressed some known issues and made a few small, yet significant, improvements to enhance your experience.

New in ASAP Utilities 8.2.0 (Sep 7, 2023)

  • General:
  • We've addressed some known issues and made many small, yet significant, improvements to enhance your experience. The localized per language ribbon/menu xlam-files no longer use an API call.
  • This is related to the following if your company blocks Win32 API calls from Office macros:
  • https://www.asap-utilities.com/faq-questions-answers-detail.php?m=340

New in ASAP Utilities 8.2.0 RC 1 (Jun 15, 2023)

  • Fixed some known issues.

New in ASAP Utilities 8.1.0 (Feb 8, 2023)

  • New/improved:
  • Range › 4. Sort values inside each cell in selection...
  • By request, we have added an option to sort in reverse order.
  • You can then for example sort first by state and then by city for a cell that includes "City, State".
  • Sort inside cells in reverse order
  • General:
  • A few visual improvements.
  • Bug fixes:
  • Autofit row height (also on merged cells)
  • Improved when working with a merged area that contains many rows and a large amount of text.
  • Merge and/or import multiple files...
  • Fixed a bug where a combination of an empty first row and formulas with references to another sheet and possible sheet protection could cause a shift in values.
  • General:
  • Fixed some other known issues.

New in ASAP Utilities 8.1 RC 3 (Dec 23, 2022)

  • Bug fixes:
  • Autofit row height (also on merged cells)
  • Improved when working with a merged area that contains many rows and a large amount of text.
  • Merge and/or import multiple files...
  • Fixed a bug where a combination of an empty first row and formulas with references to another sheet and possible sheet protection could cause a shift in values.
  • General
  • Fixed some other known issues.

New in ASAP Utilities 8.0.3 RC 1 (Dec 8, 2022)

  • New/improved:
  • General:
  • A few visual improvements.
  • Bug fixes:
  • Autofit row height (also on merged cells):
  • Improved when working with a merged area that contains many rows and a large amount of text.
  • Merge and/or import multiple files...:
  • Fixed a bug where a combination of an empty first row and formulas with references to another sheet and possible sheet protection could cause a shift in values.
  • General:
  • Fixed some other known issues.

New in ASAP Utilities 8.0.2 (Nov 11, 2022)

  • New/improved in 8.0.2
  • Range:
  • Sort values inside each cell in selection...
  • Now supports the sorting of Unicode text if you have Excel 2021 or Excel 365.
  • General:
  • A few visual improvements.
  • Speed:
  • Improved speed when certain quirks of Excel 365 could have caused delays.
  • Bug fixes:
  • Range › Sort values inside each cell in selection:
  • Your last used settings weren't rememberd and the 'semicolon' option didn't work. This is now fixed.
  • =ASAPEXTRACTFILENAME():
  • Starting from version 8.0, if a single value or cell was chosen, then this function returned the path + filename instead of just the filename. This is now fixed.
  • General:
  • Fixed some other known issues.

New in ASAP Utilities 8.0.0 (Oct 4, 2022)

  • New/improved:
  • Tip of the day - Discover more features:
  • By request, a daily tip to get to know ASAP Utilities better.
  • ASAP Utilities contains an incredible amount of small handy tools and it might be hard to remember them all.
  • Each day we show you a handy tool that you may have forgotten about or never knew existed.
  • Count duplicates and give each set of duplicates its own color:
  • Improved. Better distinctive colors and use of patterns are used.
  • This allows now to identify up to 264 sets of duplicated values with unique colors.
  • (In case more sets of duplicates are found, those remaining sets of duplicates are filled with the same color.)
  • Find and run a utility:
  • Upon request you can now toggle between showing the full descriptions or not. The advantage is that the list of tools found is quicker to scroll through without the descriptions.
  • New worksheet function:
  • =ASAPGETINDENTLEVEL(cell)
  • Returns the indent level for the cell.
  • If you afterwards change the indent level in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.
  • Parameters:
  • # cell = The cell to get the indent level from.
  • Updated worksheet function:
  • =ASAPEXTRACTNUMBERS(text, optional strip_leading_zeros)
  • New optional parameter; strip_leading_zeros
  • If TRUE and the result is a number with one or more leading zeros, then those leading zeros will be removed. Default is FALSE.
  • Support for dynamic array formulas and spilling:
  • The following functions can now also be used in dynamic array formulas and support spilling:
  • ASAPCELLCOLORINDEX()
  • ASAPCOUNTCHAR()
  • ASAPEXTRACTFILENAME()
  • ASAPEXTRACTFOLDERNAME()
  • ASAPEXTRACTNUMBERS()
  • ASAPFONTCOLORINDEX()
  • ASAPGETCOMMENT() ASAPGETDOMAIN()
  • ASAPGETFONTNAME()
  • ASAPGETFONTSIZE()
  • ASAPGETFORMULA()
  • ASAPGETFORMULAINT()
  • ASAPGETHYPERLINK()
  • ASAPGETINDENTLEVEL
  • ASAPGETNUMBERFORMAT()
  • ASAPISBOLD()
  • ASAPISFORMULA()
  • ASAPSPELLNUMBER()
  • ASAPSTRIPNUMBERS()
  • Worksheet functions support conditional applied formatting:
  • The following functions now support/read formatting applied via conditional formatting:
  • ASAPCELLCOLORINDEX()
  • ASAPCOUNTBYCELLCOLOR()
  • ASAPCOUNTBYFONTCOLOR()
  • ASAPCOUNTSHADES()
  • ASAPFONTCOLORINDEX()
  • ASAPISBOLD()
  • ASAPSUMBYCELLCOLOR()
  • ASAPSUMBYFONTCOLOR
  • Select all shapes within the selected range:
  • Selects all shapes that are inside or touch the selected range. Both visible and hiddens shapes will be selected.
  • via ASAP Utilities Options > 11. New tools in development (English only)
  • Clear Pivot Tables cache and refresh:
  • Clears the cache from the pivot tables on the current worksheet or in the entire workbook.
  • via ASAP Utilities Options > 11. New tools in development (English only)
  • General:
  • Many (smaller but important) improvements. By request; the license info screen now contains a button to remove the license.
  • Minimum supported Excel version is 2010:
  • Starting from version 8, ASAP Utilities requires at least Excel 2010, but we recommend to use at least Excel 2013 because that is still updated by Microsoft.

New in ASAP Utilities 8.0.0 RC 0 (Jun 10, 2022)

  • New worksheet function:
  • =ASAPGETINDENTLEVEL(cell)
  • Returns the indent level for the cell.
  • If you afterwards change the indent level in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.
  • Parameters:
  • # cell = The cell to get the indent level from.
  • General:
  • Several small improvements

New in ASAP Utilities 7.9.4 (Apr 6, 2022)

  • Several small improvements and a few small bug fixes.

New in ASAP Utilities 7.9.4 RC1 (Dec 15, 2021)

  • A few small improvements.

New in ASAP Utilities 7.9.3 (Oct 14, 2021)

  • New/improved:
  • General
  • Windows 11 and Excel 2021 have been added in the documentation as being supported.
  • In the universal 32+64-bits edition for Excel 2010-2021/365:
  • General
  • Several small (performance) improvements
  • Information » Display your screen resolution
  • In case of multiple displays this used to display the resolution of the main display. It now reports the resolution of the display where the Excel window is active.
  • File & System » Resize the Excel window to standard screen resolutions...
  • In case of multiple displays this used to resize and move the Excel window to the main display. It now resizes on the display where the Excel window is active.
  • Objects & Comments » Comment tools...
  • » Create report in new workbook
  • Fixed a bug that could lead to an error in Excel 2010 and Excel 2013 with ASAP Utilities versions 7.7.1 and later with this option chosen.
  • Sheets » Reset Excel's last cell
  • Improved handling of merged cells status at the end when overlapping and exceeding the datarange.

New in ASAP Utilities 7.9.2 (Jul 15, 2021)

  • New/improved:
  • Numbers & Dates » Convert unrecognized numbers (text?) to numbers
  • Starting from version 7.9 in some situations it didn't convert some numbers anymore. This is now fixed in version 7.9.2
  • Information » Create a list of filenames and properties in a folder...
  • When choosing more details to report, image dimension values could contain an invisible unicode character at the beginning. In version 7.9.2 that character will be stripped first before the value is reported in the the worksheet.
  • Export » Export worksheets as separate files...
  • Fixed the bug where a slash could be added at the end of the path instead of a backslash when you first had an online (https) folder selected and then switched to a local folder for the export.

New in ASAP Utilities 7.9.2 RC 1 (Jul 8, 2021)

  • Numbers & Dates » Convert unrecognized numbers (text?) to numbers
  • Starting from version 7.9 in some situations it didn't convert some numbers anymore. This is now fixed in version 7.9.2
  • Information » Create a list of filenames and properties in a folder...
  • When choosing more details to report, image dimension values could contain an invisible unicode character at the beginning. In version 7.9.2 that character will be stripped first before the value is reported in the the worksheet.
  • Export » Export worksheets as separate files...
  • Fixed the bug where a slash could be added at the end of the path instead of a backslash when you first had an online (https) folder selected and then switched to a local folder for the export.

New in ASAP Utilities 7.9.1 (Jun 16, 2021)

  • In the universal 32+64-bits edition of version 7.9, the Japanese menu was accidentally in the wrong language (Chinese). This is now fixed.
  • A few small improvements

New in ASAP Utilities 7.9.1 RC 1 (May 31, 2021)

  • General:
  • In the universal 32+64-bits edition of version 7.9, the Japanese menu was accidentally in the wrong language (Chinese). This is now fixed.

New in ASAP Utilities 7.9 (May 27, 2021)

  • You can now use regular expressions in Excel via ASAP Utilities:
  • Regular expressions are a clever way to find & replace text (similar to 'wildcards')
  • Regular expressions are very common in some areas of computing, and are often known as regex or regexp. Not all regex are the same - so reading the below link from Microsoft Docs is recommended.
  • You can use the regular expression syntax in ASAP Utilities according to the following documentation from Microsoft:
  • Regular Expression Syntax (Scripting) | Microsoft Docs

New in ASAP Utilities 7.8.2 RC 1 (Feb 16, 2021)

  • New/improved:
  • In the universal 32+64-bits edition for Excel 2010-2019/365 - You can now use regular expressions in Excel via ASAP Utilities. These expressions are:
  • ASAPREGEXMATCH - Returns true or false is a value matches a regular expression
  • ASAPREGEXEXTRACT - Returns the text that matches the regular expression within the specified value
  • ASAPREGEXREPLACE - Replaces part of a text string with a different text string using regular expressions
  • Select:
  • Select cells based on content, formatting and more. You can now select cells that match a regular expression.
  • General:
  • A few small improvements.

New in ASAP Utilities 7.8.1 (Dec 16, 2020)

  • A few small improvements and bug fixes.

New in ASAP Utilities 7.8 (Nov 3, 2020)

  • Excel 365 Desktop (both 32- and 64-bit version)
  • Excel 2019 (both 32- and 64-bit version)
  • Excel 2016 (both 32- and 64-bit version)
  • Excel 2013 (both 32- and 64-bit version)
  • Excel 2010 (both 32- and 64-bit version)
  • Excel 2007
  • Excel 2003
  • Excel 2002/XP
  • Excel 2000

New in ASAP Utilities 7.8 RC 4 (Sep 28, 2020)

  • New/improved:
  • General
  • Fill » Copy values to empty cells below filled cells in selection
  • Since an update to Excel 365 in the summer of 2020, cells with values of more than 255 characters could cause an error when using this tool. Other Excel versions with the latest updates, including Excel 2019 were not impacted.
  • However, we've created a workaround so it is working as expected again in all Excel versions.
  • NEW:
  • Sheets » Quickly rename multiple sheets at once...
  • This tool allows you to quickly rename multiple or all sheets in your workbook at once.
  • You can:
  • Use "Find & Replace" in sheet names
  • Insert text before sheet names
  • Insert text after sheet names
  • Automatically generate sheet names from the values in selected cells.
  • Via a preview you can see upfront what the new names will become.
  • Fill » Create a list of filenames and properties in a folder...
  • Now has an option to also report empty folders.
  • Include empty folders
  • Export » Export worksheets as separate files...
  • When exporting text files in unicode format, you can now choose between the standard UTF-16 character coding from Excel, or the commonly used UTF-8 character coding.
  • Fill » Copy values to empty cells below filled cells in selection
  • Since an update to Excel 365 in the summer of 2020, cells with values of more than 255 characters could cause an error when using this tool. Other Excel versions with the latest updates, including Excel 2019 were not impacted.
  • However, we've created a workaround so it is working as expected again in all Excel versions.
  • A few small bug fixes.
  • Universal 32+64-bit edition only:
  • Select » Select cells based on content, formatting and more...
  • For users with Excel 365 with threaded comments:
  • In Excel there is no easy way to quickly identify which threaded comments have been resolved and which ones not.
  • Therefore, by request, we have added two new options in the "Based on formatting and more" tab to quickly select cells with either resolved or unresolved threaded comments:
  • Resolved comment thread
  • Unresolved comment thread
  • When the cells then are selected you can for example given them a color to quickly identify and further process.
  • Easily select cells with resolved or unresolved threaded comments
  • Import » Merge and/or import multiple files...
  • Putting the filename in column A when importing Excel files to merge into a single new worksheet didn't work anymore in version 7.7.1. This is now fixed.

New in ASAP Utilities 7.7,1 (Jul 8, 2020)

  • New/improved:
  • General:
  • A few small improvements and bug fixes based on the feedback from our users.
  • Web » Decode all URL and HTML encoded text:
  • Didn't decode all characters in 64-bits edition of Excel. This is now fixed.
  • Web » Clean data and formatting...:
  • "Fix (text)numbers" didn't always work in version 7.7 due to a bug. This is now fixed.
  • New: Write out numbers in French:
  • Text » Spell/write out numbers or amounts (EN, DE, NL)...
  • Has been renamed to "Spell/write out numbers or amounts (EN, DE, FR, NL)..." because the French language is added by request.
  • You can now write out numbers/amounts in French via this tool or by using the =ASAPSPELLNUMBER() worksheet function.
  • In the universal "32+64-bits edition" for Excel 2010 and later only:
  • New: Remove duplicated values per row in your selection:
  • via ASAP Utilities Options » New tools in development (English only)
  • "Remove duplicated values per row in your selection"
  • This will remove the duplicated values per row in your selection.
  • New: Quickly rename sheets multiple sheets at once:
  • via ASAP Utilities Options » New tools in development (English only):
  • "Rename sheets"
  • This allows you to quickly change the names of multiple or all sheets in your workbook at once.
  • You can choose to add text at the en of the name of each sheet, add it at the front, perform a find & replace on the sheet names or name the sheets based on the values in a range.
  • =ASAPGETCOMMENT(cell):
  • This function now also returns the content of the new Excel 365 threaded comments when used.
  • In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  • (Microsoft: The difference between threaded comments and notes)
  • Objects & Comments » Comment tools...:
  • "Extract/report content of comments" now also returns the content of the new Excel 365 threaded comments when used.
  • In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  • (Microsoft: The difference between threaded comments and notes)
  • General:
  • A few users got an "Can't find DLL entry point GetTickCount...." error
  • That was caused by certain software that blocked access to standard Windows functionality.
  • We've got this reported about 5 times, and the information on the following page helped the clients to solve it:
  • https://forums.zotero.org/discussion/70171/word-windows-plugin-runtime-error-453
  • In that case you may have to add ASAP Utilities to a whitelist in Cylance Protect
  • https://threatvector.cylance.com/en_us/home/cylanceprotect-feature-release-macro-script-control.html
  • In this new version of ASAP Utilities, we've used a workaround for this Windows timer function and also added some extra error handling to prevent that error from in case blocked.

New in ASAP Utilities 7.7,1 Pre-release (Mar 27, 2020)

  • General
  • A few small improvements and bug fixes based on the feedback from our users.
  • Web»Decode all URL and HTML encoded text:
  • Didn't decode all characters in 64-bits edition of Excel. This is now fixed.
  • Currently in the universal "32+64-bits edition" for Excel 2010 and later only:
  • New tools:
  • Via ASAP Utilities Options»New tools in development (English only)
  • Remove duplicated values per row in your selection
  • This will remove the duplicated values per row in your selection.
  • Rename sheets .This allows you to quickly change the names of multiple or all sheets in your workbook at once.
  • You can choose to add text at the end of the name of each sheet, add it at the front, perform a find & replace on the sheet names or name the sheets based on the values in a range. =ASAPGETCOMMENT(cell)
  • This function now also returns the content of the new Excel 365 threaded comments when used.
  • In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  • (Microsoft: The difference between threaded comments and notes)
  • Objects & Comments»Comment tools:
  • "Extract/report content of comments" now also returns the content of the new Excel 365 threaded comments when used.
  • In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
  • (Microsoft: The difference between threaded comments and notes)

New in ASAP Utilities 7.7 (Feb 5, 2020)

  • General:
  • Many small improvements, performance improvements and a few bug fixes based on the feedback from our users.
  • Columns & Rows » Autofit row height (also on merged cells)
  • Much faster speed in certain scenarios.
  • Range » Delete all range names in the entire workbook
  • Much faster when it involves thousands of named ranges.
  • Range » Delete all range names with an invalid cell reference (#REF!)
  • Much faster when it involves thousands of named ranges.
  • Format » Remove all unused styles on every sheet
  • Much faster and better in handling large workbooks with hundreds of thousands of cells to investigate and thousands of styles.
  • Range » Copy selection and paste into only the visible cells...
  • There is a bug in version 7.6.2 and older; In case the target range has only hidden columns (and not hidden rows) then nothing happened, which was not correct. This is now fixed.
  • Improved setup
  • In case you were only offered to install the 32-bits edition, then the setup has detected an old Excel version on your system and defaults to the 32-bits edition.
  • In this new version, we have changed this so that in case the setup detects both a 64-bits edition of Excel and an old 32-bits edition of Excel on the same system, the default type to install will be the universal and faster "32+64-bits" edition for Excel 2010 and later.

New in ASAP Utilities 7.7 RC1 (Jan 10, 2020)

  • General:
  • Small improvement in the installer.
  • Many small improvements, performance improvements and a few bug fixes based on the feedback from our users.

New in ASAP Utilities 7.6.2 (Jun 21, 2019)

  • Supported Excel versions
  • ASAP Utilities 7.6 works with:
  • Excel 365 (both 32- and 64-bit version)
  • Excel 2019 (both 32- and 64-bit version)
  • Excel 2016 (both 32- and 64-bit version)
  • Excel 2013 (both 32- and 64-bit version)
  • Excel 2010 (both 32- and 64-bit version)
  • Excel 2007
  • Excel 2003
  • Excel 2002/XP
  • Excel 2000
  • On any Windows system that matches the Excel system requirements.
  • Free upgrade if you purchased version 7.x or 5.x
  • If you purchased a license for version 7.x or 5.x, then you get version 7.6 free of charge. You can use the same license details.
  • If you purchased a license in 2012 or earlier, then please contact us for a 50% discount to upgrade to version 7.
  • To upgrade, just install the new version "on top" of the existing version on your computer.
  • ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.
  • New/improved
  • General
  • Several few small improvements, and a few text corrections and bug fixes.
  • Format » Clean data and formatting...
  • Improved speed.
  • In case of a filtered list, hidden cells will now be skipped (just like Excel does when editing or formatting cells in a filtered list).

New in ASAP Utilities 7.6.2 RC1 (May 22, 2019)

  • A few small improvements and bug fixes.

New in ASAP Utilities 7.6.0 (Apr 2, 2019)

  • New/improved:
  • General:
  • Several few small improvements and bug fixes.
  • Sheets » Reset Excel's last cell
  • Improved performance when it involves many (thousands of) excess columns.
  • Information » Fast calculation on selected cells...
  • The calculation is now done on only the visible cells in your selection.
  • This is useful if you use it on a filtered table.

New in ASAP Utilities 7.5.3 (Dec 12, 2018)

  • Improved installer:
  • In a few rare situations the setup didn't correctly detect if you had the 32-bit edition of Excel 2010 or later installed and did not offer you the option to choose between the "32-Bit Edition" and the recommended and faster universal "32+64-Bit Edition.
  • A few small improvements

New in ASAP Utilities 7.5.3 Pre-release (Dec 11, 2018)

  • General:
  • Improved installer; In a few rare situations the setup didn't correctly detect if you had the 32-bit edition of Excel 2010 or later installed and did not offer you the option to choose between the "32-Bit Edition" and the recommended universal "32+64-Bit Edition.
  • A few small improvements

New in ASAP Utilities 7.5.2 (Nov 20, 2018)

  • ASAP Utilities 7.5.2 works with:
  • Excel 365 (both 32- and 64-bit version)
  • Excel 2019 (both 32- and 64-bit version)
  • Excel 2016 (both 32- and 64-bit version)
  • Excel 2013 (both 32- and 64-bit version)
  • Excel 2010 (both 32- and 64-bit version)
  • Excel 2007
  • Excel 2003
  • Excel 2002/XP
  • Excel 2000
  • On any Windows system that matches the Excel system requirements.
  • New/improved:
  • General
  • A few small improvements based on feedback from the past weeks.
  • Setup
  • Improved: In case a user runs the setup with elevated privileges and at step 7 of the setup, he/she chooses to automatically add ASAP Utilities to the Excel menu for all users, then that user no longer has to log off/log in in order to see ASAP Utilities added/updated in Excel.
  • Other users on the system will see ASAP Utilities updated in the Excel menu when they (re)login after the setup has been completed.

New in ASAP Utilities 7.5.2 RC1 (Nov 17, 2018)

  • A few small improvements based on feedback from the past weeks.
  • Setup: In case a user runs the setup with elevated privileges and at step 7 of the setup, he/she chooses to automatically add ASAP Utilities to the Excel menu for all users, then that user no longer has to log off/log in in order to see ASAP Utilities updated in Excel.
  • Other users on the system will see the changes in Excel only when they (re)login after the setup has been completed.
  • Add ASAP Utilities automatically to the Excel menu

New in ASAP Utilities 7.5.1 (Nov 5, 2018)

  • New/improved in 7.5.1:
  • The "32+64-Bit Edition":
  • When upgrading from an earlier 7.x version of ASAP Utilities:
  • During the setup of version 7.5, when choosing "Add ASAP Utilities automatically to the Excel menu for anyone who uses this computer (all users)", the setup didn't trigger for the other users to update the Excel setting that stored the filename of our add-in (from "ASAP Utilities x64.xlam" to "ASAP Utilities.xlam"). This is corrected in version 7.5.1

New in ASAP Utilities 7.5 RC7 (Nov 16, 2017)

  • Both editions:
  • General
  • A few small improvements.
  • "32-bit edition" only:
  • General/startup
  • Starting from November 8, we've got contacted by ten users that suddenly ran into an issue with their ASAP Utilities. That seemed to be caused by a recent Microsoft update.
  • Unfortunately we haven't been able to reproduce this on any of our test or production systems so far, but in corporation with these users we've found a workaround for it.
  • In case you get the following error, then please install this newer version of ASAP Utilities:
  • "Sorry, something went wrong in the ASAP Utilities.xla auto_open() event, build menu.
  • -2147417848: Method 'ASAP_Utilities_MenuBuilder' of object '_CPublic' failed on line 670"
  • In addition, we also recommend to keep your Office up to date, because the Microsoft team is continuously working on it:
  • # The importance of Microsoft Office Update | Fix random crashes
  • http://www.asap-utilities.com/blog/index.php/2017/10/30/the-importance-of-microsoft-office-update/
  • # Microsoft: Fixes or workarounds for recent issues in Excel for Windows
  • https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093
  • "32+64-bit edition" only:
  • Select » Select cells based on content, formatting and more...
  • All available select options in the drop-downs are now numbered.
  • Six new options added, where you can select cells based on multiple values at once.
  • These values can be in a range of cells in your workbook.
  • You can use this for example to select negative keywords in a large dataset.
  • 1. contains any of the values specified in a range
  • searching for "test" selects cells with values such as "This is a test" or "Testing now"
  • 2. does not contain any of the values specified in a range
  • searching for "test" selects cells without the text "test" in it.
  • 3. contains any of the full words specified in a range
  • searching for "test" selects cells with values such as "This is a test" or "Ready (test)"
  • searching for "test" does NOT select cells with a value such as "We're testing this"
  • 4. does not contain any of the full words specified in a range
  • searching for "test" does NOT selects cells with values such as "This is a test" or "Ready (test)"
  • searching for "test" does select cells with a value such as "We're testing this"
  • 5. equals a value specified in a range
  • searching for "test" selects cells with the value "test" only.
  • searching for "test" does NOT select cells with a value such as "test 123"
  • 6. does not equal a value specified in a range
  • searching for "test" does NOT selects cells with the value "test" only.
  • searching for "test" selects any cell that has not the same exact content, such as "test 123"
  • General
  • When you used the Preview pane in Windows File Explorer, in some situations Excel showed a "Run-tim error '50290': Method 'Saved' of object '_Workbook' failed" error. We've created a workaround/fix for that.

New in ASAP Utilities 7.4 (Sep 27, 2017)

  • Both editions:
  • General:
  • Several small improvements.
  • Export » Export selection or active sheet as new file...:
  • Export to CSV Unicode, newline character added at the end of the file.
  • Better preserving of the Pivot Table formatting when exporting as values.
  • Export » Export worksheets as separate files...:
  • Better preserving of the Pivot Table formatting when exporting as values.
  • Numbers & Dates » Convert/recognize dates...:
  • Improved speed
  • Columns & Rows » Delete all empty rows:
  • Now handles large Tables better.
  • Functions =ASAPSUMBYCELLCOLOR() and =ASAPSUMBYFONTCOLOR():
  • Cells with logical values (TRUE/FALSE) are now ignored, and cells with a date value are now included too, so that you can also sum dates based on the cell's interior or font color.
  • "32+64-bit edition" only:
  • Improved startup speed.
  • German language: fixed the spelling in the spell number functions (füftausendzwölf / f~nftausendzwxlf)
  • Workaround/fixed the small xlb file size increase caused by a bug in Excel when then right-click menu in ASAP Utilities was enabled.

New in ASAP Utilities 7.4 RC2 (Jul 19, 2017)

  • A few small improvements.

New in ASAP Utilities 7.3.1 Stable (Jul 19, 2017)

  • Columns & Rows » Merge column data (join cells)...
  • The change we made in version 7.3 to handle merged cells in your selection caused this tool to not work anymore on data in an Excel Table. That is now fixed.
  • General
  • A few small improvements.

New in ASAP Utilities 7.2.1 (Oct 14, 2016)

  • Improved/fixed:
  • Fixed a bug that was introduced in version 7.2 and that could, in certain situations, cause that the folder to store the ASAP Utilities favorites menu was not created for new users in their %APPDATA%ASAP Utilities folder. One or more errors were then displayed. (The favorites menu cannot be created in the folder... or The ribbon file '' doesn't seem to exist...)

New in ASAP Utilities 7.2 (Oct 7, 2016)

  • Formulas > Transpose data with formulas:
  • Fixed the bug that caused this tool from not working ("Sorry, something unexpected ent wrong at code line 1010...")
  • Web > Decode all URL and HTML encoded text:
  • This tool now also decodes "&#x.." encoded characters, such as the following:
  • Brasília > Brasília | Tecnológicas > Tecnológicas | Università > Università
  • General:
  • Several small improvements and fixes.
  • The 64-bit edition didn't properly detect that if it was the Home&Student edition that was installed. This is now fixed.

New in ASAP Utilities 7.1 (Oct 7, 2016)

  • General:
  • A few small improvements
  • Fixed a situation that could cause a compile error in ASAP Utilities in some Japanese and Chinese versions of Excel.
  • Text > Spell/write out numbers or amounts (EN, DE, NL):
  • Improved. English numbers between 10 and 99 now use a hyphen.
  • For example, 35 changed from being written as Thirty Five to Thirty-Five.
  • The decimals in numbers with decimals and without a currency are now written as hundredths in English, German or Dutch.
  • Sheets > Reset Excel's last cell:
  • Fixed a bug in the 32-bit edition; "Sorry, something went wrong at code line 1080..."

New in ASAP Utilities 7.0 (May 31, 2016)

  • General:
  • Several improvements compared to ASAP Utilities 5.6
  • Bug fixes:
  • A few small bug fixes

New in ASAP Utilities 5.6 (Dec 1, 2015)

  • Improved:
  • Export » Export selection as HTML table to clipboard...
  • Export » Export worksheets as separate files...
  • NEW: Text » Subscript the numbers in Chemical Formulas
  • Export » Export selection or active sheet as new file...
  • Improved: Import » Insert (delimited) text file...
  • Select » Select cells based on content, formatting and more...
  • NEW: Convert long HEX values to ASCII text in selected cells
  • Improved: Favorites & Shortcut keys » Edit your favorite tools and shortcut keys...
  • Improved: Import » Merge and/or import multiple files...
  • Bug fixes:
  • Information » Count duplicates and give each set of duplicates its own color
  • Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...
  • File & System » Find and remove external links...
  • Improved compatibility with Excel 2013/2016
  • Startup, right-click menu

New in ASAP Utilities 5.5 (Dec 3, 2014)

  • NEW: Range > Sort values inside each cell in selection...
  • NEW: Information > Count duplicates and give each set of duplicates its own color
  • NEW: > Text > Change Case (with options)...
  • NEW: Range > Copy selection and paste into only the visible cells...
  • NEW: Format > Replace conditional formatting with static formatting in selection
  • Improved: Export > Export worksheets as separate files...
  • Improved: Text > Convert/recognize dates...
  • Improved: File & System > Find and remove external links...
  • Improved: Export > Export selected chart or range as image (file)...
  • Improved: Sheets > Split the selected range into multiple worksheets...
  • Improved: Favorites & Shortcut keys > Edit your favorite tools and shortcut keys...
  • Improved: function =ASAPSHEETNAME(optional reference)
  • Improved: Columns & Rows > Autofit row height (also on merged cells)
  • Improved: Range > Find and/or replace in all sheets...
  • Improved: Bulk replace: replace multiple values at once
  • NEW: Detect adjacent row/column data and merge cells...
  • New: Keep or delete certain Rich Text formatted characters...
  • New: Text to Columns based on in-cell formatting changes (split by bold, italic, color etc.)
  • NEW: Change cells to MAC Address formatting...
  • Bug fixes:
  • Information > Create a list of filenames and properties in a folder...
  • Improved handling of folder names that are longer than 255 characters.
  • Sheets > Delete unused empty ending rows/columns
  • Workaround for the error that occurred when the ending empty columns or rows were part of a pivot table.
  • Sheets > Reset Excel's last cell
  • Workaround for the error that occurred when after the last cell there were still empty columns and/or rows that were part of a pivot table.
  • Columns & Rows > Delete all empty columns
  • Returned an error when a pivot table contained empty columns because these could not be removed. These columns are now skipped.
  • Columns & Rows > Delete all empty rows
  • Returned an error when a pivot table contained empty row because these could not be removed. These rows are now skipped.
  • Columns & Rows > Delete all hidden rows and/or columns...
  • Returned an error when a pivot table contained hidden rows and/or columns because these could not be removed. These rows and/or columns are now skipped.
  • Text > Convert/recognize dates...
  • Now skips cells that contain only one or more space characters.
  • Select > Select cells based on content, formatting and more...
  • Improved the notification when no results were found or all selected cells match your criteria. Also improved preserving the initial selection when selecting values or formulas and no results were found.
  • Favorites & Shortcut keys > Edit your favorite tools and shortcut keys...
  • Your changes were not shown until you restarted Excel. This is now fixed. After closing the tool, you'll immediately see the changes in your "Favorites & Shortcut keys" menu again.
  • Select > Select cells based on content, formatting and more...
  • The options "contains" and "does not contain" were not case sensitive if you choose the option "Match Case". This is now fixed.
  • General
  • A few small bug fixes and improvements.

New in ASAP Utilities 5.2.1 (Feb 19, 2014)

  • Sheets > Split the selected range into multiple worksheets:
  • Fixed a bug that was introduced in version 5.2 and caused the following option to not work correct: 'For every new value/group in column'.

New in ASAP Utilities 5.2 (Feb 15, 2014)

  • Format » Detect and visualize adjacent data/group changes:
  • New: You can now specify the line color for the border.
  • And you can choose to remove any existing horizontal borders upfront.
  • Bug fixes:
  • Only applies if you use Excel 2007, 2010 or 2013 that is not English, Spanish, French, German or Dutch: Fixed the following error that appeared for some users after they installed version 5.1:
  • Sorry, ASAP Utilities cannot be started.
  • The file '' doesn't seem to exist.
  • Please reinstall ASAP Utilities (or make sure the xlam file exists in the subfolder \resources\).

New in ASAP Utilities 5.1 (Jan 28, 2014)

  • New features and improvements:
  • Range > Advanced sorting: We've added a new sort option: "Value, ignore minus sign (-) in numbers"
  • Range > Advanced sorting: We've added a new sort option: "Reverse order"
  • NEW: Count and color unique duplicate values via ASAP Utilities Options > New tools in development (English only)
  • NEW: Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake') via ASAP Utilities Options > New tools in development (English only)
  • Import > Merge and/or import multiple files: New option to choose if the data should be copied/pasted as 'values' or 'formulas'.
  • Text > Replace accented characters (á, ë, ñ etc.): Greek accented characters have been added.
  • Web > Decode all URL and HTML encoded text: Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).
  • Setup, Trusted Publishers: During the setup you can now have our company (A Must in Every Office BV) automatically added to the List of Trusted Publishers in Excel
  • Customization, add tools to the Ribbon: The tools from ASAP Utilities are now easier to add to the QAT (Quick Access Toolbar) from Excel 2013/2010/2007
  • General: A few small improvements and a few spelling corrections.
  • Bug fixes and improvement:
  • Export > Export worksheets as separate files: The combination of a filtered table and excluding hidden rows/columns from the export could result in an error. This is now fixed.
  • Sheets > Change name of selected sheets to selected cell's value: Didn't work if the specified cell on the sheet was hidden. This is now fixed.
  • Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error were skipped. Such formulas are now updated too.
  • Range > Find and/or replace in all sheets: The combination of "Find/replace in: Range" and "Look in: Formulas", didn't replace anything. This is now fixed.
  • Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error or resulted in an error were skipped. These formulas are now updated too.
  • Copy to clipboard in Windows 8 x64: Due to a bug in the Windows 8 64-bit edition (only this edition), copying to the clipboard didn't work.
  • Information > Report the formulas used in the worksheets in your workbook: If you had a formula with a large number which was formatted as a date, then this could result in an "overflow" error. This is now fixed.
  • Web > Remove all HTML tags in the selected cells: Any text after the % character was decoded or removed. This is now fixed so that it only gets decoded and for example SQL statements that use % are now preserved.
  • Fill > Insert current date and time with seconds: The applied number format now shows the seconds too.
  • Text > Delete leading and trailing spaces: If a zero (0) was left as the result in a cell, then it was entered as "text". This is now corrected so that it is entered as a number.
  • Range > Fill cells with their formatted value is now also listed in the Numbers & Dates submenu: Numbers & Dates » Fill cells with their formatted value
  • Information > Fast calculation on selected cells: If you choose to "Create a workbook with these results" then the calculation results of the "Unique values" and "Values that appear only once" were switched.
  • Import > Merge and/or import multiple files: Speed improvement. In version 5.0 copying/preserving the row height on import was added, but it was slow for files with many rows. This is now fixed.
  • Columns & Rows > The paper saver (split columns): Didn't remember your last used settings. This is now fixed.
  • Language: The English term "wildcards" in the tools, has been replaced with the text "wildcard characters".
  • Speed improvement for editing data in Tables in Excel 2010 and Excel 2013: In Excel 2010/2013 some tools that edited data in a defined Table (a Table as via "Home > Format as Table" or "Insert > Table") on a worksheet with many formulas didn't run at the usual speed (sometimes it was even painfully slow). The speed difference could be huge compared to earlier Excel versions and compared to editing the same data when it was not in a defined Table*.
  • General: A few small bug fixes and improvements. When Excel 2013, 2010 or 2007 is doing something in the background and the running tool from ASAP Utilities has to wait for this, then this message is shown in the status bar "Waiting for response from Excel...".

New in ASAP Utilities 5.0 (Apr 9, 2013)

  • New features and improvements:
  • Official support for Excel 2013 (32-bit edition of Excel 2013 on both 32- and 64-bit Windows)
  • ASAP Utilities now works with
  • Excel 2013 (32-bit version)
  • Excel 2010 (32-bit version)
  • Excel 2007
  • Excel 2003
  • Excel 2002/XP
  • Excel 2000
  • On both 32- and 64-bit Windows, including the new Windows 8.
  • Range » Advanced sorting:
  • Much faster
  • Change not recognized numbers (text?) to numbers:
  • has been renamed to Convert unrecognized numbers (text?) to numbers
  • Favorites & Shortcuts » Organize your favorite tools:
  • has been renamed to Favorites & Shortcuts » Edit your favorite tools and shortcut keys...
  • Web » Clean information that is copied from websites:
  • has been renamed to Web » Clean data and formatting...
  • and this utility has also been placed in the Format, Text and Numbers & Dates submenus
  • Select » Deselect cells:
  • Much much faster when it involves entire rows or columns
  • Select » Inverse selection:
  • Much much faster when it involves entire rows or columns
  • Export » Export selection or active sheet as new file:
  • If you have Excel 2007 or newer you can now choose from
  • Excel 97-2003 Workbook (*.xls)
  • Excel Workbook (*.xlsx)
  • Excel Binary Workbook (*.xlsb) (instead of just 'Excel workbook')
  • Text » Start first word with Uppercase:
  • Instead of just making the first character uppercase, this utility now detects the first word by skipping other characters such as numbers and punctuation mark.
  • For example a cell with the value "12 documents" will now be changed to "12 Documents" or "[document]" to "[Document]"
  • Sheets » Split the selected range into multiple worksheets:
  • Improved. It now uses the value of a cell as displayed (using the cell's number format)
  • Formulas » Insert function from the ASAP Utilities library:
  • Improved (calculation) speed for these functions.
  • Export » Export worksheets as separate files:
  • When choosing to export as Excel workbooks you can now also choose to export just the values.
  • Columns & Rows » Conditional row and column select, hide or delete:
  • Improved performance and progress info.
  • General:
  • Several improvements and a few spelling corrections.
  • Bug fixes:
  • Sheets » Freeze panes on multiple sheets at once
  • In case a sheet had a Split then the freeze panes didn't work because a sheet cannot have both a Split and Freeze Panes.
  • This is now fixed by first removing a Split and then applying the Freeze Panes
  • Range » Advanced sorting
  • Now works correct on filtered data too.
  • Columns & Rows » Detect and visualize adjacent data/group changes...
  • Now works also if any of the cells in your selection contains an error.
  • Export » Export worksheets as separate files
  • The option "Text (Delimited by semicolon ';') (*.txt)" didn't work in all international versions. If your system didn't have the semicolon specified as list separator in your Windows' Region and Language settings, then this option didn't produce any files. This is now fixed.
  • The option "do not export hidden cells" was ignored in Excel 2007 and later. This is now fixed.
  • General
  • Fixed the "Compile error in hidden module: MGlobals_Open" that appeared in a few rare occasions.
  • A few small improvements.

New in ASAP Utilities 4.8.7 RC3 (Nov 14, 2012)

  • New features and improvements
  • Official support for Excel 2013 (32-bit edition of Excel 2013 on both 32- and 64-bit Windows)
  • Change not recognized numbers (text?) to numbers
  • Select » Deselect cells...
  • Select » Inverse selection...
  • Text » Start first word with Uppercase
  • Bug fixes:
  • Sheets » Freeze panes on multiple sheets at once
  • Range » Advanced sorting...
  • Columns & Rows » Detect and visualize adjacent data/group changes...
  • Export » Export worksheets as separate files...

New in ASAP Utilities 4.8.6 (Nov 14, 2012)

  • General:
  • A few small improvements and spelling corrections.
  • Formulas > Report the formulas used in the worksheets in your workbook:
  • Fixed the bug that could prevent the report from being created in case there were (very) long text values. This is now fixed

New in ASAP Utilities 4.8.5 (Nov 14, 2012)

  • New features and improvements:
  • Select > Select cells based on content, formatting and more...
  • Range > Paste values only
  • Objects & Comments > Add cell's value or formula to comment...
  • Formulas > Correct the link to the ASAP Utilities worksheet functions
  • Formulas > Insert an apostrophe (') in front of each formula in the selected cells
  • Formulas > Report the formulas used in the worksheets in your workbook
  • Range > Delete all range names with an invalid cell reference (#REF!)
  • Web > Remove all HTML tags in the selected cells...
  • IMPROVED: Fill > Create a list of filenames and properties in a folder...
  • Export > Export worksheets as separate files...
  • Export > Export selection or active sheet as new file...
  • Sheets > Change name of selected sheets to selected cell's value
  • Sheets > Insert multiple sheets (uses the cell values as sheet names)...
  • System > Save file and create backup
  • Export > Export selection or active sheet as new file...
  • Export > Export worksheets as separate files...
  • Numbers > Move minus sign from back to front (e.g. 65- to -65)
  • Export > Export worksheets as separate files...
  • New worksheet functions: =ASAPFILEPROPERTIES(property_name_or_id) / =ASAPLOADIMAGE(image_fullname, optional width_in_pixels, optional height_in_pixels)
  • Fill > Insert before and/or after each cell in your selection...
  • Text > Replace accented characters (á, ë, ñ etc.)...
  • Export > Export selection as HTML table to clipboard...
  • Web > Extract hyperlinks...
  • Columns & Rows > Merge column data (join cells)...
  • Bug fixes:
  • Numbers > Spell/write out numbers or amounts (EN, DE, NL)...
  • Import > Merge and/or import multiple files...
  • Objects & Comments > Comment tools...
  • Range > Find and/or replace in all sheets...
  • Export > Export worksheets as separate files...
  • ASAP Utilities worksheet functions

New in ASAP Utilities 4.7.2 (Sep 26, 2011)

  • New features and improvements:
  • Sheets » Split the selected range into multiple worksheets
  • By request, the utility now also copies the row height
  • Web » Activate hyperlinks (create from cell values)
  • Now automatically adds http:// in front of the hyperlinks if needed
  • ASAP Utilities Options » New tools in development (English only)
  • By request, the following tools are added:
  • Delete range names with bad cell references (#REF!)
  • Removes all range names with invalid addresses. The utility creates a report that shows which names have been removed.
  • Ungroup all grouped columns in the selected worksheets
  • Ungroup all grouped rows in the selected worksheets
  • Bulk replace: replace multiple values at once
  • You can specify a range with the values to search for and replace, which allows you to do many replacements automatically after each other. The target can be a certain range, your current worksheet, all selected worksheets, or even an entire workbook (that is open in Excel). At this moment the search/replace is done in cell values and hyperlinks. We're working on more items to search/replace in, such as formulas, comments, header/footer, textboxes, etc.
  • We think this tool can be a huge time saver. Please let me know what you think of it and if we're missing something.
  • System:
  • Easily create a lot of folders based on the values in selected cells...
  • Now supports creating subfolders if a cell value contains a value such as "folder\subfolder1\subfolder2".
  • Previously the backslash \ in a cell value was changed to an underscore and then the folder was created. Now the backslash is used to create subfolders.
  • ASAP Utilities Options:
  • Settings, language and contact information
  • Contains a new option: Help improve ASAP Utilities, Allow ASAP Utilities to report anonymous usage statistics. By default this option is turned on.
  • These usage statistics don't include personal information, such as your name, company name or email address. Usage statistics do include the following information from your computer: Windows version and language, Excel version and language, ASAP Utilities version and language, and the id's of the 10 tools used most often.
  • This information helps with the further development of ASAP Utilities and its documentation and translations.
  • General:
  • In the Windows Start menu, two existing options from ASAP Utilities have been renamed to a less technical sentence:
  • "install ASAP Utilities as a default add-in in Excel" has been renamed to:
  • "Add ASAP Utilities to the Excel menu"
  • "uninstall ASAP Utilities as add-in in Excel" has been renamed to:
  • "Remove ASAP Utilities from the Excel menu"
  • Bug fixes:
  • Export » Export selection or active sheet as new file...
  • The option "Copy to clipboard (tab delimited)" always included hidden cells, even if the option "Do not export hidden cells" was checked. This is now fixed.
  • The tab-export options used the TSV (Tab Separated Value) file extension name. The TXT extension is now added too, but tsv is still the default.
  • Columns & Rows » Put together rows or columns from several sheets...
  • Now accepts a column/row address in R1C1 notation too.
  • Sheets » Split the selected range into multiple worksheets...
  • If the data didn't start in column A, then the headers were'nt copied along correctly. This is now corrected.
  • Export » Export worksheets as separate files...
  • The option "As displayed" didn't work in combination with delimited text files. This is now fixed.
  • A few small bug fixes.

New in ASAP Utilities 4.7.1 (Jan 21, 2011)

  • Example workbook for the extra worksheet functions that you get with ASAP Utilities:
  • We have created a example workbook that shows how to get things done, that are normally not possible in Excel, by using the functions that ASAP Utilities adds.
  • Columns & Rows:
  • Conditional row and column select, hide or delete...
  • Improved speed, especially when it comes to deleting rows or columns.
  • Sheets:
  • Protect multiple sheets at once...
  • This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
  • If you unshare the workbook then you can use this utility.
  • Sheets:
  • Unprotect multiple sheets at once...
  • This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
  • If you unshare the workbook then you can use this utility.
  • Favorites & Shortcuts:
  • Organize your favorite tools...
  • New option: Create a list of all shortcuts
  • This allows you to print out a quick reference card/cheat sheet of your favorite tools and the assigned shortcuts that are used by ASAP Utilities.
  • Format:
  • Detect and visualize adjacent data/group changes...
  • You can now specify the number of empty rows to insert in between.
  • NEW: Correct the link to the ASAP Utilities worksheet functions in your workbook
  • via: ASAP Utilities Options » New tools in development (English only)
  • When you use a function from ASAP Utilities in your workbook and the workbook is opened by someone who has install ASAP Utilities in a different folder, then these formulas might give an error (#NAME?) because ASAP Utilities can't be found. If you get such a workbook and you run this utility, it will be corrected.
  • NEW: Change text case (with options)
  • via: ASAP Utilities Options » New tools in development (English only)
  • In addition to the existing change-case tools, this utility allows exceptions, such as certain abbreviations.
  • Text:
  • Convert/recognize dates...
  • The utility now also automatically recognizes time values at the end of the value. It does this automatically if the time is written in any of the following formats hh:mm:ss, h:mm:ss, hh:mm:ss AM/PM or h:mm:ss AM/PM. The utility also recognizes hh:mm:ss.000 and h:mm:ss.000 but in that case the milliseconds are stripped off.
  • Improved installer.
  • A few minor improvements.
  • Bug fixes:
  • =ASAPGETDOMAIN():
  • If you specified to show the protocol too, the utility incorrectly showed https for ftp and ftps. This is now corrected.
  • =ASAPSUMBYFONTCOLOR():
  • If you specified a cell to read the font color from, the function incorrectly used the cell color instead of the font color. This is now corrected.
  • Shortcuts:
  • If you changed the shortcuts used by ASAP Utilities then previously assigned shortcuts weren't released until you restarted Excel. That is now fixed.
  • Select:
  • Select cells based on content, formatting and more...
  • Due to a limitation of Excel's Range.Address method in combination with a method we used you could sometimes get the message "No (new) results were found. Your selection didn't change.", even though the numeric value you searched for was there. This is now fixed.
  • File size Toolbar:
  • via ASAP Utilities Options » Settings, language and contact information...
  • In version 4.6.4 an unfortunate bug was introduced which caused this utility to not work. This is now fixed.

New in ASAP Utilities 4.6.4 (Nov 5, 2010)

  • New features and improvements:
  • Find and run a utility:
  • You can quickly add the tool from within the result window to your Favorites-menu by pressing the + button
  • NEW: Sheets:
  • With this tool you can quickly split your data into multiple sheets. You can do this either by value, for example to create a new sheet for each company, or you can specify the number of rows to create per sheet.
  • NEW: Formulas:
  • This utility replaces the range names used in the formulas on the selected sheets with their cell references. For example if you have a value in cell C10 with the range name 'quantity' and you used a formula such as '=A1*quantity', then this utility will replace that formula with '=A1*C10'.
  • NEW: Information:
  • This will put the path and filename of your current workbook to the clipboard.
  • You can then paste it into another application. This can for example be useful if you're working on a file and want to inform a collegue and tell him/her in an email where he/she can find the file.
  • Web:
  • Clean information that is copied from websites. Now has buttons to quickly check, uncheck or inverse all options. This utility is handy to quickly clean up data in general.
  • Subscript the numbers in chemical equations:
  • This utility will subscript the numbers in chemical notations such as Al(OH)3, AlF6Li3, AlO2, Al(NO3)3, Au2(SeO4)3, Ca(VO4)2, H6TeO6, KAlMg3Si3O12H2, Ca(NO3)2 · 4H2O, etc. It automatically detects which numbers should be subscripted.
  • NEW: Report the formulas used in the worksheets in your workbook:
  • This utility creates a report that lists all the formulas that are used in the worksheets in your workbook.
  • General, Startup-questions:
  • We removed the startup-questions (such as "Do you want to convert all text in the selected cells to UPPERCASE?") from several tools. These tools either don't change your data or settings, or can be easily undone or canceled nowadays.
  • This applies to the following tools:
  • Apply standard format to selected cells
  • Center across selection (without merging)
  • Change not recognized numbers (text?) to numbers
  • Change to lowercase
  • Change to UPPERcase
  • Convert percentages to numbers (e.g. 5% to 5)
  • Copy values to empty cells below filled cells in selection
  • Count and/or color duplicates in selection...
  • Decode all URL and HTML encoded text
  • Delete all borders inside selection
  • Delete leading and trailing spaces
  • Delete leading, trailing and excessive spaces
  • Fill 'between values' linear in selection (horizontal)
  • Fill 'between values' linear in selection (vertical)
  • Flip selected cells
  • Make first character Uppercase, the rest lowercase
  • Make last character subscript
  • Make last character superscript
  • Move minus sign from back to front (e.g. 65- to -65)
  • Place a border around each page
  • Print preview selection
  • Random numbering of cells (without duplicates)
  • Remove all conditional formatting in selection
  • Reverse text in selected cells
  • Select cell in selection where value changes
  • Start Each Word With Uppercase
  • Start first word with Uppercase
  • Unmerge cells in selection
  • Bug fixes:
  • System - Reload all installed add-ins (rebuilds the menu):
  • Didn't reload the shortcuts set for ASAP Utilities and gave an error. This bug was unfortunately introduced in 4.6.3, but it is now fixed.
  • Columns & Rows - Conditional row and column select, hide or delete:
  • Produced an error if there was a cell with an error in your selection and you had chosen the search option "like" and the "case sensitive" option unchecked. This is now fixed.
  • Formulas - Copy formulas without changing their cell references:
  • Fixed the bug in the undo.
  • Objects & Comments - Comment tools:
  • This tool could sometimes cause an error if a sheet contained a large amount of comments. This is now fixed.

New in ASAP Utilities 4.6.3 (Sep 6, 2010)

  • Improved startup error message:
  • ASAP Utilities does not (yet) support the 64-bit edition of Excel 2010. Besides a warning about this during the installation, the program will now also tell you this when you start ASAP Utilities in Excel 2010 64-bit (instead of giving an error message). Just to be clear, ASAP Utilities does work with both 32-bit and 64-bit Windows.

New in ASAP Utilities 4.6.2 (Sep 3, 2010)

  • Export » Export worksheets as separate files:
  • Fixed the bug that caused export files, that were in text-format, to be empty.
  • This bug was unfortunately introduced with version 4.6.1, our apologies for this.

New in ASAP Utilities 4.6.1 (Sep 1, 2010)

  • Functions:
  • In Excel 2003, 2007 and 2010 the ASAP Utilities functions are now listed in their own category, called "ASAP Utilities". Furthermore, in Excel 2010 each of the function-arguments has a description in Excel's functions-wizard too.
  • Web » Clean information that is copied from websites:
  • The AutoFit column width and row height now have an option to specify a maximum width or height. Especially with columns this is very useful because columns that are too wide are hard to read or mess-up the layout.
  • Export » Put selected range as bitmap-image on the clipboard (as on screen):
  • This utility can now also be used to copy charts or other objects to the clipboard. Therefore the utility has been renamed to: Export » Put the selection as bitmap-image on the clipboard (as on screen)
  • Export » Put selected range as image on the clipboard (as on screen):
  • This utility can now also be used to copy charts or other objects to the clipboard. Therefore the utility has been renamed to: Export » Put the selection as image on the clipboard (as on screen)
  • Export » Put selected range as image on the clipboard (as on printer):
  • This utility can now also be used to copy charts or other objects to the clipboard. Therefore the utility has been renamed to: Export » Put the selection as image on the clipboard (as on printer)
  • General:
  • A few small (speed) improvements.
  • Excel 2010 (32 bit edition):
  • Fixed the ASAP Utilities startup error that sometimes occurred. We created a workaround for a bug in Excel 2010 which prevented ASAP Utilities from starting correct. Despite all the suggestions in some cases if you were administrator and installed ASAP Utilities, the program kept being unable to connect to the ASAP Utilities library DLL. Somehow in Excel 2010 this DLL is registered not only in the LOCAL MACHINE part of the registry, as we have specified it to do, but it also included ASAP Utilities in the LOCAL USER part of the registry, which it shouldn't do and which causes ASAP Utilities to sometimes not work correct and give the DLL startup error.
  • Select » Select cells based on content, formatting and more:
  • The option "Number format contains" didn't work (anymore). This is now fixed and it works again. You can use it to select cells based on a (part of a) certain number format string.
  • Columns & Rows » Remove unused empty ending rows/columns:
  • Could sometimes produce an error if your sheet contained a table (Excel 2007/2010: Insert > Table). This is now fixed.
  • Export » Export worksheets as separate files:
  • Produced an error if you had a worksheet which as protected and you were using Excel 2000/2002/XP or 2003. This is now fixed. In version 4.5.9 we updated this utility because cells with more than 255 characters were stripped to the first 255 characters in Excel 2000/2002/XP/2003. However, this gave an error on a protected worksheet.
  • Formulas » Copy formulas without changing their cell references:
  • Now works without errors if the target is in another workbook.
  • Fill » Insert before current value / Fill » Insert after current value:
  • Fixed the bug that prevented you from using the same text in another case, such as first in lower case, and then later in upper case. For example, if you added the text 'text', this setting was remembered. However if you later wanted to add the letter 'TEXT' in uppercase, it didn't work because the autocomplete detected that you already added this text before and due to the fact that this comparison is not case sensitive, you couldn't add the same text in other case. This is now fixed by turning autocomplete off, since we can't make autocomplete case-sensitive. You can still quickly choose a previously entered value by using the arrow keys or dropdown with the mouse.
  • Columns & Rows » Autofit row height (also on merged cells):
  • The utility didn't work when the combined column width of the merged cells was more than 255. We have created a workaround for this so that it doesn't give the error anymore. However in such as case with long text the row height might not be adjusted correct with long cell values. At this moment we don't have a better solution (for what seems to be a very rare situation anyway).
  • General:
  • We changed a small thing in the startup of ASAP Utilities which could lead to a problem (an extra empty workbook) when opening a workbook in/via a program called ProSystem fx Engagement.
  • System » Find and remove external links:
  • Bug fixed. If a formula with a link to another file was on a protected sheet, this utility produced an error and the calculation mode for that sheet was left in manual calculation mode. This is now fixed and the utility will inform you nicely if a link exists (in a formula) on a protected worksheet.
  • Format » The paper saver (split columns):
  • If you used this utility on a workbook with one or more pivot tables and were using Excel 2007 or 2010, then Excel could crash. We have no explanation for this, theoretically that is impossible. However, we now created an alternative code to set the page breaks for these Excel versions and that has solved the problem. Excel 2000, 2002/XP and 2003 didn't have this problem.
  • Export » Export selection or active sheet as new file:
  • Improved exporting the formulas in text format. The utility now also uses the A1 or R1C1 referencing based on your current settings in Excel. A few small bugfixes/improvements.

New in ASAP Utilities 4.6.1 (Sep 1, 2010)

  • Improvements:
  • Functions - In Excel 2003, 2007 and 2010 the ASAP Utilities functions are now listed in their own category, called "ASAP Utilities". Furthermore, in Excel 2010 each of the function-arguments has a description in Excel's functions-wizard too.
  • Web » Clean information that is copied from websites...
  • The AutoFit column width and row height now have an option to specify a maximum width or height. Especially with columns this is very useful because columns that are too wide are hard to read or mess-up the layout.
  • Export » Put selected range as bitmap-image on the clipboard (as on screen)
  • This utility can now also be used to copy charts or other objects to the clipboard.
  • Therefore the utility has been renamed to:
  • Export » Put the selection as bitmap-image on the clipboard (as on screen)
  • Export » Put selected range as image on the clipboard (as on screen)
  • This utility can now also be used to copy charts or other objects to the clipboard.
  • Therefore the utility has been renamed to:
  • Export » Put the selection as image on the clipboard (as on screen)
  • Export » Put selected range as image on the clipboard (as on printer)
  • This utility can now also be used to copy charts or other objects to the clipboard.
  • Therefore the utility has been renamed to:
  • Export » Put the selection as image on the clipboard (as on printer)
  • General - A few small (speed) improvements.
  • Bugs fixed:
  • Fixed the ASAP Utilities startup error that sometimes occurred.
  • We created a workaround for a bug in Excel 2010 which prevented ASAP Utilities from starting correct. Despite all the suggestions in some cases if you were administrator and installed ASAP Utilities, the program kept being unable to connect to the ASAP Utilities library DLL. Somehow in Excel 2010 this DLL is registered not only in the LOCAL MACHINE part of the registry, as we have specified it to do, but it also included ASAP Utilities in the LOCAL USER part of the registry, which it shouldn't do and which causes ASAP Utilities to sometimes not work correct and give the DLL startup error.
  • Select » Select cells based on content, formatting and more...
  • The option "Number format contains" didn't work (anymore).
  • This is now fixed and it works again.
  • You can use it to select cells based on a (part of a) certain number format string.
  • Columns & Rows » Remove unused empty ending rows/columns
  • Could sometimes produce an error if your sheet contained a table (Excel 2007/2010: Insert > Table). This is now fixed.
  • Export » Export worksheets as separate files...
  • Produced an error if you had a worksheet which as protected and you were using Excel 2000/2002/XP or 2003. This is now fixed.
  • In version 4.5.9 we updated this utility because cells with more than 255 characters were stripped to the first 255 characters in Excel 2000/2002/XP/2003. However, this gave an error on a protected worksheet.
  • Formulas » Copy formulas without changing their cell references...
  • Now works without errors if the target is in another workbook.
  • Fill » Insert before current value...
  • Fill » Insert after current value...
  • Fixed the bug that prevented you from using the same text in another case, such as first in lower case, and then later in upper case.
  • For example if you added the text 'text', this setting was remembered. However if you later wanted to add the letter 'TEXT' in uppercase, it didn't work because the autocomplete detected that you already added this text before and due to the fact that this comparison is not case sensitive, you couldn't add the same text in other case. This is now fixed by turning autocomplete off, since we can't make autocomplete case-sensitive. You can still quickly choose a previously entered value by using the arrow keys or dropdown with the mouse.
  • Columns & Rows » Autofit row height (also on merged cells)
  • The utility didn't work when the combined column width of the merged cells was more than 255. We have created a workaround for this so that it doesn't give the error anymore. However in such as case with long text the row height might not be adjusted correct with long cell values. At this moment we don't have a better solution (for what seems to be a very rare situation anyway).
  • General
  • We changed a small thing in the startup of ASAP Utilities which could lead to a problem (an extra empty workbook) when opening a workbook in/via a program called ProSystem fx Engagement.
  • System » Find and remove external links...
  • Bug fixed. If a formula with a link to another file was on a protected sheet, this utility produced an error and the calculation mode for that sheet was left in manual calculation mode. This is now fixed and the utility will inform you nicely if a link exists (in a formula) on a protected worksheet.
  • Format » The paper saver (split columns)...
  • If you used this utility on a workbook with one or more pivot tables and were using Excel 2007 or 2010, then Excel could crash. We have no explanation for this, theoretically that is impossible. However, we now created an alternative code to set the page breaks for these Excel versions and that has solved the problem.
  • Excel 2000, 2002/XP and 2003 didn't have this problem.
  • Export » Export selection or active sheet as new file...
  • Improved exporting the formulas in text format. The utility now also uses the A1 or R1C1 referencing based on your current settings in Excel.
  • A few small bugfixes/improvements.

New in ASAP Utilities 4.6.0 (Jun 8, 2010)

  • Select » Select cells based on content, formatting and more...
  • Export » Export selection or active sheet as new file...
  • ASAP Utilities Options » New tools in development (English only) » Report pivot table(s) information
  • ASAP Utilities Options » New tools in development (English only) » Split data table into multiple worksheets

New in ASAP Utilities 4.5.9 (May 27, 2010)

  • New features and improvements:
  • NEW: Columns & Rows » Drawing paper
  • NEW: System » Save file as... and use the first cell as the suggested filename
  • NEW: Show indented structure of formula in current cell
  • NEW: Copy the path and filename of current workbook to clipboard
  • NEW: Show or hide formatting marks in selected cells
  • Bug fixes:
  • In a non-English version of the pre-release of Excel 2010, the browse-for-folder technique in ASAP Utilities produced an error. This is now fixed.
  • Fill » Create a list of filenames and properties in a folder:
  • Fixed the bug where ASAP Utilities thought incorrect there weren't enough rows available (-2) to report the files.
  • Columns & Rows » Autofit row height (also on merged cells):
  • If you added this tool to your favorites&shortcuts menu and assigned a shortcut to it, then that shortcut didn't work. When you clicked on it in the menu it worked correct but when you used the shortcut for this to you got an error "the macro cannot be found". This is now fixed.
  • Export » Export worksheets as separate files:
  • In Excel 2000, 2002/XP and 2003: If you choose to export the sheets as Excel files, cells with more than 255 characters were truncated to 255 characters. This is now fixed. This problem did not occur in Excel 2007 and 2010.
  • Export » Export worksheets as separate files...
  • In Excel 2000, 2002/XP or 2003: If you choose to export the sheets as Excel files, cells with more than 255 characters were truncated to the first 255 characters. This is now fixed. This problem did not occur in Excel 2007 and 2010.
  • A few small bugfixes/improvements.
  • Fixed the bug that caused that the undo for the following tools sometimes didn't work. This could happen for example if one of the following tools was the first and only tool used from ASAP Utilities and then the undo was performed:
  • Text » Delete all text characters (a-z) in selected cells
  • Import » Insert (delimited) text file...
  • Import » Insert text file separated by space...
  • Import » Insert text file separated by tab...
  • Import » Insert text file separated by comma (csv file)...
  • Import » Insert text file separated by "|" (pipe/bar)...
  • Import » Insert text file separated by "!" (exclamation mark)...
  • Import » Insert text file (with options)...
  • The following tools were updated to better distinguish the large amount of colors that are available starting from Excel version 2007:
  • Format » Copy and apply cell's formatting settings...
  • Sheets » Insert multiple sheets (uses the cell values as sheet names)...
  • Range » Advanced sorting... (left to right)

New in ASAP Utilities 4.5.9 RC6 (Apr 20, 2010)

  • If you choose to autofit/resize all comments, the utility used to use a maximum width of 300 so that you could read the contents without horizontal scrolling. You can now specify your own maximum width. This can be useful if you have a wider screen and when the comment contains many line-breaks.
  • NEW: Copy the path and filename of current workbook to clipboard
  • NEW: Show or hide formatting marks in selected cells.
  • Improved speed. Furthermore, if you have hidden rows at the end of your data, they now remain hidden.
  • The following tools were updated to better distinguish the large amount of colors that are available in Excel sinces version 2007: Format - Copy and apply cell's formatting settings; Sheets - Insert multiple sheets (uses the cell values as sheet names); Range - Advanced sorting... (left to right)
  • Fixed the bug that caused that the undo for the following tools sometimes didn't work.
  • Fixed the bug where ASAP Utilities thought incorrect there weren't enough rows available (-2) to report the files.
  • A few small bugfixes/improvements.

New in ASAP Utilities 4.5.8 (Apr 20, 2010)

  • NEW: Sort each row in selection individually ascending (left to right)
  • NEW: Sort each column in selection individually ascending (top to bottom)
  • In Excel 2007 the amount of colors in the HTML export was limited to Excel's (pre Excel 2007) color palette of 56 colors. This is now corrected.
  • A few small bug fixes.
  • For this utility we used Excel's find/replace command, which is fast, but it drops leading zeros if all that is left is a number, such as for example BP0517.
  • Improved. In specific situations this utility could cause problems when Excel automatically changed the value. For example a cell with a value 230 A1 was changed by Excel to 3:00 AM. Apparently this is a rare situation because this bug was only reported by one person. This is now fixed.
  • NEW: Set the width and height of cells in centimeters or inches

New in ASAP Utilities 4.5.6 (Dec 23, 2009)

  • NEW: French language added
  • All the tools are now also available in the French language (Français).
  • If you have the French language of Excel then ASAP Utilities will now start in French.
  • You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » Settings, language and contact information......
  • Note: Only ASAP Utilities itself it translated at this moment. The setup is still in English and so is our website.
  • Improved undo:
  • Numbers » Spell/write out numbers or amounts (EN, DE, NL)...
  • If you used rupees (Rs, IRs or NRs) the currency would be listed at the front.
  • We now do this for the fully written currency "Rupee" as well.
  • This will also affect the worksheet function =ASAPSPELLNUMBER()
  • For example: =ASAPSPELLNUMBER(2450.25,"EN","TRUE","Rupee","Rupee",,"Paisa","Paisa Only") would produce
  • "Two Thousand Four Hundred Fifty Rupee and Twenty Five Paisa"
  • but wil now produce:
  • "Rupee Two Thousand Four Hundred Fifty and Twenty Five Paisa"
  • Bug fixes:
  • Columns Rows » Remove unused empty ending rows/columns
  • Added a workaround to have it work with some specific files too.
  • Text » Delete number of leading characters...
  • Updated so that leading zeros are preserved when the result is something such as -003.
  • Text » Delete number of ending characters...
  • Updated so that leading zeros are preserved when the result is something such as -003.
  • Text » Delete all after a given number of characters...
  • Updated so that leading zeros are preserved when the result is something such as -003.
  • Range » Advanced sorting...
  • The undo for this tool is working again. Since version 4.5.1 undo didn't work anymore.
  • A few small bugfixes and improvements.

New in ASAP Utilities 4.5.5 (Nov 17, 2009)

  • New/improved:
  • NEW: Spanish language added
  • Information » Fast calculation on selected cells...
  • Sheets » Insert multiple sheets (uses the cell values as sheet names)...
  • Sheets » Create an index page with links to all sheets (clickable)...
  • Columns Rows » Insert multiple empty rows at once...
  • Columns Rows » Insert between empty rows or columns...
  • Four worksheet functions are updated for Excel 2007 and later.
  • Text » Replace accented characters (á, ë, ñ etc.)...
  • Fill » Insert before current value...
  • Fill » Insert after current value...
  • System » Resize the Excel window to standard screen resolutions...
  • NEW: ASAP Utilities Options » New tools in development (experimental, English only)
  • Bug fixes:
  • Columns Rows » Remove unused empty ending rows/columns
  • Sheets » Create an index page with links to all sheets (clickable)...
  • Columns Rows » Insert empty rows or columns in between...
  • Columns Rows » Remove unused empty ending rows/columns
  • Text » Change to UPPERcase
  • Text » Change to lowercase
  • Text » Start first word with Uppercase
  • Make first character Uppercase, the rest lowercase
  • Start Each Word With Uppercase
  • Range » Clear duplicated values in selection (leave one original)
  • Sheets » Insert multiple sheets (uses the cell values as sheet names)...
  • Text » Delete number of ending characters...
  • Text » Delete number of leading characters...
  • Text » Delete all after a given number of characters...
  • Text » Delete leading and trailing spaces
  • Text » Delete leading, trailing and excessive spaces
  • Numbers » Change not recognized numbers (text?) to numbers
  • Columns & Rows » Put together rows or columns from several sheets...
  • Web » Extract hyperlinks...

New in ASAP Utilities 4.5.4 (Sep 2, 2009)

  • New features:
  • German language added
  • All the tools are also available in the German language (Deutsch) now. If you have the German language of Excel, ASAP Utilities will now start in German.
  • You can change the language in the options dialogue: ASAP Utilities » ASAP Utilities Options » Settings, language and contact information...
  • Note: Only ASAP Utilities itself it translated at this moment. The setup is still in English and so is our website.
  • ASAP Utilities Options » Report the estimated time that is saved by ASAP Utilities
  • This tool creates a report in a new workbook with in it the tools you have used. It shows how many times you have used those tools and how much time this has approximately saved you.
  • You can enter your hourly rate to estimate how much money you have saved. (Only completely executed tools are counted.) There is also a link for each of the reported tools to the description on this website.
  • You can also use this report to show friends/colleagues which tools you use the most.
  • Columns & Rows » Autofit row height (also for merged cells)
  • This tool adjusts the rowheight in the selected cells so that you can read or print the entire content of the cells. In addition to the standard functionality in Excel this tool also adjusts the height properly on merged cells (where 'wrap text' is set). (In Excel itself the auto adjusting of the row height often doesn't work properly on merged cells.)
  • Text » Advanced character remove or replace...
  • Character code 1 and 2 are added so these can be removed or replaced now too.
  • Import » Insert Excel file...
  • Besides the standard Excel files, you can now also (depending on your Excel version) insert HTML, XML and ODC files.
  • Import » Merge and/or import multiple files...
  • Besides the standard Excel files, you can now also (depending on your Excel version) insert HTML, XML and ODC files.
  • Select » Select cells based on content, formatting and more...
  • Instead of selection a source cell, you can now also select cells based on the font size by entering a number (the font size) instead of a reference to a cell where the font size is read from.
  • Excel 2010 Protected View
  • ASAP Utilities will now show a friendly message when you try to use one of the tools on a document that is openend in "Protected View" in Excel 2010 (technical preview).
  • Bugs fixed:
  • Text » Advanced character remove or replace...
  • Character code 1 and 2 are added so these can be removed or replaced now too.
  • Text » Delete leading and trailing spaces
  • The utility produced an error on values that were not a formula but that did precede with a = character such as for example ' = 919D'. This is now fixed.
  • Text » Delete leading, trailing and excessive spaces
  • The utility produced an error on values that were not a formula but that did precede with a = character such as for example ' = 919D'. This is now fixed.
  • Fill » Quick numbering of selected cells...
  • The "Increment with" setting was ignored when you choose the option to restart the numbering if a value in a specified column changed. This is now fixed.
  • Select » Select cells based on content, formatting and more...
  • With a few options, such as selecting filled cells, the options to select the entire row or entire column were ignored. Only the found cells were selected, despite of the chosen other option. This is now fixed.
  • Columns & Rows » Remove all empty rows
  • When the sheet contained merged cells, there was a chance that the utility didn't remove all the empty rows. This is now fixed. This was a bug that was new in 4.5.2.
  • Objects & Comments » Delete all objects in selected worksheets
  • When you used this tool in a sheet without any objects, the current selection was deleted. This bug was introduced in version 4.5.3 and is now fixed.
  • Web » Clean information that is copied from websites...
  • When you used this tool with the option "Remove all objects/images" checked, in a sheet without any objects, the current selection was deleted.
  • This bug was introduced in version 4.5.3 and is now fixed.
  • Objects & Comments » Comment tools...
  • The utility will now check upfront if it is needed to unprotect the sheet(s) first.
  • For example prior to Excel 2003 you could resize the comments on a protected sheet. Starting from Excel 2003 that is no longer possible and ASAP utilities will then tell you to unprotect the sheet first.
  • Fill » Fill empty cells in selection...
  • We created a workaround for a situation where the range of empty cells consisted of more then 8192 non-contiguous cells. In such a case all the cells were filled instead of only the empty ones. Fortunately you could then undo the operation. We used to use the SpecialCells method from Excel, because it is fast, but that has the 8192 limit.
  • We have now created a workaround so that it always works as expected.
  • Format » Copy a sheet's page and print settings...
  • When you used this in Excel 2007 and applied the settings to a hidden sheet you got an error. This is now fixed. Previous Excel versions didn't have this problem.
  • Range » Count and/or color duplicates in selection...
  • Produced an error if you had error cells in your selection. This is now fixed by skipping the cells with an error value.
  • Columns & Rows » Remove unused empty ending rows/columns
  • Unfortunately in version 4.5.0 a bug was introduced. When you had a hidden row or column at the end of your data, it was removed even if it wasn't empty.
  • This is now fixed.
  • Range » Fill cells with their formatted value
  • The utility now changes the number format in the selected cells to General after the values have been changed.
  • A few minor updates.

New in ASAP Utilities 4.5.3 (Jun 25, 2009)

  • New features:
  • Excel 2010 (former Excel 14)
  • Text » Advanced character remove or replace
  • Objects & Comments » Delete all objects in selected worksheets
  • Web » Clean information that is copied from websites
  • Select » Select cells based on content, formatting and more
  • Numbers » Change not recognized numbers (text?) to numbers
  • Bugs fixed:
  • Export » Export selection or active sheet as new file
  • Export » Export selection as HTML table to clipboard
  • Sheets » Create an index page with links to all sheets (clickable)
  • Formula » Transpose data with formulas
  • Sheets » Unprotect multiple sheets at once
  • Text » Delete number of leading characters
  • Text » Delete number of ending characters
  • Export » Export selection or active sheet as new file
  • Text » Delete leading and trailing spaces
  • Text » Delete leading, trailing and excessive spaces
  • Excel 2010 Protected View
  • Select » Print selection
  • Excel 2007 menu/ribbon
  • System » Reload all installed add-ins (rebuilds the menu)
  • Fill » Create a list of filenames and properties in a folder
  • Function: =ASAPGETFORMULA(cell)
  • Function: =ASAPGETFORMULAINT(cell)

New in ASAP Utilities 4.5.2 (Jun 25, 2009)

  • Improved:
  • Export » Export selection or active sheet as new file
  • Bugs fixed:
  • Sheets » Create an index page with links to all sheets (clickable)
  • Web » Extract hyperlinks
  • System » Macro/VBA information (beta, English)
  • Columns & Rows » Remove all empty rows
  • Columns & Rows » Remove all empty columns
  • Information » File and selection info
  • Select » Select cells based on content, formatting and more
  • Sheets » Unprotect multiple sheets at once
  • Columns & Rows » Put together rows or columns from several sheets
  • Columns & Rows » Delete all hidden rows and columns
  • Sheets » Hide selected sheets
  • Sheets » Hide selected sheets extra (xlVeryHidden)
  • Formula » Change formulas to their calculated values
  • ASAP Utilities Options » Options and settings for ASAP Utilities

New in ASAP Utilities 4.5.1 (Apr 12, 2009)

  • When you used Excel 2007 with the ribbon minimized you couldn't use ASAP Utilities because of an error (Sorry an error occured in ASAP Utilities. Unable to get the info for this tool (0).)
  • This is now fixed.

New in ASAP Utilities 4.2.10 (Jan 28, 2009)

  • Bugs fixed:
  • Objects & Comments » Select all objects on current worksheet
  • Fill » List filenames in folder...
  • Text » Insert before current value...
  • Text » Insert before after value...

New in ASAP Utilities 4.2.9 (Jan 28, 2009)

  • New:
  • Text » Replace accented characters (á, ë, ñ etc.)...
  • Bugs fixed:
  • Fill » Insert after current value...
  • Fill » Insert current date and time with seconds
  • Fill » Insert current time with seconds
  • Export » Export selection or active sheet as new file...
  • Range » Advanced sorting...

New in ASAP Utilities 4.2.8 (Jan 28, 2009)

  • New/improved:
  • Objects & Comments » Delete all objects on current worksheet
  • ASAP Utilities Options » Start the last used utility again
  • Bugs fixed:
  • Range » Move selected range (only values)...
  • Objects & Comments » Delete all objects on current worksheet
  • Fill » Insert before current value...
  • Web » Convert hyperlinks to =HYPERLINK() formulas
  • Range » Find / Replace in all sheets...
  • Text » Advanced character removal/replace...
  • Columns & Rows » Conditional row and column select, hide or delete...
  • Range » Advanced sorting...

New in ASAP Utilities 4.2.7 (Sep 4, 2008)

  • This new version fixes a single bug that was introduced in version 4.2.6.