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

Displaying Formulas

Normally, Excel does not display the actual 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 the formulas in a large worksheet, it might be easier if you could see them all at once (or print them). If you want to view formulas in a worksheet, follow these steps:

  1. Open the Toolsmenu and choose Options.

  2. Click the Viewtab.

  3. In the Window Options area, click to select the Formulascheck box.

  4. Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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