ASAP Utilities for Excel - Range Tools to Save Time in Excel

Range

Excel  › ASAP Utilities › 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!)›

ASAP Utilities  ›  Range
Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

Tools to manage and transform cell ranges. This category includes advanced find and replace, sorting, pasting, handling duplicates, working with named ranges, and more. These tools extend Excel's capabilities and simplify repetitive tasks.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

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.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

Download See What You Can Do

  • No sign-up required.

  • Free 90-day trial