Show all the Formulas of a Microsoft Office Excel Worksheet

Provided by Luke Chung, FMS President

Sometimes you need to see all the formulas in a Microsoft Excel worksheet. Rather than using the formula bar to see them individually, Excel offers a keystroke to display them all. Press:

Press: [Ctrl] and [`] (the accent/tilde key)

To toggle views between the Results

The Formulas

Return to Tips & Techniques Page

Additional Resources



Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

View all FMS products for Microsoft Access All Our Microsoft Access Products



Free Product Catalog from FMS