Cell Reference 2007. You can use three types of cell references in excel 2007 formulas. Using cell references allows your formulas to update automatically if the value in a particular cell changes and can also assist you in updating formulas as cells are copied or moved.
Cell references are an important part of creating formulas in excel. Formulas and functions are at their most useful when using references so you need to understand them. For example deptsales sales tax or first quarter.
Don t use cell references names can t be the same as a cell reference such as z 100 or r1c1.
A cell reference consists of the column letter and row number that intersect at the cell s location. The excel offset function returns a reference to a cell or a range of cells that is offset from a specific cell by a given number of rows and columns. A cell is one of the boxlike structures that fill a worksheet and you can locate one by its references such as a1 f26 or w345. Cell references are an important part of creating formulas in excel.
