MVP #17: How to show all formulas in an Excel sheet

posted by Michael Olafusi , on , No Comments
You've just received an Excel report and you want to see all the formula calculations in the report.
Or
There is a template your company uses and you've been thinking of recreating the template.

 In this post I will show you the magic keyboard shortcut that allows you to see all the formulas in an Excel sheet.

 That turns this 
to this -

The magic key combo is CTRL + ` 
( ` is known as back-tick and is found above the tab key & before the 1 on most keyboards)
Press the keyboard combo to return to normal view.

Michael Olafusi

0 comments:

Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.

Thanks!