Home Screenshots 10 Languages Why use it?

Download Pricing Contact Us

The ASAP Utilities menu in Excel (English)

Download ❯

37 Worksheet Functions

See the 37 new worksheet functions that you get with ASAP Utilities in Excel.

Quickly Save Hours

Simple and practical examples of how ASAP Utilities saves you hours of time in Excel.

List of tools

A description of all tools in 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

User Guide

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

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.

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

	Download Download ASAP Utilities (recommended) License Agreement (EULA) Upgrade to the latest version Version history Compare version changes Alternative download options System requirements Home&Charity Edition required upgrade Buy Order your license(s) Payment Methods Pricing and volume discounts Help with the ordering system \| Shopper FAQ Sales, upgrades and Refunds Policy Do you need a license or is it free? License Agreement (EULA) 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 (July 5th) Reviews Testimonials, feedback from users Press & Media Reviews 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 (July 5th) Press & media reviews RSS Feed Receive our Newsletter Unsubscribe from our Mailing List 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. Get Support: How to Provide Details 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 Extra features for ExcelComplete list of all ASAP Utilities (sub)menu items
	The ASAP Utilities menu in Excel (English) Trustpilot Download ❯ 37 Worksheet Functions See the 37 new worksheet functions that you get with ASAP Utilities in Excel. Quickly Save Hours Simple and practical examples of how ASAP Utilities saves you hours of time in Excel. Today's Tip (July 5th) Today's featured time saving tool. List of tools A description of all tools in 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 ⁄ Русский ⁄ 中文(简体) ⁄ 日本語 My Tools & Shortcuts 1. Manage My Tools & Shortcuts... Display & Navigation... Select 1. Advanced Criteria-Based Cell Selection... 2. Select, Hide, or Delete Rows or Columns Based on Custom Criteria... 3. Move, Extend, or Shrink Range Selections... 4. Deselect Cells... 5. Invert Range Selection... 6. Merge Contiguous Range Selections 7. Select Adjacent Matching Cells Below the Active Cell 8. Select Adjacent Matching Cells in the Column 9. Extend Selection to the Lowest Used Row 10. Extend Selection to the Rightmost Used Column 11. Jump to the First Different Value in a Selection 12. Select Cells Containing the Lowest Value 13. Select Cells Containing the Highest Value 14. Select All Cells Where Formulas Return an Error 15. Select All Sheets 16. Select All Objects 17. Print Preview Selection 18. Print Selection 19. Apply Current Range Selection to All Worksheets Sheets 1. Quickly Insert a Named Worksheet... 2. Insert Multiple Sheets Using Cell Values as Names... 3. Rename Active Sheet... 4. Quickly Rename Multiple Sheets at Once... 5. Rename Selected Sheets Using a Cell's Value 6. Insert Sheet Names Across Selected Sheets 7. Sort All Sheets... 8. Create an Index Page (TOC) with Clickable Links to All Sheets... 9. Split Selected Range into Worksheets Based on Column Value or Row Count... 10. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)... 11. Remove All Empty Worksheets 12. Unhide All Sheets at Once 13. Hide Selected Sheets 14. Hide Selected Sheets as xlVeryHidden 15. Protect Multiple Sheets at Once... 16. Unprotect Multiple Sheets at Once... 17. Print Multiple Sheets at Once... 18. Copy Page Setup and Print Settings to Other Sheets... 19. Set Print Area on Selected Sheets 20. Clear Print Area on Selected Sheets 21. Reset All Page Breaks on Selected Sheets 22. Freeze Panes on Multiple Sheets at Once 23. Unfreeze Panes on Multiple Sheets at Once 24. Copy and Stack Rows or Columns from Multiple Sheets... 25. Remove Unused Styles from All Worksheets 26. Delete and Reset Empty Ending Rows and Columns on Selected Sheets 27. Reset Last Cell to Fix Ctrl+End Behavior... Range 1. Advanced Find and Replace... 2. Advanced Sorting... 3. Sort in Random Order 4. Sort Values Inside Each Cell... 5. Flip Selected Cells 6. Scroll to Selection (Align to Top-Left) 7. Scroll to Selection (Align in Center) 8. Replace Formula Errors with a Custom Message... 9. Paste Special with Combined Options... 10. Paste Values and Formatting 11. Paste Values Without Formatting 12. Copy Visible Cells and Paste to Visible Cells in Target Range... 13. Replace Values with Their Formatted Value 14. Freeze Conditional Formatting as Static Formatting in Selected Cells 15. Copy Formulas Without Changing Their Cell References... 16. Cut and Paste as Values (Keeping Dependents Unchanged)... 17. Copy and Paste Multiple Ranges at Once... 18. Copy and Transpose Without Changing Formula References... 19. Split Selected Range into Worksheets Based on Column Value or Row Count... 20. Clear Duplicate Values in Selection (Keep One Original) 21. Count Duplicate Values in Selection (Optional Coloring)... 22. Highlight Each Set of Duplicates with a Different Color 23. List All Named Ranges in Workbook 24. Replace Named Ranges in Formulas with Cell References 25. Delete All Defined Range Names in Selection 26. Delete All Defined Range Names in Workbook 27. Delete Named Ranges with Invalid Cell References (#REF!) Fill 1. Fill Blank or Empty Cells with a Specific Value... 2. Overwrite Filled Cells with a Specific Value... 3. Fill Blank Cells with Value from Above 4. Add Leading Zeros to Reach Specific Length... 5. Add Text to Beginning and/or End of Selected Cells... 6. Fill Vertical with Linear Trend Series (Columns) 7. Fill Horizontal with Linear Trend Series (Rows) 8. Auto Numbering and Labeling of Selected Cells... 9. Insert Unique Random Numbers 10. Insert Current Date and Time with Seconds 11. Insert Current Time with Seconds 12. Insert Date Using a Calendar Popup... 13. Insert Workbook's File Path and Name in Header, Footer or Cell... 14. List File Names and Properties from Folder... 15. Insert Sheet Names Across Selected Sheets Columns & Rows 1. Select, Hide, or Delete Rows or Columns Based on Custom Criteria... 2. Advanced Sorting... 3. Color Every nth Row or Column in Selection... 4. Insert Visual Breaks Between Groups in a Column... 5. Join Selected Values Horizontally with a Delimiter... 6. Join Selected Values Vertically with a Delimiter... 7. Join Selected Values Vertically with a Line Break Separator 8. Insert Blank Rows or Columns Between Every Row or Column... 9. Insert a Specified Number of Empty Rows at Once... 10. Choose and Unhide Hidden Rows and Columns... 11. Delete All Hidden Rows, Columns, or Both... 12. Delete All Empty Rows 13. Delete All Empty Columns 14. Fix Autofit Row Height with Merged Cells and Hidden Columns 15. Clean Up Data and Formatting... 16. Set Cell Size in Centimeters, Inches, or Pixels... 17. Reshape Single Column into Table Form (Transpose in Steps)... 18. Split Long Dataset to New Sheet for Printing in Fewer Pages... 19. Copy and Stack Rows or Columns from Multiple Sheets... 20. Delete and Reset Empty Ending Rows and Columns on Selected Sheets 21. Reset Last Cell to Fix Ctrl+End Behavior... Objects & Comments 1. Edit, Extract, and Manage Comments and Notes... 2. Add Cell's Value or Formula to Comment... 3. Select All Objects 4. Delete All Objects in Selected Worksheet(s) 5. Delete All Form Buttons in Selected Worksheet(s) 6. Resize Pictures and OLE Objects (% of Original Size)... 7. Remove Border Line from Selected Shapes and Pictures Format & Layout 1. Copy Page Setup and Print Settings to Other Sheets... 2. Insert Workbook's File Path and Name in Header, Footer or Cell... 3. Clear All Headers and Footers in Selected Sheets 4. Insert Visual Breaks Between Groups in a Column... 5. Reshape Single Column into Table Form (Transpose in Steps)... 6. Split Long Dataset to New Sheet for Printing in Fewer Pages... 7. Wrap Text in Selected Cells 8. Unwrap Text in Selected Cells 9. Set Cell Size in Centimeters, Inches, or Pixels... 10. Add a Border Around the Data on Each Printed Page 11. Remove All Inside Borders in Selection 12. Show a Significant Number of Non-Zero Decimals... 13. Subscript Numbers in Chemical Formulas 14. Unmerge Selected Cells 15. Center Horizontally Across Selection Without Merging 16. Clean Up Data and Formatting... 17. Remove Unused Styles from All Worksheets 18. Remove All Data Validation from Selected Cells 19. Remove All Conditional Formatting from Selection 20. Freeze Conditional Formatting as Static Formatting in Selected Cells 21. Count Duplicate Values in Selection (Optional Coloring)... 22. Highlight Each Set of Duplicates with a Different Color 23. Copy and Apply Certain Cell Formatting Settings... 24. Reset Formatting to Normal Style in Selected Cells Numbers & Dates 1. Apply Calculation to Selected Cells... 2. Convert Formulas in Selection to Static Values 3. Convert Numbers Stored as Text to Real Numbers 4. Insert Leading Apostrophe to Store Numbers as Text 5. Replace Values with Their Formatted Value 6. Change Number Signs: Reverse or Make All Positive or Negative... 7. Fix Trailing Minus Sign: e.g., Convert 50- to -50 8. Show a Significant Number of Non-Zero Decimals... 9. Convert Percentages to Numbers (e.g., 5% to 5) 10. Spell Numbers or Amounts in Words (EN, DE, FR, NL)... 11. Permanently Round Numbers Without Using Formulas... 12. Add Leading Zeros to Reach Specific Length... 13. Auto Numbering and Labeling of Selected Cells... 14. Insert Unique Random Numbers 15. Convert Text Dates to Usable Excel Dates... 16. Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates 17. Insert Date Using a Calendar Popup... Text 1. Add Text to Beginning and/or End of Selected Cells... 2. Change to UPPERCASE 3. Change to lowercase 4. Change to Capitalize First Letter Only 5. Change to Capitalize First Letter and Lowercase the Rest 6. Change to Capitalize Each Word (Title Case)... 7. Change Text Case with Multiple Capitalization Options... 8. Spell Numbers or Amounts in Words (EN, DE, FR, NL)... 9. Convert Text Dates to Usable Excel Dates... 10. Remove Leading and Trailing Spaces 11. Remove Leading, Trailing, and Extra Spaces Between Words 12. Clean Up Data and Formatting... 13. Advanced Find and Replace... 14. Remove or Replace Unwanted Characters... 15. Remove Accents from Letters (e.g., � ? e, � ? n)... 16. Remove All Letters (A-Z) 17. Remove All Numbers (0-9) 18. Remove Trailing Line Breaks (e.g., Alt+Enter) 19. Remove First X Characters... 20. Remove Last X Characters... 21. Keep Only the First X Characters... 22. Subscript Numbers in Chemical Formulas 23. Apply Superscript Formatting to Last Character 24. Apply Subscript Formatting to Last Character 25. Reverse Text 26. Sort Values Inside Each Cell... Formulas 1. Convert Formulas in Selection to Static Values 2. Apply Calculation to Selected Cells... 3. Replace Formula Errors with a Custom Message... 4. Copy and Transpose Without Changing Formula References... 5. Copy Formulas Without Changing Their Cell References... 6. Change Formula Reference Style (A1, $A1, A$1, $A$1)... 7. Replace Named Ranges in Formulas with Cell References 8. Reapply CSE (Ctrl+Shift+Enter) Array Formulas 9. Convert Formulas in Selected Cells to Text by Inserting an Apostrophe 10. List All Formulas Used in Workbook 11. Insert US English Formula and Convert to Local Format... 12. Insert Function from the ASAP Utilities Library... 13. Fix Broken Links to ASAP Utilities Worksheet Functions Web Data 1. Clean Up Data and Formatting... 2. Remove All HTML Tags in Selected Cells... 3. Decode URL and HTML Encoded Text in Selected Cells 4. Extract Hyperlink Addresses from Cells and Shapes... 5. Create Hyperlinks from Cell Values... 6. Convert Hyperlinks to =HYPERLINK() Formulas in Selected Sheets 7. Remove All Hyperlinks from Selected Cells 8. Copy Selection as HTML Table (for Web Pages)... 9. Visit our Website for Helpful Tips, Tools, and Resources Info & List 1. Analyze Selected Cells: Count, Sum, and More... 2. Workbook and Selection Details... 3. Copy Full File Path of Workbook to Clipboard 4. Find the Printed Page Number of the Active Cell 5. Count Duplicate Values in Selection (Optional Coloring)... 6. Highlight Each Set of Duplicates with a Different Color 7. Count Distinct Values in Selection 8. Count Characters in Selected Cell... 9. List Document Properties from Workbook (Title, Author, etc.) 10. List All Named Ranges in Workbook 11. List All Sheet Names in Workbook 12. List All Formulas Used in Workbook 13. Create a Visual Map of Cell Types in a New Workbook 14. List File Names and Properties from Folder... 15. Display VBA Selection Type (Range, Chart, Picture, etc.) 16. Count All Worksheets, Chart Sheets, and Macro Sheets 17. Find #REF! Formula Errors (Broken References) 18. Find Columns Showing #### Errors (Too Narrow) 19. Display Screen Resolution and Working Area 20. Display Regional Settings Used by Excel (Separators & Date Format) 21. Create a List of Installed Excel and COM Add-ins 22. List Available Fonts in New Workbook File & System 1. Save File and Create Backup Copy with Timestamp... 2. Open Save As Dialog with First Cell as Suggested File Name... 3. Rename Current File... 4. Reopen Current File Without Saving Changes 5. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)... 6. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)... 7. Find and Remove External References (Data Links) in Formulas... 8. Change Excel's Default Local File Location (Easier with Browse)... 9. Set Temporary Default File Location to Current Folder 10. Show Folder Paths and File Names in Title Bar 11. Display File Name in Title Bar 12. Close and Delete Current File 13. Close All Unchanged Files (Keep Unsaved Files Open) 14. Close Multiple Files at Once... 15. Close All Open Files Without Saving Changes 16. Add Current File to Recent Files List 17. Clear Multiple Files from Recent Files List... 18. Remove All Macros (VBA Code) from Current Workbook 19. Open Workbook's File Location in File Explorer 20. Resize Excel Window to Standard Screen Sizes... 21. Force Save Workbook (Ignore Workbook_BeforeSave Event)... 22. Create a List of Installed Excel and COM Add-ins 23. Reload Installed Excel Add-ins (Refresh Menus and Commands) 24. List File Names and Properties from Folder... 25. Create Folder Structure in a Destination Folder from Cell Values... Import 1. Import Excel File into Workbook... 2. Import Data From Delimited Text File (Custom Options)... 3. Import Data from dBASE (.dbf) File... 4. Import Data From Space-Delimited Text File... 5. Import Data From Tab-Delimited Text File... 6. Import Data from Comma-Delimited (CSV) File... 7. Import Data From Pipe-Delimited (\|) Text File... 8. Import Data from Exclamation-Delimited (!) Text File... 9. Import Data From Text File Using Wizard... 10. Merge and Import Multiple Files (TXT, CSV, Excel, etc.)... 11. List File Names and Properties from Folder... Export 1. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)... 2. Copy Selection as HTML Table (for Web Pages)... 3. Export Selected Chart or Range as Image (PNG, JPG, EMF, etc.)... 4. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)... 5. Copy Selection as Values to Clipboard 6. Copy Sum of Selected Cells to Clipboard 7. Copy Average of Selected Cells to Clipboard 8. Copy Selection as Bitmap Picture (As Shown on Screen) 9. Copy Selection as Picture (As Shown on Screen) 10. Copy Selection as Picture (As Shown When Printed) Start 1. Open Windows Character Map (Special Characters) 2. Open Windows Calculator 3. Open Windows File Explorer 4. Open Workbook's File Location in File Explorer 5. Open Clipboard Viewer 6. Open Windows Notepad 7. Show Random Funny Message (English) ASAP Utilities Options 1. Settings, Language, and Contact Information... 2. Manage My Tools & Shortcuts... 3. Enter License... 4. Buy ASAP Utilities License 5. View Pricing, License Benefits, and Discounts on Our Website 6. Contact Us 7. Start the Last Used Tool Again... 8. Find and Run a Tool... 9. Open the ASAP Utilities User Guide (English, PDF) 10. View the Tip of the Day on Our Website 11. Check for News and Updates on Our Website 12. Open the FAQ and Support Page on Our Website 13. Check if a New Version is Available on Our Website 14. Try Fully Usable Tools in Development (English Only)... 15. Close and Unload ASAP Utilities from Excel 16. See How Much Time and Money You Saved with ASAP Utilities Find and Run a Tool... Start the Last Used Tool Again... About... The ASAP Utilities menu in Excel 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-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands 🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London! For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.