Home Screenshots 10 Languages Why use it?

Download Pricing Contact Us Blog

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Download ❯

Quick Start

48 Practical Tricks to Save Hours in Excel with ASAP Utilities.

Today's Tip (May 23rd)

Today's featured time saving tool.

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.

Complete list of all ASAP Utilities (sub)menu items

This is the fully expanded list of features that ASAP Utilities adds to Excel.
A description of each tool 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 365, 2021, 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.

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

	Home Download Download ASAP Utilities (recommended) License Agreement (EULA) Upgrade to the latest version Version history Compare version changes Alternative download options System requirements Upgrade once a year (Home&Student ed.) Buy Order your license(s) Payment Methods Pricing and volume discounts Help with the ordering system \| Shopper FAQ 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 10 Languages to choose from The primary goals of ASAP Utilities Mission Statement and Company Values About the author of ASAP Utilities System requirements Examples of how to use ASAP Utilities Why use it? Top reasons to use ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Features Descriptions of all tools in ASAP Utilities Added worksheet functions Fully expanded list of all menu items A few example screenshots of ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Today's featured time saving tool (May 23rd) Reviews Testimonials, feedback from users Reviews from the press Clients, who uses ASAP Utilities? User Guide Download the PDF User Guide How to install ASAP Utilities Detailed step by step installation How to uninstall ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities News Latest news Today's featured time saving tool (May 23rd) Reviews from the press RSS Feed Receive our Newsletter Unsubscribe from our Mailing List Latest tips on our blog 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. Version history 3. Bug report guidelines 4. Sitemap 5. Help with the ordering system \| Shopper FAQ 6. Contact us EN-US Descriptions of all tools in ASAP Utilities: 1. English 2. 中文(简体) (Chinese (Simplified)) 3. Deutsch (German) 4. Español (Spanish) 5. Français (French) 6. Italiano (Italian) 7. 日本語 (Japanese) 8. Nederlands (Dutch) 9. Português do Brasil (Portuguese (Brazil)) 10. Русский (Russian)
	Home Features added to ExcelComplete list of all ASAP Utilities (sub)menu items
	The ASAP Utilities menu in Excel (English) Trustpilot Download ❯ Quick Start 48 Practical Tricks to Save Hours in Excel with ASAP Utilities. Today's Tip (May 23rd) Today's featured time saving tool. 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. Complete list of all ASAP Utilities (sub)menu items This is the fully expanded list of features that ASAP Utilities adds to Excel. A description of each tool 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... Favorites & Shortcut keys 1. Edit your favorite tools and shortcut keys... Select 1. Select cells based on content, formatting and more... 2. Conditional row and column select, hide or delete... 3. Move or resize selected range... 4. Deselect cells... 5. Inverse selection... 6. Merge selection of selected areas 7. Select adjacent cells below active cell with the same value 8. Select adjacent cells in column with the same value 9. Extend selection to the last used row 10. Extend selection to the last used column 11. Select cell in selection where value changes 12. Select cells with the smallest number 13. Select cells with the largest number 14. Select all cells with an error 15. Select all sheets in your workbook 16. Select all objects on current worksheet 17. Print preview selection 18. Print selection 19. Set current selection to all worksheets Sheets 1. Add new worksheet (fill in a name)... 2. Insert multiple sheets (uses the cell values as sheet names)... 3. Rename current sheet... 4. Quickly rename multiple sheets at once... 5. Change name of selected sheets to selected cell's value 6. Insert sheet(s) name in selected cell(s) 7. Sort all sheets... 8. Create an index page with links to all sheets (clickable)... 9. Split the selected range into multiple worksheets... 10. Export worksheets as separate files... 11. Remove all empty worksheets 12. Unhide all sheets 13. Hide selected sheets 14. Hide selected sheets extra (xlVeryHidden) 15. Protect multiple sheets at once... 16. Unprotect multiple sheets at once... 17. Print multiple sheets at once... 18. Copy a sheet's page and print settings... 19. Set print area on selected worksheets 20. Clear the print area on selected sheets 21. Remove all page breaks on the selected worksheets 22. Freeze panes on multiple sheets at once 23. Unfreeze panes on multiple sheets at once 24. Put together rows or columns from several sheets... 25. Remove all unused styles on every sheet 26. Delete unused empty ending rows/columns 27. Reset Excel's last cell Range 1. Find and/or replace in all sheets... 2. Advanced sorting... 3. Sort the data in random order 4. Sort values inside each cell in selection... 5. Flip selected cells 6. Move screen (place selection in top-left of screen) 7. Show selection in center of screen 8. Custom formula error message... 9. Paste special (with combinations)... 10. Paste values and formatting 11. Paste values only 12. Copy selection and paste into only the visible cells... 13. Fill cells with their formatted value 14. Replace conditional formatting with static formatting in selection 15. Copy formulas without changing their cell references... 16. Move selected data (only values)... 17. Copy and paste multiple selected ranges at once... 18. Transpose data with formulas... 19. Split the selected range into multiple worksheets... 20. Clear duplicated values in selection (leave one original) 21. Count and/or color duplicates in selection... 22. Count duplicates and give each set of duplicates its own color 23. Create a list of all range names in the workbook 24. Replace the range names used in formulas with their cell references (on selected sheets) 25. Delete all range names in selection 26. Delete all range names in the entire workbook 27. Delete all range names with an invalid cell reference (#REF!) Columns & Rows 1. Conditional row and column select, hide or delete... 2. Advanced sorting... 3. Color each n'th row or column in selection... 4. Detect and visualize adjacent data/group changes... 5. Merge column data (join cells)... 6. Merge row data (selected cells)... 7. Merge row data, separate cells by a line break 8. Insert empty rows or columns in between... 9. Insert multiple empty rows at once... 10. View and manage hidden rows and columns... 11. Delete all hidden rows and/or columns... 12. Delete all empty rows 13. Delete all empty columns 14. Autofit row height (also on merged cells) 15. Clean data and formatting... 16. Drawing paper... 17. Transpose column in multiple steps... 18. The paper saver (split columns)... 19. Put together rows or columns from several sheets... 20. Delete unused empty ending rows/columns 21. Reset Excel's last cell Numbers & Dates 1. Apply formula/calculation to selected cells... 2. Change formulas to their calculated values 3. Convert unrecognized numbers (text?) to numbers 4. Change values to text values (adding ' in front) 5. Fill cells with their formatted value 6. Change negative numbers to positive and vice versa... 7. Move minus sign from back to front (e.g. 65- to -65) 8. Use a significant number of decimals... 9. Convert percentages to numbers (e.g. 5% to 5) 10. Spell/write out numbers or amounts (EN, DE, FR, NL)... 11. Round numbers (not formatting, but changing)... 12. Fill up with leading zeros... 13. Quick numbering of selected cells... 14. Random numbering of cells (without duplicates) 15. Convert/recognize dates... 16. Change Julian dates to normal dates Text 1. Insert before and/or after each cell in your selection... 2. Change to UPPERcase 3. Change to lowercase 4. Start first word with Uppercase 5. Make first character Uppercase, the rest lowercase 6. Start Each Word With Uppercase 7. Change Case (with options)... 8. Spell/write out numbers or amounts (EN, DE, FR, NL)... 9. Convert/recognize dates... 10. Delete leading and trailing spaces 11. Delete leading, trailing and excessive spaces 12. Clean data and formatting... 13. Find and/or replace in all sheets... 14. Advanced character remove or replace... 15. Replace accented characters (á, ë, ñ etc.)... 16. Delete all text characters (a-z) in selected cells 17. Delete all numbers in selection 18. Remove ending carriage return (Alt+Enter) 19. Delete number of leading characters... 20. Delete number of ending characters... 21. Delete all after a given number of characters... 22. Subscript the numbers in Chemical Formulas 23. Make last character superscript 24. Make last character subscript 25. Reverse text in selected cells 26. Sort values inside each cell in selection... Formulas 1. Change formulas to their calculated values 2. Apply formula/calculation to selected cells... 3. Custom formula error message... 4. Transpose data with formulas... 5. Copy formulas without changing their cell references... 6. Change formula reference style (e.g. A1 to $A1 etc.)... 7. Replace the range names used in formulas with their cell references (on selected sheets) 8. Rebuild array formulas 9. Insert an apostrophe (') in front of each formula in the selected cells 10. Report the formulas used in the worksheets in your workbook 11. Insert "international" formula... 12. Insert function from the ASAP Utilities library... 13. Correct the link to the ASAP Utilities worksheet functions Fill 1. Fill empty cells in selection... 2. Overwrite filled cells in selection... 3. Copy values to empty cells below filled cells in selection 4. Fill up with leading zeros... 5. Insert before and/or after each cell in your selection... 6. Fill 'between values' linear in selection (vertical) 7. Fill 'between values' linear in selection (horizontal) 8. Quick numbering of selected cells... 9. Random numbering of cells (without duplicates) 10. Insert current date and time with seconds 11. Insert current time with seconds 12. Insert workbook's path and name in header, footer or cell... 13. Create a list of filenames and properties in a folder... 14. Insert sheet(s) name in selected cell(s) Format 1. Copy a sheet's page and print settings... 2. Insert workbook's path and name in header, footer or cell... 3. Empty all headers and footers 4. Detect and visualize adjacent data/group changes... 5. Transpose column in multiple steps... 6. The paper saver (split columns)... 7. Wrap text 8. Unwrap text 9. Drawing paper... 10. Place a border around each page 11. Delete all borders inside selection 12. Use a significant number of decimals... 13. Subscript the numbers in Chemical Formulas 14. Unmerge cells in selection 15. Center across selection (without merging) 16. Clean data and formatting... 17. Remove all unused styles on every sheet 18. Remove all validations in selected cells 19. Remove all conditional formatting in selection 20. Replace conditional formatting with static formatting in selection 21. Count and/or color duplicates in selection... 22. Count duplicates and give each set of duplicates its own color 23. Copy and apply cell's formatting settings... 24. Apply standard format to selected cells Objects & Comments 1. Comment tools... 2. Add cell's value or formula to comment... 3. Select all objects on current worksheet 4. Delete all objects in selected worksheets 5. Delete all buttons on selected worksheets 6. Resize selected images or OLE objects (%)... 7. Remove the border line from selected objects/images 8. Show flowchart toolbars Web 1. Clean data and formatting... 2. Remove all HTML tags in the selected cells... 3. Decode all URL and HTML encoded text 4. Extract hyperlinks... 5. Activate hyperlinks (create from cell values)... 6. Change all hyperlinks to =HYPERLINK() formulas 7. Remove all hyperlinks in selected cells 8. Export selection as HTML table to clipboard... 9. Visit our website for more Excel tips and tricks File & System 1. Save file and create backup... 2. Save file as... and use the first cell as the suggested filename 3. Rename current file... 4. Reopen current file without saving changes 5. Export selection or active sheet as new file... 6. Export worksheets as separate files... 7. Find and/or remove external links... 8. Change Excel's default file location (browse)... 9. Set default path to current file 10. Display the full path and file name in the titlebar 11. Display file name in titlebar 12. Close and delete current file 13. Close all saved files 14. Close multiple files at once... 15. Close all open files without saving changes 16. Add current file to recent files list 17. Clear recently used files list in the Excel menu 18. Remove all macros (VBA code) from current file 19. Macro/VBA information (beta, English)... 20. Resize the Excel window to standard screen resolutions... 21. Save current file (developers)... 22. Create a list of all add-ins 23. Reload all installed add-ins (rebuilds the menu) 24. Create a list of filenames and properties in a folder... 25. Easily create a lot of folders based on the values in selected cells... Information 1. Fast calculation on selected cells... 2. File and selection info... 3. Copy the path and filename of current workbook to clipboard 4. Get the page number of the active cell 5. Count and/or color duplicates in selection... 6. Count duplicates and give each set of duplicates its own color 7. Count the different unique values in selection 8. Count number of characters in selected cell 9. Create a list of all built in workbook properties (title, author etc.) 10. Create a list of all range names in the workbook 11. Create a list of all sheet names 12. Report the formulas used in the worksheets in your workbook 13. Create a list of all type of cell values 14. Create a list of filenames and properties in a folder... 15. Display selection type 16. Count number of sheets 17. Find bad cell references (#REF!) 18. Find too narrow columns (####) 19. Display your screen resolution 20. Display the country settings of your computer 21. Create a list of all add-ins 22. List all fonts in new workbook Import 1. Insert Excel file... 2. Insert (delimited) text file... 3. Insert dBASE file... 4. Insert text file separated by space... 5. Insert text file separated by tab... 6. Insert text file separated by comma (csv file)... 7. Insert text file separated by "\|" (pipe/bar)... 8. Insert text file separated by "!" (exclamation mark)... 9. Insert text file (with options)... 10. Merge and/or import multiple files... 11. Create a list of filenames and properties in a folder... Export 1. Export selection or active sheet as new file... 2. Export selection as HTML table to clipboard... 3. Export selected chart or range as image (file)... 4. Export worksheets as separate files... 5. Copy selection as values to clipboard 6. Copy sum of selection to clipboard 7. Copy average of selection to clipboard 8. Put the selection as bitmap-image on the clipboard (as on screen) 9. Put the selection as image on the clipboard (as on screen) 10. Put the selection as image on the clipboard (as on printer) Start 1. Special Characters 2. Calculator 3. Windows Explorer 4. Windows Explorer (start in current file's folder) 5. Clipboard Viewer 6. Notepad 7. Funny (error) messages (English) ASAP Utilities Options 1. Settings, language and contact information... 2. Edit your favorite tools and shortcut keys... 3. Start the last used utility again... 4. Find and run a utility... 5. Open the ASAP Utilities User Guide (English, PDF)... 6. Read the latest news on ASAP Utilities 7. Visit the online FAQ: Frequently Asked Questions about ASAP Utilities 8. Check for new version on the ASAP Utilities website 9. (Re) build the ASAP Utilities toolbar 10. (Re) build the ASAP Utilities Favorites menu toolbar 11. New tools in development (English only) 12. Close ASAP Utilities 13. Show me the time that I saved by using ASAP Utilities Find and run a utility... Info... The ASAP Utilities menu in Excel Excel 365, 2021, 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.
	Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us © 1999-2022 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands