The Complete Tool Catalog

The ASAP Utilities Tab with its 300+ tools in Excel:

Excel with ASAP Utilities
1.

My Tools & Shortcuts

32 tools

Quickly find and use your favorite tools in ASAP Utilities. This customizable menu comes with a...

Show tools Hide tools
  1. Select Adjacent Matching Cells in the Column
  2. Reload Installed Excel Add-ins (Refresh Menus and Commands)
  3. Color Every nth Row or Column in Selection...
  4. Deselect Cells...
  5. Set Temporary Default File Location to Current Folder
  6. List File Names and Properties from Folder...
  7. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
  8. Advanced Find and Replace...
  9. Apply Calculation to Selected Cells...
  10. Start the Last Used Tool Again...
  11. Extend Selection to the Rightmost Used Column
  12. Extend Selection to the Lowest Used Row
  13. Move, Extend, or Shrink Range Selections...
  14. Quickly Insert a Named Worksheet...
  15. Advanced Criteria-Based Cell Selection...
  16. Convert Formulas in Selection to Static Values
  17. Auto Numbering and Labeling of Selected Cells...
  18. Reset Last Cell to Fix Ctrl+End Behavior...
  19. Save File and Create Backup Copy with Timestamp...
  20. View & Navigation...
  21. Cut and Paste as Values (Keeping Dependents Unchanged)...
  22. Paste Special with Combined Options...
  23. Insert Current Date and Time with Seconds
  24. Insert Current Time with Seconds
  25. Insert Date Using a Calendar Popup...
  26. Clean Up Data and Formatting...
  27. Count Duplicate Values in Selection (Optional Coloring)...
  28. Change to UPPERCASE
  29. Remove Leading and Trailing Spaces
  30. Convert Numbers Stored as Text to Real Numbers
  31. Find and Run a Tool...
  32. Manage My Tools & Shortcuts...
View category page →
2.

View & Navigation...

Quickly navigate between your workbooks and worksheets and adjust their display settings. Any changes you...

View details
3.

Select

20 tools

Quickly select cells, ranges, rows, columns, sheets, or objects based on content, formatting, structure, or...

Show tools Hide tools
  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. Switch Back to Previous Sheet
  16. Select All Sheets
  17. Select All Objects
  18. Print Preview Selection
  19. Print Selection
  20. Apply Current Range Selection to All Worksheets
View category page →
4.

Sheets

28 tools

Manage your Excel sheets quickly and efficiently. Insert, rename, sort, split, export, hide, unhide, protect...

Show tools Hide tools
  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. Switch Back to Previous Sheet
  8. Sort All Sheets...
  9. Create an Index Page (TOC) with Clickable Links to All Sheets...
  10. Split Selected Range into Worksheets Based on Column Value or Row Count...
  11. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
  12. Remove All Empty Worksheets
  13. Unhide All Sheets at Once
  14. Hide Selected Sheets
  15. Hide Selected Sheets as xlVeryHidden
  16. Protect Multiple Sheets at Once...
  17. Unprotect Multiple Sheets at Once...
  18. Print Multiple Sheets at Once...
  19. Copy Page Setup and Print Settings to Other Sheets...
  20. Set Print Area on Selected Sheets
  21. Clear Print Area on Selected Sheets
  22. Reset All Page Breaks on Selected Sheets
  23. Freeze Panes on Multiple Sheets at Once
  24. Unfreeze Panes on Multiple Sheets at Once
  25. Copy and Stack Rows or Columns from Multiple Sheets...
  26. Remove Unused Styles from All Worksheets
  27. Delete and Reset Empty Ending Rows and Columns on Selected Sheets
  28. Reset Last Cell to Fix Ctrl+End Behavior...
View category page →
5.

Range

27 tools

Work with cell ranges in Excel more easily and efficiently. Sort not only by values but also by formatting...

Show tools Hide tools
  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 and Table Names 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!)
View category page →
6.

Fill

15 tools

Quickly fill in missing values, add numbers or text, and automatically number cells. You can also generate...

Show tools Hide tools
  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
View category page →
7.

Rows & Columns

21 tools

Quickly manage rows and columns in Excel: select, hide, delete, color, join, reshape, or clean them up. These...

Show tools Hide tools
  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...
View category page →
8.

Objects & Comments

7 tools

Easily manage comments, notes, and objects in your worksheets. Extract the contents of comments and notes...

Show tools Hide tools
  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
View category page →
9.

Format & Layout

24 tools

Clean up unwanted formatting, apply consistent formatting, and prepare your sheets for printing or sharing...

Show tools Hide tools
  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
View category page →
10.

Numbers & Dates

17 tools

Clean up and convert numbers and dates in Excel. Fix imported numbers, including numbers stored as text or...

Show tools Hide tools
  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...
  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...
View category page →
11.

Text

27 tools

Edit and clean up text without using formulas. Change text case, remove extra spaces, accents, or unwanted...

Show tools Hide tools
  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...
  9. Convert Text Dates to Usable Excel Dates...
  10. Remove Leading and Trailing Spaces
  11. Remove Leading, Trailing, and Extra Spaces Between Words
  12. Remove Leading and Trailing Line Breaks
  13. Clean Up Data and Formatting...
  14. Advanced Find and Replace...
  15. Remove or Replace Unwanted Characters...
  16. Remove Accents from Letters (e.g., é → e, ñ → n)...
  17. Remove All Letters (A-Z)
  18. Remove All Numbers (0-9)
  19. Remove Trailing Line Breaks (e.g., Alt+Enter)
  20. Remove First X Characters...
  21. Remove Last X Characters...
  22. Keep Only the First X Characters...
  23. Subscript Numbers in Chemical Formulas
  24. Apply Superscript Formatting to Last Character
  25. Apply Subscript Formatting to Last Character
  26. Reverse Text
  27. Sort Values Inside Each Cell...
View category page →
12.

Formulas

13 tools

Choose from 38 custom ASAP Utilities worksheet functions for tasks such as counting or summing cells by...

Show tools Hide tools
  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
View category page →
13.

Web Data

9 tools

Clean up messy data, decode URLs and encoded text, remove HTML tags, and extract, create, or remove...

Show tools Hide tools
  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
View category page →
14.

Info & List

22 tools

These tools help you analyze selected cells, view detailed workbook and sheet statistics, identify...

Show tools Hide tools
  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 and Table Names 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
View category page →
15.

File & System

25 tools

This category includes tools to create backup copies with dates and times in their names, rename workbooks...

Show tools Hide tools
  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...
View category page →
16.

Import

11 tools

These tools let you bring in data from Excel files, CSV, tab-delimited, pipe-delimited, and other text files...

Show tools Hide tools
  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...
View category page →
17.

Export

10 tools

Easily export your data, charts, or worksheets in the format you need. Save your selection, full sheet, or...

Show tools Hide tools
  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)
View category page →
18.

Start

7 tools

Quickly open useful Windows tools directly from Excel. Open the folder containing your workbook with the file...

Show tools Hide tools
  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)
View category page →
19.

ASAP Utilities Options

17 tools

Change the language, adjust settings, and customize your favorite tools and keyboard shortcuts in...

Show tools Hide tools
  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. Browse All Tool Descriptions...
  10. Open the ASAP Utilities User Guide (English, PDF)
  11. View the Tip of the Day on Our Website
  12. Check for News and Updates on Our Website
  13. Open the FAQ and Support Page on Our Website
  14. Check if a New Version is Available on Our Website
  15. Try Fully Usable Tools in Development (English Only)...
  16. Close and Unload ASAP Utilities from Excel
  17. See How Much Time and Money You've Saved with ASAP Utilities
View category page →
20.

Find and Run a Tool...

Quickly search for and start the tool you need from ASAP Utilities. This tool searches the names and...

View details
21.

Start Last Tool Again

This tool starts the last tool you used from ASAP Utilities again. It lets you quickly repeat the same...

View details
22.

Online FAQ

This tool opens the FAQ and Support page on our website (www.asap-utilities.com) in your default internet...

View details
23.

About...

View information about ASAP Utilities, including your installed version, release date, and our contact...

View details
24.

Tip of the Day

Discover useful tools and features in ASAP Utilities with our Tip of the Day. View today's tip and...

View details

300+

Time-Saving Excel Tools

The tools in ASAP Utilities help you save time and do what Excel alone can't.

10

Languages

Available in 10 languages. It works with all Excel and Windows language versions. Used by clients in over 140 countries.

38

Extra worksheet functions

Easy-to-use functions that extend Excel's capabilities, such as counting or summing cells by fill or font color.

Makes Your Excel Work Easier

Start using it right away and save time on everyday tasks.
Regular updates with new tools and improvements.
Voted Best Microsoft Excel Add-In 2025.

Download See What You Can Do

  • No credit card required

  • Free 90-day trial.