Course summary: Understand and use cell references

Create a cell reference on the same worksheet

  1. Click the cell in which you want to enter the formula.
  2. In the formula bar, type = (equal sign).
  3. Do one of the following:
  • Reference one or more cells    To create a reference, select a cell or range of cells on the same worksheet. Cell references and the borders around the corresponding cells are color-coded to make it easier to work with them. You can drag the border of the cell selection to move the selection, or drag the corner of the border to expand the selection.
  • Reference a defined name    To create a reference to a defined name, do one of the following:
  • Type the name.
  • Press F3, select the name in the Paste name box, and then click OK.
  1. Do one of the following:
  • If you are creating a reference in a single cell, press Enter.
  • If you are creating a reference in an array formula (such A1:G4), press Ctrl+Shift+Enter.

    The reference can be a single cell or a range of cells, and the array formula can be one that calculates single or multiple results.

See also

 
 
Applies to:
Excel 2013