Toggle formulas on and off

Displays or hides cell formulas instead of their results, making it easier to audit or debug your spreadsheet.

Shortcut Windows Mac
Toggle formulas on and off Ctrl` Ctrl`

Relevant Excel Shortcuts

Discover related Excel keyboard shortcuts in the formula navigation category.

Expand or collapse formula bar
Toggle absolute and relative references
Define name for references
Open Name Manager
Define name using row and column
Paste name into formula
Accept function with autocomplete

Download Your Complete Excel Shortcuts Cheat Sheet

Get instant access to a comprehensive PDF guide of all Excel keyboard shortcuts available on our website. Perfect for quick reference and offline use for both Mac and Windows users. Click below to download your copy and boost your productivity today!

Free PDF
PDF guide of all Excel shortcuts for Windows and Mac