How to show Excel formulas to print

Formulas or functions in Excel are the basic knowledge that we can solve the content of statistics or calculations in Excel. Therefore, when learning Excel, you will need to understand how to apply that Excel formula and function. Usually in the Excel table will only show the results, unless you click the new formula, the function executes. However, some people just need Excel formulas to learn without results or to print, without hiding Excel formulas. So how to show only Excel formulas?

Method 1: Show Excel formulas with Formulas

Open the Excel file and click on the sheet where you want to show all the used Excel formulas. Then click Formulas tab on the toolbar.

Then look down at the options below, click on Show Formulas at the group Formula Auditing.

Immediately all formulas used in the Excel table will display fully as shown below. To display the results again, click Show Formulas again.

Method 2: How to show Excel formulas using Settings

At the interface in Excel, click File and select More> Options. For Excel 2007, click on the Office icon and select Excel Option.

Next, the user clicks Advanced section then look for it item Display options for this worksheet. Continue to tick Show formulas in cells instead of their calculated results.

Formula results in Excel are displayed instead of the results. If you want to show the results again, just click Show Formulas.

Method 3: Use keyboard shortcuts to show Excel formulas

Pressing the key combination is very simple, you press Ctrl + ` (the `sign to the left of the number 1 on the keyboard) to show all formulas in the working sheet in Excel is done.