Display The Formulas Used In This Worksheet

These options appear about two thirds of the way down. Follow these steps to print formulas in an excel 2010 worksheet.

Excel Shows Formula But Not Result Exceljet

Excel provides a simple way of displaying formulas in the cells in addition to the formula bar.

Display the formulas used in this worksheet. An underlying formula can be used to remove values or display numbers. By default the calculated results will display in cells instead of the formulas in excel. Excel displays the formulas in the worksheet cells.

Click the review tab and then click unprotect sheet. An underlying formula in excel is used in a spreadsheet to do something different than the formula does. Show more show less.

Click the office button in the upper left corner and then click the excel options button in the lower right. Make sure the protect worksheet and contents of locked cells check box is selected and then click ok. How to display formulas in a worksheet in excel mhelp2u.

4 select the show formulas in cells instead of their calculated results check box and then click ok. However you may want to show the formulas in some selected cells only. The above methods covered so far would show all the formulas in a worksheet.

Autoplay when autoplay is enabled. Show formulas that were previously hidden by removing protection. This method is the most cumbersome.

If the unprotect sheet button is unavailable. But it is another way to show formulas. Excel displays the contents of each cell in the worksheet as they normally appear only in the formula bar or when youre editing them in the cell.

If you need to print worksheet with formulas displaying in excel you need to show all formulas in cells instead of the calculated results first and then print it. If you are working on an excel worksheet with a lot of formulas in it it may become difficult to follow and keep track of all your formulas. Show formulas in excel instead of the value in selected cells only.

How to print worksheet with displaying formulas in excel. To display formulas in other sheets and workbooks you will need to repeat the process for each sheet individually. Click to select show formulas in cells instead of their calculated results and click ok.

Click advanced on the left sidebar and scroll down to display options for this worksheet. Click on the show formula option. Whichever of the above methods you use microsoft excel will show all formulas of the current worksheet.

If you want to view the data used in a formulas calculations use any of the above methods to show formulas in cells then. 3 scroll down to the display options for this worksheet section. The above steps would ensure that it prints the formulas and not the values.

Go to file print. On the ribbons formulas tab in the formula auditing group click the show formulas button.