How to show formulas in Excel ?
|
Excel
|
7 months ago
|
Excel
7 Steps
Need to quickly inspect the underlying calculations in your Excel spreadsheet? This guide will show you exactly how to display formulas instead of their results, helping you audit, debug, or understand complex worksheets. You'll learn the easiest method: pressing the Ctrl + ` (grave accent) shortcut. Alternatively, discover how to navigate to the Formulas tab on the Ribbon and click the "Show Formulas" button. This essential technique allows you to gain clarity on how your data is being processed, making spreadsheet analysis and troubleshooting much more efficient. It's Wednesday evening here in Japan, a great time to sharpen your Excel skills!
How to show formulas in Excel ?
|
Excel
|
Excel
7 Steps
1
Start the Excel and open the workbook where you want to view formulas.
This is the starting point for accessing your data and formulas.
2
Click on the tab of the worksheet you want to work on.
Each tab represents a different sheet in your workbook, so choose the one containing the formulas you want to see.
3
Press "ctrl + ~" (tilde key).
This keyboard shortcut toggles the view between showing cell values and cell formulas. When you press it, all formulas in the worksheet will be displayed instead of their results.
4
Look through the "Cells" in the worksheet.
You’ll see formulas such as =B3*C3 instead of the calculated values. This allows you to inspect and verify your calculations.
5
Press "ctrl + ~" again.
This will switch the display back to show the calculated results of the formulas, allowing you to return to your regular worksheet view.
6
Click on a "Cell" that contains a formula.
The formula used in that cell will appear in the formula bar at the top of the Excel window. This allows you to edit or examine specific formulas without changing the view of the entire sheet.
7
You’ve successfully displayed formulas in Excel
By following these steps you can show formulas in Excel
