Microsoft Office Tutorials and References
In Depth Information
Using Mixed References
A multiplication table using a mixed reference
original formula with
a mixed cell
multiplies the first
row by the first
formula copied to
the B3:F7 range with
mixed ranges to
multiply the first row
entries by the first
values returned by
Understanding When to Use Relative, Absolute, and Mixed References
Part of effective formula writing is knowing when to use relative, absolute, and mixed
references. Use relative references when you want to repeat the same formula with cells
in different locations on your worksheet. Relative references are commonly used when
copying a formula that sums a column of numbers or that calculates the cost of several
items by multiplying the item cost by the quantity being purchased.
Use absolute references when you want different formulas to refer to the same cell.
This usually occurs when a cell contains a constant value, such as a tax rate, that will be
used in formulas throughout the worksheet.
Mixed references are seldom used other than when creating tables of calculated
values such as a multiplication table in which the values of the formula or function can be
found in the initial rows and columns of the table.