Download ArticleDownload ArticleThis article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 432,171 times.
Learn more...
This How.com.vn teaches you how to link data between multiple worksheets in a Microsoft Excel workbook. Linking will dynamically pull data from a sheet into another, and update the data in your destination sheet whenever you change the contents of a cell in your source sheet.[1]
Quick Guide for Linking Sheets in Excel
Click an empty cell in your destination sheet, then type an equal sign (=) and click on the source sheet, then the source cell in the source sheet, and hit Enter. Check to make sure that the destination cell's formula has been altered.
Steps
Download Article
Open a Microsoft Excel workbook. The Excel icon looks like a green-and-white "X" icon.
Click your destination sheet from the sheet tabs. You will see a list of all your worksheets at the bottom of Excel. Click on the sheet you want to link to another worksheet.[2]Advertisement
Click an empty cell in your destination sheet. This will be your destination cell. When you link it to another sheet, the data in this cell will be automatically synchronized and updated whenever the data in your source cell changes.[3]
Type = in the cell. It will start a formula in your destination cell.
Click your source sheet from the sheet tabs. Find the sheet where you want to pull data from, and click on the tab to open the worksheet.
Check the formula bar. The formula bar shows the value of your destination cell at the top of your workbook. When you switch to your source sheet, it should show the name of your current worksheet, following an equals sign, and followed by an exclamation mark.[4]- Alternatively, you can manually write this formula in the formula bar. It should look like =<SheetName>!, where "<SheetName>" is replaced with the name of your source sheet.[5]
Click a cell in your source sheet. This will be your source cell. It could be an empty cell, or a cell with some data in it. When you link sheets, your destination cell will be automatically updated with the data in your source cell.[6]- For example, if you're pulling data from cell D12 in Sheet1, the formula should look like =Sheet1!D12.[7]
Click ↵ Enter on your keyboard. This will finalize the formula, and switch back to your destination sheet. Your destination cell is now linked to your source cell, and dynamically pulls data from it. Whenever you edit the data in your source cell, your destination cell will also be updated.
Click your destination cell. This will highlight the cell.
Click and drag the square icon in the lower-right corner of your destination cell. This will expand the range of linked cells between your source and destination sheets. Expanding your initial destination cell will link the adjacent cells from your source sheet.- You can drag and expand the range of linked cells in any direction. This could include the entire worksheet, or only parts of it.
Community Q&A
- QuestionIn the above linking of rows to multiple sheets, how do I keep the rows in the separate sheets together when sorting?
Azmat najeebCommunity Answer1. Open a workbook. By default, it has three sheets. If you want more, you can insert more sheets according to your requirements. 2. Press the CTRL key and select the sheet you want to group. Your sheets are now grouped. The changes made to one will replicate on the others. - QuestionWhat if I want the destination cell to add or subtract from the source cell?Azmat najeebCommunity AnswerA cell reference combines the column letter and row number, such as A1 or F345. 1.Type a number in cells C1 and D1. For example, a 5 and a 3. 2. In cell E1, type an equal sign (=) to start the formula. 3. Type "C1+D1" (without the quotes) to complete your formula. If your destination cell E1 is in another sheet, then use "=sheet1!C1+sheet1!D1". If the cell D1 is in the same sheet as E1, then use "=sheet1!C1+D1".
- QuestionCan you link a completely different Excel file to another Excel file, or does it work only if it's in the same file?
Holly HortCommunity AnswerIn Microsoft Excel, you can link data from one Excel file to another, even if they are in separate files. This is commonly done using the "External Links" feature.
Video
Tips
References
- ↑ https://support.microsoft.com/en-us/office/update-workbook-links-21e995b5-bab1-4328-8ab3-dd357fe0e653
- ↑ https://support.microsoft.com/en-gb/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
- ↑ https://support.microsoft.com/en-gb/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
- ↑ https://support.microsoft.com/en-us/office/create-workbook-links-c98d1803-dd75-4668-ac6a-d7cca2a9b95f
- ↑ https://support.microsoft.com/en-us/office/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa
- ↑ https://support.microsoft.com/en-us/office/create-workbook-links-c98d1803-dd75-4668-ac6a-d7cca2a9b95f
- ↑ https://support.microsoft.com/en-us/office/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa
About This Article
1. Open Excel.
2. Click your destination cell.
3. Type "=".
4. Click another sheet.
5. Click your source cell.
6. Press Enter on your keyboard.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
