• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Displaying Formulas

Normally, Excel does not display the formula in a cell. Instead, it displays the result of the calculation. You can view the formula by selecting the cell and looking in the Formula bar. However, if you're trying to review all the formulas in a large worksheet, it would be easier if you could see them all at once (and even print them). If you want to view formulas in a worksheet, follow these steps:

1.
Open the Tools menu and choose Options.

2.
Click the View tab.

3.
In the Window options area of the View tab (near the bottom of the tab), click to select the Formulas check box.

4.
Click OK.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint