F2 puts a formula in edit mode, Esc will exit edit mode
Faster way to see all formulas: Ctrl+`
Press again to toggle back
Faster way to see all formulas: Ctrl+`
Press again to toggle back
Transcript of the video:
Learn Excel form MrExcel podcast, episode 2020 - See All Formulas at One Time!
Click the “i” on the top-right hand corner, you get to the playlist for all the videos in this series, podcasting this entire book!
Welcome back to the MrExcel netcast, I'm Bill Jelen.
Alright, so you've inherited a spreadsheet from someone, you need to see how they're building the formulas.
You could always press F2 to see one formula and then Escape to go back, F2 Escape, F2 Escape, F2 Escape, that's a huge hassle.
Alright, so on your keyboard, if you're in the US, on the left-hand side you have an Escape key underneath that accent key with a ~ and the ` from French accent égout, also known as a grove accent.
Sometimes in Europe, these keys are different keys, it's the grove accent key that matters, press Ctrl+` key, and it will show you all of the formulas in the spreadsheet, see, the columns get a little bit wider.
And we're now in Show Formulas mode and- oh shoot, look at that, someone put a plug number in, it's great, like all these formulas are some other, then that one sticks out like a sore thumb, and we still have RANDBETWEENs.
Just a great way to see all of the formula cells in one single go, alright, and to get out, just Ctrl+`, again, it's a toggle, formulas, numbers, formulas, numbers.
There's also out here on Formulas, there's a Show Formulas button that you can use if you can't remember the Ctrl+’.
This tip and many more in this book, click that “i” in the top-right hand corner, go out and buy the book, I sincerely would appreciate it.
Alright, F2 puts it in Formula Edit mode, Escape will exit the Edit mode, lets you see formulas one of the time.
But a faster way to see them all, Ctrl+`, press again to toggle back.
You know, this book was crowdsource, people send in their favorite tips, Ron Armstrong, Olga K, and Sven Simon, all sending this as their favorite Excel tip, thanks to them.
And thanks to you for stopping by, we'll see you next time for another netcast from MrExcel!
Click the “i” on the top-right hand corner, you get to the playlist for all the videos in this series, podcasting this entire book!
Welcome back to the MrExcel netcast, I'm Bill Jelen.
Alright, so you've inherited a spreadsheet from someone, you need to see how they're building the formulas.
You could always press F2 to see one formula and then Escape to go back, F2 Escape, F2 Escape, F2 Escape, that's a huge hassle.
Alright, so on your keyboard, if you're in the US, on the left-hand side you have an Escape key underneath that accent key with a ~ and the ` from French accent égout, also known as a grove accent.
Sometimes in Europe, these keys are different keys, it's the grove accent key that matters, press Ctrl+` key, and it will show you all of the formulas in the spreadsheet, see, the columns get a little bit wider.
And we're now in Show Formulas mode and- oh shoot, look at that, someone put a plug number in, it's great, like all these formulas are some other, then that one sticks out like a sore thumb, and we still have RANDBETWEENs.
Just a great way to see all of the formula cells in one single go, alright, and to get out, just Ctrl+`, again, it's a toggle, formulas, numbers, formulas, numbers.
There's also out here on Formulas, there's a Show Formulas button that you can use if you can't remember the Ctrl+’.
This tip and many more in this book, click that “i” in the top-right hand corner, go out and buy the book, I sincerely would appreciate it.
Alright, F2 puts it in Formula Edit mode, Escape will exit the Edit mode, lets you see formulas one of the time.
But a faster way to see them all, Ctrl+`, press again to toggle back.
You know, this book was crowdsource, people send in their favorite tips, Ron Armstrong, Olga K, and Sven Simon, all sending this as their favorite Excel tip, thanks to them.
And thanks to you for stopping by, we'll see you next time for another netcast from MrExcel!
