MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Show Formulas

August 11, 2017 - by Bill Jelen

Excel Shortcuts - Show Formulas

Sure, you can see one formula at a time by selecting the cell and looking in the formula bar. But what if you want to see every formula at once? Bring on Show Formulas mode.

Many folks in the United States think this is Ctrl + ~, but it is actually the grave accent to toggle into and out of Show Formulas mode.

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode 2129
  • control in the Grove accent to see all
  • formulas
  • alright so someone sent in this sentence
  • of spreadsheet we need to figure out how
  • the spreadsheet is working a fast way to
  • see all formulas there's a key on the US
  • keyboard just underneath the Escape key
  • it has the tilde from Spanish and the
  • backwards accent the accident aigoo from
  • French if you hold down ctrl and that
  • key it will go into show formulas mode
  • right in and show formulas mode each
  • column gets a little bit wider and you
  • get to see the formula and look at this
  • someone plug this formula looks like
  • they weren't earning the bonus and so
  • they change the needed for bonus that
  • would have been hard to see in this mode
  • and so toggle by the way so you press
  • that same key control Grob accident to
  • go back and then control Grob accent to
  • see the formulas we're here look at that
  • here we have a series of numbers in
  • there totaling at the bottom they didn't
  • total the sum function they tell them
  • just who knows what the calculator or
  • with a quick sum or maybe they added it
  • up in their heads as and so you'll
  • discover those kinds of things using
  • control and the krav accident one of my
  • favorite keyboard shortcuts thanks for
  • stopping by will see you next time for
  • another net cast from MrExcel

Title Photo: geralt / Pixabay

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.