Refer to the same cell or range on multiple sheets

A 3-D references makes it possible to link worksheets together. You can manually enter the cell or range of cells that you want to include, but clicking the cells will give you an accurate link every time.

  1. Click the cell where you want to enter the function.

  2. Type = (equal sign) followed by the name of the function and an open parenthesis mark. For example, =sum(.

  3. Click the tab of the first sheet that you want to reference.

  4. Hold down SHIFT and then click the tab for the last sheet that you want to reference.

  5. Create your formula by selecting a cell or range of cells from each of the tabs you selected.

  6. Complete the formula, and then press RETURN .

See also

Enter a formula

View multiple panes, sheets, or workbooks

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!