ASAP Utilities, description of our Excel toolsLanguage:
ASAP Utilities Options » New tools in development (English only)New tools that are currently in development. These tools are available in English because they are still in development.
Bulk replace: replace multiple values at onceYou 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.
Change conditional formatting to static formattingThis tool will change the conditional formatting in selected cells to static formatting.
Settings of font, color and borders will be applied. Data Bars and Icon Sets cannot be made static with this tool.
This specific tool only works with Excel 2000, 2000/XP, 2003 and 2010 (This tool does not work with Excel 2007).
Change text case (with options)In addition to the existing change-case tools, this utility allows exceptions, such as certain abbreviations.
You can change text in selected cells to:
· Optionally choose to start the first letter with uppercase and transfer the rest of the word to lowercase
· You can choose the characters that (in addition to a space) indicate that a new word starts, such as for example ('"[<-
In combination with the above options, you can choose to:
Manage duplicated recordsWith this utility you can easily remove the duplicated records from your sheet.
You can also have it remove records from your sheet that already exist on another sheet, which can for example be useful if you are working with mailing lists.
Put all data from the worksheet into one single columnPut all the data in the columns on your worksheet below each other in column A.
Refresh all external data ranges and PivotTable reportsRefreshes all pivot tables and external data ranges in your entire workbook.
Report pivot table(s) informationCreates a report in a new workbook with information about the pivot tables in your workbook.
The report shows the following information: Sheet, Data Source, Name, DataBodyRange, DataLabelRange, RowRange, ColumnRange, TableRange1, TableRange2, Date last refreshed, Refreshed by, RefreshOnFileOpen, Fields in source, Record in source, Fields shown, SourceType, SourceDataFile, Connection, CommandText.
Show indented structure of formula in current cellThis is useful when you have a nested formula. It shows the indented structure of your formula. This way you can more easily see if the brackets are placed properly. You can also edit the formula.
Show or hide formatting marks in selected cellsWith this tool you can make spaces, tabs and linebreaks visible. This can be useful because sometimes characters such as these mess up your lookup formulas.
The following characters are used to show these characters:
Ľ = space
Č = tab
Â = line breaks
This tool changes your data when you choose "Show" but you can quickly switch back to the original when you choose "Hide". Basically the method is quite simple. It replaces spaces, tabs and line-breaks with a unique character. Then the "Hide" option changes these special characters back to spaces, tabs or linebreaks again.
Unfortunately it is not possible to make it work without changing the values like the hide/show formatting marks in MS Word. However we think that this tool is a useful alternative.
Sort each column in selection individually ascending (top to bottom)
Sort each row in selection individually ascending (left to right)
Subscript the numbers in chemical equationsThis 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.
Transform table into 3 column matrix (reverse pivot table)Transform a table into a 3 column table that you can easily use as a source for for example a pivot table.
Ungroup all grouped columns in the selected worksheets
Ungroup all grouped rows in the selected worksheets
Starting this utilityIn the Excel menu choose: ASAP Utilities » ASAP Utilities Options » New tools in development (English only)
« Return to the list of “ASAP Utilities Options” tools.
Download ASAP Utitilities
Additional keywords for this tool:
formula parser, formatter, visual, ugly, beautifier, auditing
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top