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 namebox, and then click OK.

  4. 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



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language