Microsoft Office Tutorials and References
In Depth Information
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.
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.
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.