How to Show Formulas in Excel:
Learn to Display Cell Formulas In 2 Clicks
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
When you enter a formula into Excel, it disappears and gets replaced by the result of the function.
Which is great. But sometimes you want to look back on the formula to see what it is.
Excel has some built-in tools that can help, though. We’ll take a look at them here, and you’ll never have to struggle to get the details on your formulas again.
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.