SECTION 1
Lesson 1.1: Using Formulas in Excel

   

 

 

 By default, Excel 2003 will show the results of a formula rather than the formula itself in a cell.

 

  

 

Notice that the formula is visible in the formula bar, but you see only the result, 3235 in the cell (G2) containing the formula. If this worksheet is printed you will see only numerical results in the cells and not formulas.

 

If you wish to print out your formulas, Excel provides a way to display formulas in cells so they will be printed. To do this, choose Tools->Options to display the options dialogue box, and then select the View tab.

 

 

 

 

 

 

Under the Window Options heading, place a checkmark in the box next to the word Formulas. Click OK and formulas will be visible in the cells that contain them.

 

 

 

 

 

Now that the formulas are displayed in the cells, they will be printed out like ordinary data.