How to Reference Another Sheet in Excel

To reference another sheet in Excel, add the sheet name and an exclamation mark before the cell or range, such as ='Sales'!B2.

The punctuation changes slightly when a sheet name contains spaces, and the pattern makes cross-sheet formulas easier to build and troubleshoot.

How does an Excel sheet reference work?

A basic reference has this structure: =SheetName!CellAddress.

The exclamation mark separates the worksheet name from the cell address.

For example, if a worksheet named Sales contains a total in cell B2, enter =Sales!B2 on another sheet to display that value.

The equals sign tells Excel that the entry is a formula.

If the source cell contains 1250, the formula returns 1250.

If the value in Sales!B2 changes, Excel updates the linked result when calculation is enabled.

How do you reference a cell on another sheet?

Select the cell where you want the result.
Type =, then select the source worksheet tab.
Select the cell you want to reference and press Enter.

Excel writes the reference for you.

You can also type it directly.

For a sheet named Inputs and cell C5, use =Inputs!C5.

If Inputs!C5 contains 42, the formula displays 42.

To use the referenced value inside another calculation, place the reference in a formula.

For instance, =Inputs!C5*2 returns 84 when the source value is 42.

You can also combine values from different sheets, as in =January!B2+February!B2.

What if the sheet name contains spaces or punctuation?

Wrap the sheet name in single quotation marks when it contains spaces or characters that require quoting.

For a worksheet named Quarter 1, reference cell D4 with ='Quarter 1'!D4.

The single quotation marks belong around the sheet name, before the exclamation mark.

Quoting a simple name is also valid: ='Sales'!B2.

If the sheet name itself contains an apostrophe, double that apostrophe inside the quoted name.

For a sheet called Director's Notes, the reference to A1 is ='Director''s Notes'!A1.

How do you reference a range on another sheet?

Use a colon between the first and last cell addresses.

To sum values in B2:B10 on a worksheet named Sales Data, enter =SUM('Sales Data'!B2:B10).

If those cells contain 10, 20, and 30, with the remaining cells blank, the result is 60.

You can use a cross-sheet range with many functions, including AVERAGE, COUNT, MIN, and MAX.

For example, =AVERAGE('Sales Data'!B2:B10) returns the arithmetic mean of the numeric values in that range.

Blank cells are generally ignored by these functions, though text and error values can affect results differently depending on the function.

How do relative and absolute references behave?

Excel references are relative by default.

If you copy =Sales!B2 one column to the right, Excel typically adjusts it to =Sales!C2.

This is useful when copying a formula across rows or columns that follow the same layout.

Add dollar signs to lock a row, column, or both.

For example:

=Sales!$B$2 locks both the column and row.
=Sales!$B2 locks the column but lets the row change.
=Sales!B$2 locks the row but lets the column change.

These are still references to cells on the Sales sheet; the dollar signs control how the address changes when you copy the formula.

In many Excel versions, select a reference while editing a formula and press F4 to cycle through reference styles.

On some laptops, you may need Fn+F4.

Can you reference a sheet in another workbook?

Yes.

When both workbooks are open, Excel can create the reference as you select the source cell.

A formula may look like =[Budget.xlsx]Annual!B2.

If the workbook is closed, Excel may include its file path in the reference, such as ='C:\Reports\[Budget.xlsx]Annual'!B2.

External links can break if the source workbook is moved, renamed, or unavailable.

Excel may show a link update prompt or a #REF! error.

Check the source path and workbook name, and use the workbook link controls to inspect or update external references.

Exact menu labels vary between Excel versions.

How do you reference the same cell across multiple sheets?

For worksheets next to each other in the workbook, a 3-D reference can apply a function across the same cell or range on several sheets.

For example, =SUM(January:March!B2) sums cell B2 on every worksheet from January through March, including sheets between them in the tab order.

Use this carefully: inserting or moving sheets within the referenced tab interval can change which sheets are included.

A 3-D reference applies only to worksheets in the same workbook and supports a specific set of functions; it is not a way to sum arbitrary, nonadjacent tabs.

Why might a sheet reference not work?

#REF! error: The referenced cell, sheet, or linked workbook may have been deleted or moved.

Edit the formula to point to a valid location.
#NAME? error: Check the spelling of the sheet name and whether a name with spaces or punctuation is enclosed in single quotation marks.
Formula appears as text: The cell may be formatted as Text, or the entry may begin with an apostrophe.

Change the format to General, then re-enter the formula.
Unexpected value: Confirm the formula points to the intended workbook, sheet, and cell.

Also check whether the source cell contains a formula, an error, or a value stored as text.
Result does not update: Check Excel’s calculation setting.

In manual calculation mode, formulas may need recalculation, for example by pressing F9.

Does this syntax work in Excel and Google Sheets?

The basic syntax, such as =Sheet1!A1 and ='Quarter 1'!D4, works in modern versions of Microsoft Excel and Google Sheets.

Excel desktop, Excel for the web, and Microsoft 365 support ordinary references between worksheets in the same workbook.

Google Sheets uses the same exclamation-mark separator for tabs in the same spreadsheet.

Some features differ.

Excel’s 3-D references and external workbook links do not transfer directly to Google Sheets in the same way.

For a different Google Sheets file, use IMPORTRANGE and authorize access when prompted; for Excel workbooks, use an external workbook reference.

Always check compatibility when sharing formulas between spreadsheet apps, especially if they depend on linked files or version-specific functions.