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

, , 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.

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!