ASAP Utilities Options » New tools in development (English only)The following tools are added by request:. Change conditional formatting to static formattingThis tool will change the conditional formatting in selected cells to static formatting.It verifies the formatting that has been applied via conditional formatting (font, color and borders) and then apply that as standard formatting.Settings of font, color and borders will be applied. Data Bars and Icon Sets cannot be made static with this tool.This tool only works with Excel 2000, 2000/XP, 2003 and 2010 (Excel 2007 is not supported).Don't hesitate to experiment with this tool, it has and undo.A practical example on when this can be useful: 'We work a lot with conditional formatting (in Excel 2003), but our client wants us to “freeze” the format (Yes, that means no more “conditional”...) in order to have a classical Excel format (mainly cell and font colours).The idea is to do the same thing as we do with formulas or calculations "copy/paste in value" but for conditional formatting.'

ASAP Utilities Options » New tools in development (English only)The following tools are added by request:. Add cell's value or formula to commentAdd the value formula as comment. You can choose replace existing comments or add the value at the beginning of the end of an existing comment.You can also specify to read the value of a cell to the left or right and use that value or formula as comment.Don't hesitate to experiment with this tool, it has an undo.. Insert an apostrophe (') in front of each formula in your selection

ASAP Utilities Options » New tools in development (English only). Change julian dates to normal dates in selected cellsThis tool has been updated so that besides the yyddd and yyyyddd now the JD Edwards (AS/400) cyyddd format is also supported. Their system adds a 0 or 1 in front of the year representing the century (0 = 1900, 1 = 2000, Jan 15, 1910 is 010015, Jan 15, 2010 is 110015).

Columns & Rows » Delete all hidden rows and columnsThis utility used to delete all hidden rows and columns together.You can now choose to either delete all hidden rows, all hidden columns or both.Between brackets the tool shows how many rows and columns are hidden on your worksheet:

Export » Export worksheets as separate files...Has a new option to choose; "Do not export hidden cells", just like the utility"Export selection or active sheet as new file..."We also added the Excel Binary7 Workbook-format (xlsb) if you have Excel 2007 or newer:

GeneralA few small improvements

Bug fixes

ASAP Utilities » Columns & Rows » Drawing paperWith French regional settings in Windows this tool gave an error. This is now fixed.In Excel 2007 and 2010 when you had selected the entire sheet and started this utility it raised an error. That is now fixed.

Sheets » Freeze panes on multiple sheets at onceWhen you have only selected one single sheet, ASAP Utilities selects them all for you, but that gives an error if you have any hidden sheets in your workbook. This is now fixed by automatically selecting only the visible sheets.

Web » Activate hyperlinks (create from cell values)...In version 4.7.2 we have updated this tool so that it automatically adds http:// in front of hyperlinks if needed. However if you link to a file and the link doesn't start with a drive or folder letter, it is treated by the tool as an internet hyperlink and http:// is automatically placed in front of it.We've have now updated the tool by using a better detection for internet hyperlinks.

Select » Select cells based on content, formatting and more..."When using "Select cells based on content, formatting and more..." and finding no cells matching the search criteria, I expect no cells to be selected.But in fact all cells from A1 to End-of-Sheet are selected!"If you have a single cell selected and then start the utility, the tool then assumes that you want to search in the entire workbook and pre-selects that. However, if no matching cells are found the entire sheet was still selected. This is now fixed.

Sheets » Split the selected range into multiple worksheets...Fixed the following bug:"When I use the tool Sheets->Split the selected range into multiple worksheets to split selection by number of rows (option: For every so many rows) and my selection doesn’t start in the first row of the sheet there is an error:The first newly created worksheet doesn’t contain the first couple of selected rows (depending on how far the selection is from the top of the sheet).For example, if I want to split range A3:A12 (10 rows) into two sheets with 5 rows each, the first two rows are lost."

UndoFixed two bugs that we found (but so far have never been reported).Improved reliability for the undo when your worksheet/selection was filtered.If the worksheet contained an autofilter and frozen panes then the freeze pane settings could become altered in some cases due to an Excel bug. This is now fixed.