A1 reference style in ExcelĪ1 is the default style used most of the time. There exist two address styles in Excel: A1 and R1C1. A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon.įor example, the range A1:C2 includes 6 cells from A1 through C2. In Microsoft Excel, a range is a block of two or more cells.
=A1+A2 What is a range reference in Excel? To add up the values in cells A1 and A2, you use this one: When used in a formula, cell references help Excel find the values the formula should calculate.įor instance, to pull the value of A1 to another cell, you use this simple formula: Relative, absolute and mixed cell referencesĪ cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.įor example, A1 refers to the cell at the intersection of column A and row 1 B2 refers to the second cell in column B, and so on.