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 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!)›

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.

Work with cell ranges in Excel more easily and efficiently. Sort not only by values but also by formatting and other criteria, use advanced find and replace, and take advantage of flexible copy and paste options. You can also handle duplicates, copy or move cells without changing formula references, and list or remove named ranges.

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 29,000+ 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 9

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