This tool inserts an apostrophe (') in front of each formula in your selected cells, turning them into plain text so they no longer calculate.
It's helpful when you want to:
Examples:
This prevents Excel from calculating the result and keeps the formula visible in the cell.
Note:
To convert them back into working formulas without manually removing the apostrophes, use this tool in ASAP Utilities:
Numbers & Dates » Convert Numbers Stored as Text to Real Numbers
Tips:
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional search terms to help you find this tool:
formulas to text, make formula visible, prevent formula from running, formula as plain text, stop formula execution, Excel formula text, convert formula to string, show formula in cell, lock formula display, display formula instead of result, Excel apostrophe trick, disable formula calculation, Excel quote before formula, escape formula Excel
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial