Microsoft Office Tutorials and References

In Depth Information

**Worksheet calculation**

mixed reference in this case, specifying the absolute column $F but letting the row number

adjust so that we could ill down as well.

Figure 12-26
We replaced the second structured reference with a mixed cell reference to make

filling these formulas work properly.

Note that if we were to select cell H4 in Figure 12-26 and drag the ill handle down, the

formulas in each cell would not appear to adjust at all, yet they would work perfectly. (The

formula in cell H4 appears in Figure 12-23.) This is because explicit intersection, the built-in

behavior of column specifiers, and the functionality of the @ specifier eliminate the need to

adjust row references.

Note

When you drag the ill handle to the right in a cell containing a structured-reference

formula, pressing Ctrl prevents the column specifiers from adjusting as they usually

would and instead copies the formula to the right without adjustment.

Worksheet calculation

When you change the value in any of the cells to which a formula refers, Excel updates the

displayed values of the formula as well. This updating process is called
recalculation
, and it

affects only cells containing references to cells that have changed. By default, Excel

recalculates whenever you make changes to a cell. If a large number of cells must be recalculated,

the word
Calculating
appears in the status bar, along with a percentage-of-progress meter

if the process is going to take a particularly long time. You can interrupt the recalculation

process simply by doing something, such as using commands or making cell entries; Excel

pauses and then resumes the recalculation when you finish.