11/11/2015

Microsoft Excel 2016 Tutorial - Show or Hide All Formulas in Worksheets

In Microsoft Excel, you can instantly see all the formulas in a worksheet. For instance, various formulas has been used in this worksheet, and finding each formula individually could be a real headache in larger worksheets. What if you could see all the formulas in your worksheet with just a single keyboard shortcut?

Before I tell you about the keyboard shortcut, let me first clear you about the keys used in this shortcut. You need to press this key along with Control Key, and this key is found below the Escape key, and left to number 1 key, and it is called Acute, or Back Quote. There are other name of this key as well like, grave, grave accent, left quote, open quote, or a push. I will call it Acute.

So, what you need to do is to press Control + Acute key, and in an instant all the formulas on your current worksheet will be visible. You can again toggle back to normal view by pressing the same shortcut which is, Control + Acute Key.

If you are having some kind of problem with formulas, then you can easily figure out by viewing all the formulas at once. You can also toggle between Normal and Formula view by clicking on, Formula menu, and then click Show Formulas, which also displays the same keyboard shortcut in its Tool Tip.

You can also print your worksheet in same form, if you want to sort out things later on a paper. But what you will require in the print out is the row and column headings. To print row and column headings along with formulas, then first switch to formula view, and then click on Page Layout menu, and make a check mark on Print under Headings in Sheet options. It will then easy for you to understand and figure out the problem on a paper as well.

But there is one problem that may occur if you want to take a print out while showing the formulas, and that is, when you turn on Show Formula option, each column size get doubled, and the text could spread to more than one sheet, and you may require to adjust the columns and rows before you actually take the print out.

The easiest method could be, changing the Page Orientation to Landscape, set the Margins to minimum like Narrow, or you can scale down your worksheet to fit into one page, using Scale to Fit options under Page Layout.