If you need to audit your spreadsheet or troubleshoot errors, viewing the underlying formulas instead of their calculated results is essential.
Do it with AI insteadUse the keyboard shortcut
Press 'Ctrl' + '`' (the grave accent key, usually located above the Tab key) to instantly toggle formula view.
Use the Ribbon menu
Go to the 'Formulas' tab on the top ribbon.
Toggle the Show Formulas button
In the 'Formula Auditing' group, click the 'Show Formulas' button to enable or disable the view.
Ensure you are using the grave accent key (`) and not the apostrophe key (').