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

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2129: CONTROL And The Grave Accent To See All Formulas.

Alright. So, someone sent in this 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 ~ from Spanish and the backwards accent, the accent aigu, from French.

If you hold down CONTROL and that key, it will go into show formulas mode, right, and in show formulas mode, each column gets a little bit wider and you get to see the formula, and look at this. Someone plugged this formula, looks like they weren't earning the bonus, and so they changed the NEEDED FOR BONUS. That would have been hard to see in this mode, and so, toggle, by the way. So, you press CONTROL+` to go back, and then CONTROL+` to see the formulas over here.

Look at that. Here we have a series of numbers and they’re totalling at the bottom. They didn't total with the SUM function. They totalled, just who knows, with a calculator or with a quick sum or maybe they added it up in their heads, and so you'll discover those kinds of things using CONTROL and the ` -- one of my favorite keyboard shortcuts.

Thanks for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: geralt / Pixabay

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

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.