Tom’s Tutorials For Excel: Toggling to Show All Formulas or All Values

by Tom Urtis 2 Comments ↓

Tom’s Tutorials For Excel: Toggling to Show All Formulas or All Values

By pressing the Ctrl+~ keys on your keyboard, you can toggle between showing all the worksheet’s formulas or showing only values.

‹ Tom’s Tutorials For Excel: Inserting a Word Document Onto Your Spreadsheet

Tom’s Tutorials For Excel: Calculations Using the F9 Key ›

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Data Science, Excel Expert, Excel Guru, Formulas Functions, Keyboard Mouse, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tips and Tricks, Tom Urtis

2 comments on “Tom’s Tutorials For Excel: Toggling to Show All Formulas or All Values”

1. Roger Bertrand says:

   November 27, 2013 at 2:05 pm

   Must be fine on an ENGLISH KB… what´s the shortcut key for a SPANIS or LATAM KB?

   Reply
   • Tom Urtis says:

     November 27, 2013 at 7:52 pm

     Hi Roger, try Alt + 4 and see if that does it for you. Thanks to Microsoft MVP John McGhie for the answer.

     Reply