The Excel Skinny

A blog about Excel and its users

This is a cool shortcut that can come in handy for any Excel users that have multiple formulas in a spreadsheet.  It’s very simple - all it does is toggles your whole spreadsheet so show either the cell values, or the cell formulas.  This effects the entire spreadsheet so any formula will be toggled back and forth when executing the shortcut. 

This shortcut can be executed from anywhere on the spreadsheet.  To execute simply press: 

⌃`

Once executed your spreadsheet will change from values to formulas, or vice versa.

     to    

Now go have fun toggling back and forth between your formulas and values!