Microsoft Office Tutorials and References
In Depth Information
Using formulas within a table
Figure 160-2: A drop-down list enables you to select a summary formula for a table column.
You can toggle the total row display on and off by choosing Table Tools➜Design➜
Table Style Options➜Total Row. If you turn it off, the summary options you selected
are remembered when you turn it back on.
Using formulas within a table
In many cases, you want to use formulas within a table. For example, in the table shown in Figure
160-1, you might want a column that shows the difference between the actual and projected
amounts for each month. As you’ll see, Excel makes this process very easy:
1. Activate cell E2 and type Difference for the column header.
Excel automatically expands the table for you.
2. Move to cell E3 and type an equal sign to signal the beginning of a formula.
3. Press the left-arrow key to point to the corresponding value in the Actual column.
4. Type a minus sign and then press the left-arrow key twice to point to the corresponding
value in the Projected column.
5. Press Enter to end the formula.
 
Search JabSto ::




Custom Search