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 .



Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
ISBN: B005HKSHB2
EAN: N/A
Year: 2002
Pages: 660
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net