About cell and range references
 S
ource: Excel Help
A reference identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to look for the values or data you want to use in a
formula. With references, you can use data contained in different parts of a worksheet in one formula or use the value from one cell in several
formulas. You can also refer to cells on other sheets in the same workbook, and to other workbooks. References to cells in other workbooks are
called links.
A1 Reference Style
By default, Excel uses the A1 reference style, which refers to columns with letters (A through IV, for a total of 256 columns) and refers to rows
with numbers (1 through 65536). These letters and numbers are called row and column headings. To refer to a cell, enter the column letter followed
by the row number. For example, B2 refers to the cell at the intersection of column B and row 2.
To refer to
Use
The cell in column A and row 10
A10
The range of cells in column A and rows 10 through 20
A10:A20
The range of cells in row 15 and columns B through E
B15:E15
All cells in row 5
5:5
All cells in rows 5 through 10
5:10
All cells in column H
H:H
All cells in columns H through J
H:J
The range of cells in columns A through E and rows 10 through 20
A10:E20
Reference to another worksheet
In the following example, the AVERAGE worksheet function calculates the average value for the range B1:B10
on the worksheet named Marketing in the same workbook.
Link to another worksheet in the same workbook
Note that the name of the worksheet and an exclamation point (!) precede the range reference.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Difference between Relative and Absolute References
Relative references:
A relative cell reference in a formula, such as A1, is based on the relative position of the cell that contains the formula and the
cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed. If you copy the formula across rows
or down columns, the reference automatically adjusts. By default, new formulas use relative references. For example, if you copy a relative reference
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '09
 Johnston
 knives, Utility knife, Collet, XActo Knife Dremel

Click to edit the document details