A cell reference in a formula allows you to point to another cell location.
Updated: 12/31/2020 by When you are working with a spreadsheet in Microsoft Excel, it may be useful to create a
formula that references the value of other cells. For instance, a cell's formula might calculate the sum of two other linked cells and display the result. To accomplish this task, the formula must include at least one cell reference. In an Excel formula, a cell reference is used to reference the value of another cell. Referencing a cell is useful if you want to make automatic changes in one
cell whenever data in another cell changes. For example, a financial spreadsheet might use cell references to add up the budget for each week, and automatically calculate the budget for the entire year. Cell references can access data on the same worksheet, or on other worksheets in the same workbook. For instructions on how to reference a cell, choose from the sections below. If the cell you want to reference is in the same worksheet, follow the steps below to reference it. For example, we click the B3 cell, resulting in the cell containing the reference to display "=B3" and mirror any data changes made in B3. Reference a cell from another worksheet in the current workbookIf the cell you want to reference is in another worksheet that's in your workbook (the same Excel file), follow the following steps.
For example, we have a spreadsheet containing two worksheets named "Data" and "Calculations." In the Calculations worksheet, we want to reference a cell from the Data worksheet. We click the Data worksheet tab, then click the B3 cell, resulting in the formula bar displaying "=Data!B3" for the cell containing the reference. The data displayed in the Calculations worksheet mirrors the data in the B3 cell in the Data worksheet, and changes if the B3 cell changes. Add two cellsYou can perform mathematical operations on multiple cells by referencing them in a formula. For example, let's add two cells together, using the + (addition) operator in a formula.
Now, if you change the values in cells A1 or B1, the value in C1 updates automatically. Tip You don't have to click the cells to insert their cell reference in the formula. If you prefer, with cell C1 selected, type =A1+B1 in the formula bar and press Enter. Add up a range of cellsYou can reference a range of cells in a formula by inserting a colon (:) between two cell references. For example, you can add a range of values using the SUM() function. In this example, we show how you can sum an entire row or column of values, by specifying the range between two cell references.
What cells are referenced by a formula in another cell?Precedent cells — cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, then cell B5 is a precedent to cell D10. Dependent cells — these cells contain formulas that refer to other cells.
What is the cell reference for the cell located?A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For 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.
What is a cell reference in Excel?Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell's location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.
|