What linking a sheet means and why you'd do it
Linking one Excel sheet to another means creating a formula in one sheet that pulls data from a different sheet in the same workbook. Instead of typing the same number twice or copying data back and forth, you write a formula that says "get this value from Sheet2" — and if that value changes, your linked formula updates automatically.
You use this when you have data spread across multiple sheets and need to summarize it, compare it, or feed it into calculations on a different sheet. A common example: you have sales data on Sheet1, inventory on Sheet2, and a summary dashboard on Sheet3 that pulls numbers from both.
The alternative is copying and pasting the same data into multiple places, which means updating it manually every time it changes. Linking saves that work and prevents mistakes from forgetting to update one copy.
Key Takeaways
- A linked formula in Excel starts with the sheet name followed by an exclamation mark and the cell reference, like =Sheet1!A5 or =Sales!B12.
- You can type the formula directly, or click the sheet tab and then click the cell you want to link to — Excel builds the formula for you.
- If you rename a sheet after creating a linked formula, Excel updates the formula automatically to use the new sheet name.
- Linked formulas work only within the same workbook; to pull data from a different Excel file, you need a different method called external linking.
The basic formula structure for linking sheets
Every linked formula follows the same pattern: the sheet name, then an exclamation mark, then the cell address. If your sheet is called "Sales" and you want to link to cell B5, the formula is =Sales!B5. If the sheet name has a space in it — like "Q1 Results" — you wrap the name in single quotes: ='Q1 Results'!B5.
You can link to a single cell, a range of cells, or use the linked cell inside another formula. For example, =Sales!B5*1.1 pulls the value from Sales sheet cell B5 and multiplies it by 1.1. Or =SUM(Inventory!A1:A10) adds up cells A1 through A10 from the Inventory sheet.
The sheet name is case-insensitive — =sales!B5 and =Sales!B5 work the same way — but Excel displays it in the case you used when you created the sheet.
How to create a linked formula by typing
Open the sheet where you want the linked formula to appear and click the cell where you want it. Type the equals sign to start a formula, then type the sheet name, an exclamation mark, and the cell address. For example, type =Sheet1!A5 and press Enter.
If the sheet name contains spaces or special characters, type the name in single quotes. Type ='Sales Data'!C10 and press Enter. Excel accepts the formula and displays the value from that cell.
This method is fastest if you know exactly which cell you want and which sheet it is on. It is also the only way to link to a cell on a sheet you have not opened yet in this session.
How to create a linked formula by clicking
This method lets Excel write the formula for you, which prevents typing mistakes. Click the cell where you want the linked formula. Type an equals sign. Then click the sheet tab at the bottom of the screen for the sheet you want to link to. The sheet switches, and you are now on that sheet. Click the cell you want to link to. Excel automatically builds the formula with the correct sheet name and cell address, and you see it in the formula bar at the top.
Press Enter to confirm the formula. You are returned to your original sheet, and the linked value appears in the cell.
This method works well when you can see both sheets easily or when you are not sure of the exact cell address. It is also harder to mistype the sheet name because Excel fills it in for you.
What happens when you rename or move a sheet
If you rename a sheet after you have created linked formulas, Excel updates all the formulas automatically. If you had =Sheet1!A5 and you rename Sheet1 to "Q1 Sales", the formula becomes ='Q1 Sales'!A5 without you doing anything.
If you move a sheet to a different position in the workbook — by dragging its tab left or right — the linked formulas still work. The sheet location does not matter, only its name.
If you delete a sheet that other sheets are linked to, those linked formulas break and display #REF! error. You would need to fix the formula by pointing it to a different sheet or removing it.
Linking to a range of cells instead of a single cell
You can link to a range of cells the same way you link to a single cell. Use the range address with a colon between the first and last cell. =Sheet1!A1:A10 links to cells A1 through A10 on Sheet1. =Sales!B5:D15 links to the rectangle of cells from B5 to D15.
When you link to a range, you usually use it inside another function. =SUM(Sheet1!A1:A10) adds up all the values in that range. =AVERAGE(Sales!B5:D15) calculates the average. =COUNT(Inventory!C1:C50) counts how many cells in that range contain numbers.
If you just type =Sheet1!A1:A10 by itself in a single cell, Excel displays only the value from the first cell in the range (A1). The range is there, but you are only seeing one value.
Linking to named ranges
If a sheet has a named range — a group of cells that has been given a custom name — you can link to it by name instead of by cell address. For example, if someone created a named range called "TotalSales" on the Sales sheet, you can write =Sales!TotalSales instead of figuring out which cells it includes.
Named ranges make formulas easier to read and more flexible. If the range gets moved or resized, the formula still works because it refers to the name, not the specific cells. To see what named ranges exist in your workbook, go to the Formulas tab and click "Name Manager".
You can create your own named ranges too. Select the cells you want to name, go to the Formulas tab, click "Define Name", and type a name. Then you can use that name in linked formulas on any sheet in the workbook.
Frequently Asked Questions
Can I link to a cell on a sheet in a different Excel file?
Yes, but it requires external linking, which is different from the method described here. You would use a formula like =[C:\Users\Documents\Sales.xlsx]Sheet1!A5 with the full file path in square brackets. However, external links can break if the other file is moved or deleted, so they are less reliable for everyday use.
What does #REF! error mean in a linked formula?
It means the formula is pointing to a cell or sheet that no longer exists. This usually happens when someone deletes the sheet you were linking to, or deletes the specific cell. You need to fix the formula by pointing it to a different cell or removing it.
If I copy a cell with a linked formula to another sheet, does the link change?
No, the link stays the same. If you copy =Sheet1!A5 from one sheet and paste it on another sheet, it still pulls from Sheet1 cell A5. The sheet reference does not change based on where you paste it. If you want the reference to adjust, you would need to use a relative reference method, which is more advanced.
Can I link to a cell that contains a formula?
Yes. When you link to a cell, you get the result of whatever is in that cell — whether it is a number you typed, a formula, or text. The linked cell shows the final value, not the formula itself.
Do linked formulas update automatically when the source cell changes?
Yes, they update when ready when you change the source cell. If you link to Sheet1 cell A5 and someone changes the value in A5, the linked formula on your sheet recalculates right away. This is one of the main reasons to use linking instead of copying data.