{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Relative_Absolute_Referencing_08_03_06

# Relative_Absolute_Referencing_08_03_06 - About cell and...

This preview shows pages 1–3. Sign up to view the full content.

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.

{[ snackBarMessage ]}