|
|
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).
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語
- Vision Control... (2 screenshots)
- Favorites & Shortcut keys (1 screenshot)
- Select ( screenshots)
- Select cells based on content, formatting and more... (7 screenshots)
- Conditional row and column select, hide or delete... (3 screenshots)
- Move or resize selected range... (1 screenshot)
- Deselect cells... (2 screenshots)
- Inverse selection... (1 screenshot)
- Merge selection of selected areas (2 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 (1 screenshot)
- Extend selection to the last used column (1 screenshot)
- Select cell in selection where value changes (1 screenshot)
- Select cells with the smallest number (1 screenshot)
- Select cells with the largest number (1 screenshot)
- Select all cells with an error (1 screenshot)
- Select all sheets in your workbook (1 screenshot)
- Select all objects on current worksheet (1 screenshot)
- Print preview selection ( screenshots)
- Print selection ( screenshots)
- Set current selection to all worksheets (1 screenshot)
- Sheets ( screenshots)
- Add new worksheet (fill in a name)... (1 screenshot)
- Insert multiple sheets (uses the cell values as sheet names)... (1 screenshot)
- Rename current sheet... (1 screenshot)
- Change name of selected sheets to selected cell's value (1 screenshot)
- Insert sheet(s) name in selected cell(s) (1 screenshot)
- Sort all sheets... (1 screenshot)
- Create an index page with links to all sheets (clickable)... (1 screenshot)
- Split the selected range into multiple worksheets... (1 screenshot)
- Export worksheets as separate files... (3 screenshots)
- Remove all empty worksheets ( screenshots)
- Unhide all sheets ( screenshots)
- Hide selected sheets ( screenshots)
- Hide selected sheets extra (xlVeryHidden) ( screenshots)
- Protect multiple sheets at once... (1 screenshot)
- Unprotect multiple sheets at once... (1 screenshot)
- Print multiple sheets at once... (1 screenshot)
- Copy a sheet's page and print settings... (1 screenshot)
- Set print area on selected worksheets (1 screenshot)
- Clear the print area on selected sheets (1 screenshot)
- Remove all page breaks on the selected worksheets (1 screenshot)
- Freeze panes on multiple sheets at once (1 screenshot)
- Unfreeze panes on multiple sheets at once (1 screenshot)
- Put together rows or columns from several sheets... (1 screenshot)
- Remove all unused styles on every sheet ( screenshots)
- Delete unused empty ending rows/columns (2 screenshots)
- Reset Excel's last cell (1 screenshot)
- Range ( screenshots)
- Find and/or replace in all sheets... (2 screenshots)
- Advanced sorting... (1 screenshot)
- Sort the data in random order (1 screenshot)
- Sort values inside each cell in selection... (1 screenshot)
- 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)... (1 screenshot)
- Paste values and formatting ( screenshots)
- Paste values only (1 screenshot)
- Copy selection and paste into only the visible cells... (1 screenshot)
- Fill cells with their formatted value (1 screenshot)
- Replace conditional formatting with static formatting in selection (1 screenshot)
- Copy formulas without changing their cell references... ( screenshots)
- Move selected data (only values)... ( screenshots)
- Copy and paste multiple selected ranges at once ( screenshots)
- Transpose data with formulas... (2 screenshots)
- Split the selected range into multiple worksheets... (1 screenshot)
- Clear duplicated values in selection (leave one original) (2 screenshots)
- Count and/or color duplicates in selection... (2 screenshots)
- Count duplicates and give each set of duplicates its own color (1 screenshot)
- Create a list of all range names in the workbook ( screenshots)
- Replace the range names used in formulas with their cell references (on selected sheets) (2 screenshots)
- Delete all range names in selection ( screenshots)
- Delete all range names in the entire workbook ( screenshots)
- Delete all range names with an invalid cell reference (#REF!) ( screenshots)
- Columns & Rows ( screenshots)
- Conditional row and column select, hide or delete... (3 screenshots)
- Advanced sorting... (1 screenshot)
- Color each n'th row or column in selection... (1 screenshot)
- Detect and visualize adjacent data/group changes... (4 screenshots)
- Merge column data (join cells)... (1 screenshot)
- Merge row data (selected cells)... (1 screenshot)
- Merge row data, separate cells by a line break (1 screenshot)
- Insert empty rows or columns in between... (1 screenshot)
- Insert multiple empty rows at once... (1 screenshot)
- View and manage hidden rows and columns... (1 screenshot)
- Delete all hidden rows and/or columns... (1 screenshot)
- Delete all empty rows (1 screenshot)
- Delete all empty columns ( screenshots)
- Autofit row height (also on merged cells) (1 screenshot)
- Clean data and formatting... (1 screenshot)
- Drawing paper... (2 screenshots)
- Transpose column in multiple steps... (1 screenshot)
- The paper saver (split columns)... (1 screenshot)
- Put together rows or columns from several sheets... (1 screenshot)
- Delete unused empty ending rows/columns (2 screenshots)
- Reset Excel's last cell (1 screenshot)
- Numbers & Dates ( screenshots)
- Apply formula/calculation to selected cells... (2 screenshots)
- Change formulas to their calculated values (2 screenshots)
- Convert unrecognized numbers (text?) to numbers (1 screenshot)
- Change values to text values (adding ' in front) ( screenshots)
- Fill cells with their formatted value (1 screenshot)
- Change negative numbers to positive and vice versa... (1 screenshot)
- Move minus sign from back to front (e.g. 65- to -65) (1 screenshot)
- 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)... (3 screenshots)
- Fill up with leading zeros... (1 screenshot)
- Quick numbering of selected cells... (9 screenshots)
- Random numbering of cells (without duplicates) (1 screenshot)
- Convert/recognize dates... (1 screenshot)
- Change Julian dates to normal dates (1 screenshot)
- Text ( screenshots)
- Insert before and/or after each cell in your selection... (2 screenshots)
- Change to UPPERcase (1 screenshot)
- 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 (1 screenshot)
- Change Case (with options)... (1 screenshot)
- Spell/write out numbers or amounts (EN, DE, NL)... (1 screenshot)
- Convert/recognize dates... (1 screenshot)
- Delete leading and trailing spaces (1 screenshot)
- Delete leading, trailing and excessive spaces (3 screenshots)
- Clean data and formatting... (1 screenshot)
- Advanced character remove or replace... (2 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) (1 screenshot)
- Delete number of leading characters... (1 screenshot)
- Delete number of ending characters... (1 screenshot)
- Delete all after a given number of characters... (1 screenshot)
- Subscript the numbers in Chemical Formulas (1 screenshot)
- Make last character superscript (1 screenshot)
- Make last character subscript (1 screenshot)
- Reverse text in selected cells (1 screenshot)
- Sort values inside each cell in selection... (1 screenshot)
- Formulas ( screenshots)
- Change formulas to their calculated values (2 screenshots)
- Apply formula/calculation to selected cells... (2 screenshots)
- Custom formula error message... (1 screenshot)
- Transpose data with formulas... (2 screenshots)
- Copy formulas without changing their cell references... ( screenshots)
- Change formula reference style (e.g. A1 to $A1 etc.)... (1 screenshot)
- Replace the range names used in formulas with their cell references (on selected sheets) (2 screenshots)
- Rebuild array formulas ( screenshots)
- Insert an apostrophe (') in front of each formula in the selected cells (1 screenshot)
- Report the formulas used in the worksheets in your workbook (1 screenshot)
- Insert "international" formula... (1 screenshot)
- Insert function from the ASAP Utilities library... (3 screenshots)
- Correct the link to the ASAP Utilities worksheet functions (1 screenshot)
- 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... (1 screenshot)
- Insert before and/or after each cell in your selection... (2 screenshots)
- Fill 'between values' linear in selection (vertical) ( screenshots)
- Fill 'between values' linear in selection (horizontal) ( screenshots)
- Quick numbering of selected cells... (9 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) (1 screenshot)
- Format ( screenshots)
- Copy a sheet's page and print settings... (1 screenshot)
- 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... (4 screenshots)
- Transpose column in multiple steps... (1 screenshot)
- The paper saver (split columns)... (1 screenshot)
- Wrap text ( screenshots)
- Unwrap text ( screenshots)
- Drawing paper... (2 screenshots)
- Place a border around each page ( screenshots)
- Delete all borders inside selection ( screenshots)
- Use a significant number of decimals... ( screenshots)
- Subscript the numbers in Chemical Formulas (1 screenshot)
- Unmerge cells in selection ( screenshots)
- Center across selection (without merging) ( screenshots)
- Clean data and formatting... (1 screenshot)
- Remove all unused styles on every sheet ( screenshots)
- Remove all validations in selected cells ( screenshots)
- Remove all conditional formatting in selection ( screenshots)
- Replace conditional formatting with static formatting in selection (1 screenshot)
- Count and/or color duplicates in selection... (2 screenshots)
- Count duplicates and give each set of duplicates its own color (1 screenshot)
- Copy and apply cell's formatting settings... (1 screenshot)
- Apply standard format to selected cells ( screenshots)
- Objects & Comments ( screenshots)
- Comment tools... (1 screenshot)
- Add cell's value or formula to comment... (1 screenshot)
- Select all objects on current worksheet (1 screenshot)
- Delete all objects in selected worksheets (1 screenshot)
- Delete all buttons on selected worksheets (1 screenshot)
- Resize selected images or OLE objects (%)... ( screenshots)
- Remove the border line from selected objects/images ( screenshots)
- Show flowchart toolbars (1 screenshot)
- Web ( screenshots)
- Clean data and formatting... (1 screenshot)
- Remove all HTML tags in the selected cells... (1 screenshot)
- Decode all URL and HTML encoded text (1 screenshot)
- Extract hyperlinks... (1 screenshot)
- Activate hyperlinks (create from cell values)... (1 screenshot)
- Change all hyperlinks to =HYPERLINK() formulas ( screenshots)
- Remove all hyperlinks in selected cells ( screenshots)
- Export selection as HTML table to clipboard... (1 screenshot)
- Visit our website for more Excel tips and tricks ( screenshots)
- File & System ( screenshots)
- Save file and create backup... (1 screenshot)
- Save file as... and use the first cell as the suggested filename (1 screenshot)
- Rename current file... (1 screenshot)
- Reopen current file without saving changes (1 screenshot)
- Export selection or active sheet as new file... (1 screenshot)
- Export worksheets as separate files... (3 screenshots)
- Find and/or remove external links... (1 screenshot)
- 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 (1 screenshot)
- Display file name in titlebar (1 screenshot)
- Close and delete current file (1 screenshot)
- 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)
- Create a list of filenames and properties in a folder... (1 screenshot)
- Easily create a lot of folders based on the values in selected cells... (2 screenshots)
- Information ( screenshots)
- Fast calculation on selected cells... (2 screenshots)
- File and selection info... (1 screenshot)
- Copy the path and filename of current workbook to clipboard (1 screenshot)
- Get the page number of the active cell (1 screenshot)
- Count and/or color duplicates in selection... (2 screenshots)
- Count duplicates and give each set of duplicates its own color (1 screenshot)
- Count the different unique values in selection (1 screenshot)
- Count number of characters in selected cell (1 screenshot)
- Create a list of all built in workbook properties (title, author etc.) (1 screenshot)
- Create a list of all range names in the workbook ( screenshots)
- Create a list of all sheet names ( screenshots)
- Report the formulas used in the worksheets in your workbook (1 screenshot)
- Create a list of all type of cell values ( screenshots)
- Create a list of filenames and properties in a folder... (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)
- Create a list of all add-ins (1 screenshot)
- List all fonts in new workbook (1 screenshot)
- Import ( screenshots)
- Insert Excel file... ( screenshots)
- Insert (delimited) text file... (1 screenshot)
- 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... (1 screenshot)
- Create a list of filenames and properties in a folder... (1 screenshot)
- Export ( screenshots)
- 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... (3 screenshots)
- Copy selection as values to clipboard (2 screenshots)
- Copy sum of selection to clipboard ( screenshots)
- Copy average of selection to clipboard ( screenshots)
- Put the selection as bitmap-image on the clipboard (as on screen) ( screenshots)
- Put the selection as image on the clipboard (as on screen) ( screenshots)
- Put the selection as image on the clipboard (as on printer) ( screenshots)
- Start ( screenshots)
- ASAP Utilities Options ( screenshots)
- Settings, language and contact information... (1 screenshot)
- Edit your favorite tools and shortcut keys... (2 screenshots)
- Start the last used utility again... (2 screenshots)
- Find and run a utility... (2 screenshots)
- Open the ASAP Utilities User Guide (English, PDF)... (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 (1 screenshot)
- (Re) build the ASAP Utilities toolbar (1 screenshot)
- (Re) build the ASAP Utilities Favorites menu toolbar (1 screenshot)
- New tools in development (English only) (7 screenshots)
- Close ASAP Utilities (1 screenshot)
- Show me the time that I saved by using ASAP Utilities (1 screenshot)
- Find and run a utility... (2 screenshots)
- Info... (1 screenshot)
The ASAP Utilities menu in Excel
Excel 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu
Excel 2003, 2002/XP or 2000 with ASAP Utilities in its menu
User Guide
A detailed description of the utilities is also available in the User Guide.
© 1999-2020 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
