Formulas

ASAP Utilities ›

These tools help you convert formulas to values, copy formulas exactly without changing cell references, and automate edits like changing reference styles or replacing named ranges. You can also list all formulas and use powerful custom functions such as count or sum by cell color.

Starting this tool

Click ›

Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Sort Values Inside Each Cell...

Tip:Alt+P for the previous tool.

Convert Formulas in Selection to Static Values

Tip: Alt+N for the next tool.

Designed by Excel users for Excel users.

Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

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.

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