Microsoft Office Tutorials and References
In Depth Information
Using structured references
Using Formula AutoComplete with structured references
As you enter your formulas, the Formula AutoComplete feature is there to help you along
by displaying lists of applicable functions, defined names, and structured reference
specifiers as you type. For example, Figure 12-24 shows a formula being constructed using a
SUM function, along with an AutoComplete drop-down list displaying all defined items that
begin with the opening bracket character (also called a display trigger in AutoComplete
parlance) that you just typed in the formula. Notice that the list includes all the column
specifiers for the table, as well as all the special item specifiers, all of which begin with a
Figure 12-24 Structured reference specifiers appear in the AutoComplete drop-down list if they
are applicable for a formula.
To enter one of the items in the list in the formula, double-click it. The Formula
AutoComplete list will most likely open more than once as you type formulas, offering any and
all options that begin with the entered letters or display triggers. For example, the
AutoComplete list appeared after we typed =S with a list of all the items beginning with that
letter and again after typing the R in Regional13.
For more information, see “Using Formula AutoComplete” earlier in this chapter.
Filling and copying structured references
As a rule, structured references do not adjust like relative cell references when you copy or
ill them—the reference remains the same. The exceptions to this rule occur with column
specifiers when you use the ill handle to copy fully qualified structured references outside
the table structure. For example, in the worksheet shown in Figure 12-25, we dragged the