Home Screenshots 10 Languages Why use it?

Download Purchase Contact Us Blog

Find a utility

Search in the descriptions of all tools in ASAP Utilities

List of tools

A description of all tools in ASAP Utilities

Worksheet functions

View the extra worksheet functions that come with ASAP Utilities.

Pricing & Ordering

Buy your license(s) today. It's only USD 49.00 for a single user license, or save up to 86% with volume discounts.

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 / Русский / 中文(简体) / 日本語

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

Excel 2003 with ASAP Utilities in its menu

User Guide

A detailed description of the utilities is also available in the User Guide.

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:

	Home Screenshots 10 Languages Why use it? Download Purchase Contact Us Blog

	Download License Agreement (EULA) Download ASAP Utilities (recommended) Upgrade to the latest version Version history Compare version changes Alternative download options System requirements Upgrade once a year (Home&Student ed.) Buy license Order your license(s) Payment Methods Pricing and volume discounts Sales, upgrades and Refunds Policy When to buy a license, when is it free? License Agreement (EULA) Example of the ordering process + help What is it? What is ASAP Utilities Screenshots of ASAP Utilities The primary goals of ASAP Utilities About the author of ASAP Utilities System requirements Nederlands: Makkelijker werken in Excel Examples of how to use ASAP Utilities Why use it? Top reasons to use ASAP Utilities Examples of how to use ASAP Utilities Features Descriptions of all tools in ASAP Utilities Search within the ASAP Utilities tools Added worksheet functions Fully expanded list of all menu items Some screenshots of ASAP Utilities Examples of how to use ASAP Utilities Testimonials Testimonials, feedback from users Reviews from the press Clients, who uses ASAP Utilities? User Guide Download the User Guide How to install ASAP Utilities Detailed step by step installation How to uninstall ASAP Utilities Examples of how to use ASAP Utilities News Latest news RSS Feed Receive our Newsletter Unsubscribe from our Mailing List Excel tips Excel tips Excel keyboard shortcuts overview Headlines from the best Excel weblogs Links to interesting websites Recommended Excel books Excel version screenshots Support 1. FAQ: Questions and answers 2. Search within our website 3. Version history 4. Bug report guidelines 5. Sitemap 6. Contact us
	Home FeaturesHierarchical list of all ASAP Utilities (sub)menu items
	Trustpilot Find a utility Search in the descriptions of all tools in ASAP Utilities List of tools A description of all tools in ASAP Utilities Worksheet functions View the extra worksheet functions that come with ASAP Utilities. How to examples Examples of how to use ASAP Utilities Download Download ASAP Utilities Pricing & Ordering Buy your license(s) today. It's only USD 49.00 for a single user license, or save up to 86% with volume discounts. 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) Edit your favorite tools and shortcut keys... (2 screenshots) 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) back to top 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) Quickly rename multiple sheets at once... (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) back to top 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) back to top 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) back to top 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, FR, 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) back to top 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, FR, 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) Find and/or replace in all sheets... (2 screenshots) 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) back to top 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) back to top 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) back to top 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) back to top 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) back to top 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) back to top 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... (2 screenshots) 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) back to top 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) back to top 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) back to top Export ( screenshots) Export selection or active sheet as new file... (2 screenshots) 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) back to top Start ( screenshots) Special Characters (1 screenshot) Calculator (1 screenshot) Windows Explorer ( screenshots) Windows Explorer (start in current file's folder) ( screenshots) Clipboard Viewer ( screenshots) Notepad (1 screenshot) Funny (error) messages (English) (3 screenshots) back to top 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) back to top Find and run a utility... (2 screenshots) back to top Info... (1 screenshot) back to top 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 back to top User Guide A detailed description of the utilities is also available in the User Guide.
	Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top © 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:

Trustpilot