Hierarchical list of all ASAP Utilities (sub)menu items
This list gives you a glance at the utilities in ASAP Utilities. They are presented here as you can find them in the menu. A description of each utility including more screenshots is also available in the ASAP Utilities User Guide (PDF).Language:
- Vision Control... (12 screenshots)
- Favorites & Shortcuts ( screenshots)
- Select ( screenshots)
- Move or resize selected range... (3 screenshots)
- Deselect cells... (11 screenshots)
- Inverse selection... (3 screenshots)
- Merge selection of selected areas (3 screenshots)
- Select cells based on content, formatting and more... (13 screenshots)
- Conditional row and column select, hide or delete... (10 screenshots)
- Select adjacent cells below active cell with the same value (1 screenshot)
- Select adjacent cells in column with the same value (1 screenshot)
- Extend selection to the last used row (6 screenshots)
- Extend selection to the last used column (6 screenshots)
- Select cell in selection where value changes (1 screenshot)
- Select cells with the smallest number (2 screenshots)
- Select cells with the largest number (2 screenshots)
- Select all cells with an error (1 screenshot)
- Select all sheets in your workbook (2 screenshots)
- Print preview selection ( screenshots)
- Print selection ( screenshots)
- Set current selection to all worksheets ( screenshots)
- Sheets ( screenshots)
- Add new worksheet (fill in a name)... (2 screenshots)
- Insert multiple sheets (uses the cell values as sheet names)... (2 screenshots)
- Rename current sheet... (1 screenshot)
- Change name of selected sheets to selected cell's value (2 screenshots)
- Insert sheet(s) name in selected cell(s) (2 screenshots)
- Create an index page with links to all sheets (clickable)... (12 screenshots)
- Print multiple sheets at once... (4 screenshots)
- Remove all empty worksheets ( screenshots)
- Unhide all sheets ( screenshots)
- Hide selected sheets ( screenshots)
- Hide selected sheets extra (xlVeryHidden) ( screenshots)
- Sort all sheets... (3 screenshots)
- Set print area on selected worksheets (3 screenshots)
- Clear the print area on selected sheets (3 screenshots)
- Remove all page breaks on the selected worksheets ( screenshots)
- Put together rows or columns from several sheets... (1 screenshot)
- Protect multiple sheets at once... (1 screenshot)
- Unprotect multiple sheets at once... (1 screenshot)
- Remove all unused styles on every sheet ( screenshots)
- Freeze panes on multiple sheets at once ( screenshots)
- Unfreeze panes on multiple sheets at once ( screenshots)
- Remove unused empty ending rows/columns (4 screenshots)
- Reset Excel's last cell (2 screenshots)
- Range ( screenshots)
- Find and/or replace in all sheets... (6 screenshots)
- Advanced sorting... (6 screenshots)
- Sort the data in random order (6 screenshots)
- Flip selected cells (1 screenshot)
- Move screen (place selection in top-left of screen) ( screenshots)
- Show selection in center of screen ( screenshots)
- Custom formula error message... (1 screenshot)
- Paste special (with combinations)... (3 screenshots)
- Paste values and formatting ( screenshots)
- Fill cells with their formatted value (2 screenshots)
- Copy formulas without changing their cell references... ( screenshots)
- Move selected data (only values)... ( screenshots)
- Copy multiple selected ranges... (1 screenshot)
- Transpose data with formulas... ( screenshots)
- Clear duplicated values in selection (leave one original) (2 screenshots)
- Count and/or color duplicates in selection... (2 screenshots)
- Delete all range names in selection ( screenshots)
- Delete all range names in the entire workbook ( screenshots)
- Columns & Rows ( screenshots)
- Conditional row and column select, hide or delete... (10 screenshots)
- Color each n'th row or column in selection... (4 screenshots)
- Merge column data (join cells)... (2 screenshots)
- Merge row data (selected cells)... (2 screenshots)
- Merge row data, separated cells by a line break (2 screenshots)
- Insert empty rows or columns in between... (1 screenshot)
- Insert multiple empty rows at once... ( screenshots)
- View and manage hidden rows and columns... (1 screenshot)
- Delete all hidden rows and columns ( screenshots)
- Remove all empty rows (2 screenshots)
- Remove all empty columns ( screenshots)
- Remove unused empty ending rows/columns (4 screenshots)
- Autofit row height (also on merged cells) ( screenshots)
- Drawing paper (10 screenshots)
- Transpose column in multiple steps... (1 screenshot)
- Put together rows or columns from several sheets... (1 screenshot)
- Numbers ( screenshots)
- Apply formula/calculation to selected cells... (12 screenshots)
- Change formulas to their calculated values (2 screenshots)
- Change not recognized numbers (text?) to numbers (2 screenshots)
- Change values to text values (adding ' in front) ( screenshots)
- Change negative numbers to positive and vice versa... (3 screenshots)
- Move minus sign from back to front (e.g. 65- to -65) (2 screenshots)
- Use a significant number of decimals... ( screenshots)
- Convert percentages to numbers (e.g. 5% to 5) ( screenshots)
- Spell/write out numbers or amounts (EN, DE, NL)... (1 screenshot)
- Round numbers (not formatting, but changing)... (2 screenshots)
- Text ( screenshots)
- Insert before current value... (1 screenshot)
- Insert after current value... (1 screenshot)
- Change to UPPERcase (5 screenshots)
- Change to lowercase (1 screenshot)
- Start first word with Uppercase (1 screenshot)
- Make first character Uppercase, the rest lowercase (1 screenshot)
- Start Each Word With Uppercase ( screenshots)
- Convert/recognize dates... (1 screenshot)
- Delete leading and trailing spaces ( screenshots)
- Delete leading, trailing and excessive spaces (9 screenshots)
- Advanced character remove or replace... (3 screenshots)
- Replace accented characters (á, ë, ñ etc.)... (1 screenshot)
- Delete all text characters (a-z) in selected cells (1 screenshot)
- Delete all numbers in selection (1 screenshot)
- Remove ending carriage return (alt+enter character) ( screenshots)
- Delete number of leading characters... (6 screenshots)
- Delete number of ending characters... ( screenshots)
- Delete all after a given number of characters... ( screenshots)
- Make last character superscript (1 screenshot)
- Make last character subscript (1 screenshot)
- Reverse text in selected cells (1 screenshot)
- Formulas ( screenshots)
- Change formulas to their calculated values (2 screenshots)
- Apply formula/calculation to selected cells... (12 screenshots)
- Custom formula error message... (1 screenshot)
- Transpose data with formulas... ( screenshots)
- Copy formulas without changing their cell references... ( screenshots)
- Change formula reference style (e.g. A1 to $A1 etc.)... (1 screenshot)
- Insert "international" formula... (1 screenshot)
- Insert function from the ASAP Utilities library... (1 screenshot)
- Rebuild array formulas ( screenshots)
- Fill ( screenshots)
- Fill empty cells in selection... ( screenshots)
- Overwrite filled cells in selection... ( screenshots)
- Copy values to empty cells below filled cells in selection (1 screenshot)
- Fill up with leading zeros... (2 screenshots)
- Insert before current value... (1 screenshot)
- Insert after current value... (1 screenshot)
- Fill 'between values' linear in selection (vertical) ( screenshots)
- Fill 'between values' linear in selection (horizontal) (2 screenshots)
- Quick numbering of selected cells... (5 screenshots)
- Random numbering of cells (without duplicates) (1 screenshot)
- Insert current date and time with seconds (1 screenshot)
- Insert current time with seconds (1 screenshot)
- Insert workbook's path and name in header, footer or cell... (1 screenshot)
- Create a list of filenames and properties in a folder... (1 screenshot)
- Insert sheet(s) name in selected cell(s) (2 screenshots)
- Format ( screenshots)
- Copy a sheet's page and print settings... (7 screenshots)
- Insert workbook's path and name in header, footer or cell... (1 screenshot)
- Empty all headers and footers ( screenshots)
- Detect and visualize adjacent data/group changes... (19 screenshots)
- Transpose column in multiple steps... (1 screenshot)
- The paper saver (split columns)... (1 screenshot)
- Wrap text ( screenshots)
- Unwrap text ( screenshots)
- Place a border around each page ( screenshots)
- Use a significant number of decimals... ( screenshots)
- Unmerge cells in selection ( screenshots)
- Center across selection (without merging) ( screenshots)
- Delete all borders inside selection ( screenshots)
- Remove all unused styles on every sheet ( screenshots)
- Remove all conditional formatting in selection ( screenshots)
- Remove all validations in selected cells ( screenshots)
- Copy and apply cell's formatting settings... (1 screenshot)
- Apply standard format to selected cells ( screenshots)
- Objects & Comments ( screenshots)
- Comment tools... (1 screenshot)
- Select all objects on current worksheet (6 screenshots)
- Delete all objects in selected worksheets (6 screenshots)
- Delete all buttons on selected worksheets ( screenshots)
- Resize selected images or OLE objects (%)... ( screenshots)
- Remove the border line from selected objects/images ( screenshots)
- Show flowchart toolbars (1 screenshot)
- Web ( screenshots)
- Clean information that is copied from websites... (2 screenshots)
- Extract hyperlinks... (1 screenshot)
- Activate hyperlinks (create from cell values)... (2 screenshots)
- Change all hyperlinks to =HYPERLINK() formulas ( screenshots)
- Remove all hyperlinks in selected cells ( screenshots)
- Decode all URL and HTML encoded text (2 screenshots)
- Export selection as HTML table to clipboard... (4 screenshots)
- Visit our website for more Excel tips and tricks ( screenshots)
- System ( screenshots)
- Save file and create backup (2 screenshots)
- Save file as... and use the first cell as the suggested filename (5 screenshots)
- Rename current file... ( screenshots)
- Reopen current file without saving changes ( screenshots)
- Find and remove external links... ( screenshots)
- Change Excel's default file location (browse)... ( screenshots)
- Set default path to current file (1 screenshot)
- Display the full path and file name in the titlebar ( screenshots)
- Display file name in titlebar ( screenshots)
- Close and delete current file ( screenshots)
- Close all saved files ( screenshots)
- Close multiple files at once... (1 screenshot)
- Close all open files without saving changes ( screenshots)
- Add current file to recent files list ( screenshots)
- Clear recently used files list in the Excel menu ( screenshots)
- Remove all macros (VBA code) from current file ( screenshots)
- Macro/VBA information (beta, English)... ( screenshots)
- Resize the Excel window to standard screen resolutions... (1 screenshot)
- Save current file (developers) ( screenshots)
- Create a list of all add-ins (1 screenshot)
- Reload all installed add-ins (rebuilds the menu) ( screenshots)
- Easily create a lot of folders based on the values in selected cells... ( screenshots)
- Information ( screenshots)
- Fast calculation on selected cells... (1 screenshot)
- File and selection info... (1 screenshot)
- Get the page number of the active cell (1 screenshot)
- Count and/or color duplicates in selection... (2 screenshots)
- Count the different unique values in selection (4 screenshots)
- Count number of characters in selected cell ( screenshots)
- Create a list of all built in workbook properties (title, author etc.) ( screenshots)
- Create a list all names in the workbook ( screenshots)
- Create a list of all sheet names (1 screenshot)
- Create a list of filenames and properties in a folder... (1 screenshot)
- Create a list of all type of cell values (1 screenshot)
- Display selection type ( screenshots)
- Count number of sheets (1 screenshot)
- Find bad cell references (#REF!) ( screenshots)
- Find too narrow columns (####) ( screenshots)
- Display your screen resolution (1 screenshot)
- Display the country settings of your computer (1 screenshot)
- List all fonts in new workbook (1 screenshot)
- Import ( screenshots)
- Insert Excel file... ( screenshots)
- Insert (delimited) text file... (4 screenshots)
- Insert dBASE file... ( screenshots)
- Insert text file separated by space... ( screenshots)
- Insert text file separated by tab... ( screenshots)
- Insert text file separated by comma (csv file)... ( screenshots)
- Insert text file separated by "|" (pipe/bar)... ( screenshots)
- Insert text file separated by "!" (exclamation mark)... ( screenshots)
- Insert text file (with options)... ( screenshots)
- Merge and/or import multiple files... (3 screenshots)
- Create a list of filenames and properties in a folder... (1 screenshot)
- Export ( screenshots)
- Export selection or active sheet as new file... (6 screenshots)
- Export selection as HTML table to clipboard... (4 screenshots)
- Export selected chart or range as image (file)... (6 screenshots)
- Export worksheets as separate files... (5 screenshots)
- Copy selection as values to clipboard (6 screenshots)
- Copy sum of selection to clipboard (1 screenshot)
- Copy average of selection to clipboard (1 screenshot)
- Put selected range as bitmap-image on the clipboard (as on screen) ( screenshots)
- Put selected range as image on the clipboard (as on screen) ( screenshots)
- Put selected range as image on the clipboard (as on printer) ( screenshots)
- Start ( screenshots)
- ASAP Utilities Options ( screenshots)
- Settings, language and contact information... (29 screenshots)
- Organize your favorite tools... (6 screenshots)
- Start the last used utility again... ( screenshots)
- Find and run a utility... (5 screenshots)
- Open the ASAP Utilities User Guide (English, PDF)... (1 screenshot)
- Report the estimated time that is saved by ASAP Utilities (1 screenshot)
- Read the latest news on ASAP Utilities ( screenshots)
- Visit the online FAQ: Frequently Asked Questions about ASAP Utilities ( screenshots)
- Check for new version on the ASAP Utilities website ( screenshots)
- (Re) build the ASAP Utilities toolbar (1 screenshot)
- (Re) build the ASAP Utilities Favorites menu toolbar (1 screenshot)
- New tools in development (English only) (2 screenshots)
- Close ASAP Utilities (3 screenshots)
- Find and run a utility... (5 screenshots)
- Info... (5 screenshots)
Excel 2007 with ASAP Utilities
Excel 2000, 2002/XP or 2003 with ASAP Utilities
User Guide
A detailed description of the utilities is also available in the User Guide.© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands
Print date: Tuesday September 7th, 2010http://www.asap-utilities.com/asap-utilities-excel-tools-hierarchical-list.php