How to Reference a Tab in Excel (Easiest Way in 2024)

In this article, we will show you how to reference a tab in Excel. Read on to learn more!

How to Reference Another Tab in Excel

To reference another tab in Excel, follow these steps below:

1. Use the Sheet Name in a Formula

To reference a cell from another tab (or sheet), you need to include the sheet name followed by an exclamation mark before the cell reference in your formula.

SheetName!CellReference

2. Write the Formula

Click on the cell where you want the referenced data to appear. Enter the formula using the syntax from Step 1. For example, to reference cell A1 from a tab named “Scores”, you would enter:

=Scores!A1

Example

Let’s say you have a workbook with two tabs named “Inventory” and “Report”. You want to reference the number of items in stock for a particular product from the “Inventory” tab in your “Report” tab.

You want to display the stock level of a product (e.g., “Product A”) which is in cell C5, in the “Report” tab.

1. Enter the Reference Formula

Click on the cell where you want to show the stock level of “Product A”. Type the following formula into the cell:

=Inventory!C5

This formula tells Excel to fetch the value from cell C5 in the “Inventory” tab.

2. Press Enter

After entering the formula, press Enter. The cell will now display the value from “Inventory!C5”.

The “Report” tab will show the current stock level for “Product A” as recorded in the “Inventory” tab, and it will update automatically whenever the inventory data is changed.

We hope that you now have a better understanding of how to reference a tab in Excel. If you enjoyed this article, you might also like our articles on how to cross reference data in Excel and how to reference a named range in Excel.