The ASAP Utilities menu in Excel (English)
“Formulas” tools
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.In the Excel menu choose: ASAP Utilities › Formulas
- Convert Formulas in Selection to Static Values
- Apply Calculation to Selected Cells...
- Replace Formula Errors with a Custom Message...
- Copy and Transpose Without Changing Formula References...
- Copy Formulas Without Changing Their Cell References...
- Change Formula Reference Style (A1, $A1, A$1, $A$1)...
- Replace Named Ranges in Formulas with Cell References
- Reapply CSE (Ctrl+Shift+Enter) Array Formulas
- Convert Formulas in Selected Cells to Text by Inserting an Apostrophe
- List All Formulas Used in Workbook
- Insert US English Formula and Convert to Local Format...
- Insert Function from the ASAP Utilities Library...
- Fix Broken Links to ASAP Utilities Worksheet Functions
Submenu screenshot
ASAP Utilities helps you save time and do what Excel alone cannot.With 300+ tools, our Excel Add-in automates repetitive tasks, increases your productivity, and simplifies complex tasks.
Excel with ASAP Utilities in its menu
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
« Return to the list of tools.
©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.
🏆 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.