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

One Comment
  1. kofi nsiah ababio permalink

    I am happy of this keyboard shortcat. I need to no all the keys shortcat if it is posible you send to my mail.

    thanks
    kofi

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.

Subscribe to this comment feed via RSS