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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.