How to Link Sheets in Excel

This wikiHow teaches you how to link data between multiple worksheets in a set of Microsoft Excel workbooks. The linking process automatically pulls data from one sheet to another, and updates the data on the destination sheet every time you change a column in the source sheet.

Steps

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/47/Link-Sheets-in-Excel-Step-1.jpg/v4-728px-Link-Sheets-in-Excel- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/47/Link-Sheets-in-Excel-Step-1.jpg/v4-728px-Link- Sheets-in-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}

Open the Microsoft Excel workbook. Excel has a blue and white “X” icon.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/17/Link-Sheets-in-Excel-Step-2.jpg/v4-728px-Link-Sheets-in-Excel- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/17/Link-Sheets-in-Excel-Step-2.jpg/v4-728px-Link- Sheets-in-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser -output”></div>”}

Click the landing page from the sheet tabs. A list of sheets will display at the bottom of the Excel window. Click the sheet that you want to link to another sheet.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4f/Link-Sheets-in-Excel-Step-3.jpg/v4-728px-Link-Sheets-in-Excel- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4f/Link-Sheets-in-Excel-Step-3.jpg/v4-728px-Link- Sheets-in-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:”<div class=”mw-parser -output”></div>”}

Click a blank cell on the destination sheet. This will be the destination cell. When you link the destination cell to another worksheet, the data in this cell is automatically synchronized and updated each time the data in the source cell changes.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/12/Link-Sheets-in-Excel-Step-4.jpg/v4-728px-Link-Sheets-in-Excel- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/12/Link-Sheets-in-Excel-Step-4.jpg/v4-728px-Link- Sheets-in-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}

Type = in the cell to start the formula in the target cell.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fb/Link-Sheets-in-Excel-Step-5.jpg/v4-728px-Link-Sheets-in-Excel- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fb/Link-Sheets-in-Excel-Step-5.jpg/v4-728px-Link- Sheets-in-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}

Click the source sheet from the sheet tabs. Find the sheet from which you want to get the data and click on that tab to open the sheet.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d9/Link-Sheets-in-Excel-Step-6.jpg/v4-728px-Link-Sheets-in-Excel- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d9/Link-Sheets-in-Excel-Step-6.jpg/v4-728px-Link- Sheets-in-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}

Check the formula bar. The formula bar displays the value of the target cell at the top of the workbook. When you switch to the source sheet, the formula bar displays an equals sign, the name of the current sheet, and an exclamation point.

Or you can manually type in the formula bar. The formula should look something like this =<SheetName>! , where “<SheetName>” is your source page name.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0e/Link-Sheets-in-Excel-Step-7.jpg/v4-728px-Link-Sheets-in-Excel- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0e/Link-Sheets-in-Excel-Step-7.jpg/v4-728px-Link- Sheets-in-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}

Click a cell on the source page. This is the source cell. The source cell can be an empty cell or a cell that already has data. When you link sheets, the destination cell is automatically updated with the data in the source cell.

For example, if you drag data from cell D12 in Sheet1, the formula will be =Sheet1!D12 .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Link-Sheets-in-Excel-Step-8.jpg/v4-728px-Link-Sheets-in-Excel- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Link-Sheets-in-Excel-Step-8.jpg/v4-728px-Link- Sheets-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser -output”></div>”}

Press ↵ Enter to complete the formula and convert back to the destination sheet. Now that the destination cell has been linked to the source cell, the data will automatically be fetched and imported. Every time you edit the data in the source cell, the destination cell will also be updated.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Link-Sheets-in-Excel-Step-9.jpg/v4-728px-Link-Sheets-in-Excel- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Link-Sheets-in-Excel-Step-9.jpg/v4-728px-Link- Sheets-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}

Click the destination cell to highlight it.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Link-Sheets-in-Excel-Step-10.jpg/v4-728px-Link-Sheets-in-Excel- Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Link-Sheets-in-Excel-Step-10.jpg/v4-728px-Link- Sheets-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser -output”></div>”}

Click and drag the square icon in the lower right corner of the target cell. This will expand the range of linked cells between the source and destination worksheets. When you expand the original destination cell, adjacent cells on the source sheet will also be linked.

You can drag and extend the range of linked cells in all directions, including part or all of the worksheet.

Steps

Related Posts