Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
Formulas from row 20 copied into rows 21 and 22
their formulas need to be updated to include
rows 21 and 22. To quickly check which cells you need to update, display the formulas in the Totals row.
Hold down the Ctrl key and press the ~ key; on most keyboards, this key is near the upper-left corner next to
Note that most cells in the Totals row have not changed
key. The Vehicle Loading and Cost sections now display formulas in the cells (see Figure D-31).
Vehicle Loading and Cost sections with formulas displayed in the cells
You must update any Totals cells that do not include the contents of rows 21 and 22. For example, you
need to update the Totals cells H23 through L23 and cell N23. Cell M23 is not really a total; it is a cumulative
ratio formula, so you do not need to update the cell. Use the following formulas to revise the Totals cells:
The updated sections should look like Figure D-32.