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).- Vision Control... (1 screenshot)
- Favorites & Shortcuts
- Select
- Move or resize selection... (1 screenshot)
- Deselect cells... (1 screenshot)
- Inverse selection... (3 screenshots)
- Merge selected areas (3 screenshots)
- Conditional select cells... (3 screenshots)
- Conditional row and column select, hide or delete... (3 screenshots)
- Select adjacent cells below active cell with the same value (1 screenshot)
- Select adjacent cells in column with the same value (1 screenshot)
- Expand selection to last used row (2 screenshots)
- Expand selection to last used column (2 screenshots)
- Select cell in selection where value changes (1 screenshot)
- Select cell with smallest number (2 screenshots)
- Select cell with largest number (2 screenshots)
- Select all cells with an error (1 screenshot)
- Select all sheets (2 screenshots)
- Print preview selection
- Print selection
- Set current selection to all worksheets
- Sheets
- Add sheet (inputbox will appear for the name)... (2 screenshots)
- Quickly add multiple sheets (with the names defined in selected cells)... (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 all sheets (clickable)... (3 screenshots)
- Print multiple sheets (batch)... (1 screenshot)
- Remove all empty sheets
- Unhide all sheets
- Hide selected sheets
- Hide selected sheets (xlVeryHidden)
- Sort all sheets... (3 screenshots)
- Set print area on selected sheets (3 screenshots)
- Delete print area on selected sheets (3 screenshots)
- Delete all pagebreaks in active sheet
- 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
- Freeze panes on multiple sheets at once
- Unfreeze panes on multiple sheets at once
- Remove unused empty ending rows/columns
- Reset Excel's last cell
- Range
- Find / Replace in all sheets... (1 screenshot)
- Advanced sorting... (1 screenshot)
- Move screen (place selection in top-left of screen)
- Show selection in center of screen
- Custom formula error message... (1 screenshot)
- Paste special (with combinations)... (1 screenshot)
- Paste values and formatting
- Convert cells value to its formatted look
- Copy formulas without changing their cell references...
- Move selected range (only values)...
- Copy multiple selections... (1 screenshot)
- Transpose data with formulas...
- Empty duplicates in selection (2 screenshots)
- Sort random (shuffle)
- Flip selected cells (1 screenshot)
- Delete all range names in selection
- Delete all range names in the entire workbook
- Columns & Rows
- Conditional row and column select, hide or delete... (3 screenshots)
- Color each n'th row or column in selection... (1 screenshot)
- Merge column data (join cells)... (2 screenshots)
- Merge row data (join cells)... (2 screenshots)
- Merge row data separated by a return (join cells) (2 screenshots)
- Insert in-between empty rows or columns... (1 screenshot)
- Insert multiple empty rows at once...
- View and manage hidden rows and columns... (1 screenshot)
- Delete all hidden rows and columns
- Remove all empty rows (2 screenshots)
- Remove all empty columns
- Advanced Transposer... (1 screenshot)
- Put together rows or columns from several sheets... (1 screenshot)
- Numbers
- Apply formula to selected cells... (2 screenshots)
- Convert formulas to their values
- Convert "textnumbers" to numbers (2 screenshots)
- Convert numbers to text (adding ' in front)
- Convert negative numbers to positive and vice versa... (1 screenshot)
- Move "-" from back to front (e.g. "65-" to "-65") (2 screenshots)
- Use a significant number of decimals...
- Convert percentages to numbers
- Spell numbers or amounts (EN, DE, NL)... (1 screenshot)
- Round numbers (not formatting, but changing)... (2 screenshots)
- Use a significant number of decimals...
- Text
- Insert before current value... (1 screenshot)
- Insert after current value... (1 screenshot)
- Convert to UPPERcase (1 screenshot)
- Convert 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
- Convert dates... (1 screenshot)
- Delete leading and trailing spaces
- Delete leading, trailing and excessive spaces (2 screenshots)
- Remove ending carriage return (alt+enter character)
- Delete all text characters in selection (1 screenshot)
- Delete all numbers in selection (1 screenshot)
- Advanced character removal/replace... (1 screenshot)
- Replace accented characters (á, ë, ñ etc.)… (1 screenshot)
- Delete number of leading characters...
- Delete number of ending characters...
- Delete all after n'th character...
- Make last character superscript (1 screenshot)
- Make last character subscript (1 screenshot)
- Reverse text in selected cells (1 screenshot)
- Formula
- Convert formulas to their values
- Apply formula to selected cells... (2 screenshots)
- Custom formula error message... (1 screenshot)
- Transpose data with formulas...
- Copy formulas without changing their cell references...
- Change reference style (e.g. A1 to $A,1 etc.)... (1 screenshot)
- Insert "international-style" formula… (1 screenshot)
- Rebuild array formulas
- Fill
- Fill empty cells in selection...
- Overwrite filled cells in selection...
- 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)
- Fill 'between values' linear in selection (horizontal) (2 screenshots)
- Quick numbering of cells... (1 screenshot)
- 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)
- List filenames in folder... (1 screenshot)
- Insert sheet(s) name in selected cell(s) (2 screenshots)
- Format
- Quick table (autoformat)...
- Detect and visualize adjacent data/group changes (3 screenshots)
- Copy a sheet's page and print settings... (2 screenshots)
- Insert workbook's path and name in header, footer or cell... (1 screenshot)
- Empty all headers and footers
- Advanced Transposer... (1 screenshot)
- Wrap text
- Unwrap text
- The paper saver (split columns)... (1 screenshot)
- Border each page
- Use a significant number of decimals...
- Unmerge cells in selection
- Center across selection (no merging !)
- Delete all borders inside selection
- Remove all unused styles on every sheet
- Remove all conditional formatting in selection
- Delete all validations in selected cells
- Copy and apply cell's formatting settings... (1 screenshot)
- Apply standard format to selected cells
- Objects & Comments
- Web
- Clean Web Imported data... (2 screenshots)
- Extract hyperlinks... (1 screenshot)
- Activate hyperlinks (create from cell values) (2 screenshots)
- Convert hyperlinks to =HYPERLINK() formulas
- Remove all hyperlinks in selected cells
- Decode all URL-encoded data (2 screenshots)
- Export selection as HTML table to clipboard... (1 screenshot)
- Visit the internet for more Excel tips and tricks
- System
- Save file and create backup
- Rename current file...
- Reopen current file without saving changes
- Find and remove external links
- Change default folder (browse)...
- Set default path to current file
- Display full path and filename in titlebar
- Display filename in titlebar
- Close and delete current file
- Close all saved files
- Close multiple files at once… (1 screenshot)
- Close all open files
- Add current file to recent files list
- Clear recent files list in file menu
- Remove all macros/VBA code from current file
- Macro/VBA information (beta)...
- Resize the Excel application... (1 screenshot)
- Save current file (developers)
- Create a list of all add-ins (1 screenshot)
- Reload all installed add-ins (rebuilds the menu)
- Easily create a lot of folders...
- Information
- Fast calculation on selected cells... (1 screenshot)
- File and selection info... (1 screenshot)
- Get active cell's page number (1 screenshot)
- Count and/or color duplicates in selection... (2 screenshots)
- Count unique values in selection
- Count number of characters in selected cell
- List built in document properties (title, author etc.)
- List all range names
- List all sheet names (1 screenshot)
- List filenames in folder... (1 screenshot)
- List data types (1 screenshot)
- Display selection type
- Count number of sheets (1 screenshot)
- Find bad cell references (#REF!)
- Find too narrow columns (####)
- Display video resolution (1 screenshot)
- Display country settings (1 screenshot)
- List all fonts in new workbook (1 screenshot)
- Import
- Insert Excel File...
- Insert (delimited) text file... (1 screenshot)
- Insert dBase file...
- Insert Textfile separated by space...
- Insert Textfile separated by tab...
- Insert Textfile separated by comma (csv file)...
- Insert Textfile separated by "|" (pipe)...
- Insert Textfile separated by "!" (exclamation mark)...
- Insert Textfile (with options)...
- Merge files together in a new file... (1 screenshot)
- List filenames in folder... (1 screenshot)
- Export
- Export selection or active sheet as new file... (1 screenshot)
- Export selection as HTML table to clipboard... (1 screenshot)
- Export selected chart or range as image (file)... (1 screenshot)
- Export worksheets as separate files... (1 screenshot)
- Copy selection as values to clipboard
- Copy sum of selection to clipboard (1 screenshot)
- Copy average of selection to clipboard (1 screenshot)
- Save selected range as bitmap-image on the clipboard (as on screen)
- Save selected range as image on the clipboard (as on screen)
- Save selected range as image on the clipboard (as on printer)
- Launch
- ASAP Utilities Options
- ASAP Utilities options and settings... (4 screenshots)
- Organize your favorite tools... (2 screenshots)
- Start the last used utility again...
- Find your utility (search help)... (1 screenshot)
- Visit ASAP Utilities update information website
- Visit the online FAQ: Frequently Asked Questions about ASAP Utilities
- Check for new version on the ASAP Utilities website
- (Re) build the ASAP Utilities toolbar (1 screenshot)
- (Re) build the ASAP Utilities favorites menu toolbar (1 screenshot)
- Close ASAP Utilities
- User Guide (pdf)... (1 screenshot)
- Info... (1 screenshot)
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-2008 - Bastien Mensink - ASAP Utilities - Excel macro tools - A Must in Every Office BV - The Netherlands 