Skip to content

Quick Reveal of Formulae

by Lynne on December 11th, 2010

To quickly show all formulas in your Excel spreadsheet

Hold down the CONTROL key on the keyboard and press the grave accent key ( ` ).  This is located to the left of No 1 key on the top left corner of the keyboard and looks like a backwards apostrophe.

Revealing the formulas does not change the spreadsheet, but enables you to check the formulas.

Reveal codes

Repeating this step will return you back to the normal view of your spreadsheet

Comments are closed.