Q&A for How to Link Sheets in Excel

Return to Full Article

Coming soon

Add New Question

Question

In the above linking of rows to multiple sheets, how do I keep the rows in the separate sheets together when sorting?

Azmat najeeb

Community Answer

1. 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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 10
Question

What if I want the destination cell to add or subtract from the source cell?

Azmat najeeb

Community Answer

A 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".

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 6 Helpful 5
Question

Can you link a completely different Excel file to another Excel file, or does it work only if it's in the same file?

Holly Hort

Community Answer

In 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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 5
Question

How can I go to the linked sheet?

Holly Hort

Community Answer

To navigate to the linked sheet in Excel, locate the cell with the link, then right-click and choose "Open Hyperlink." If the link points to another sheet within the same workbook, it will take you there. If it links to another file, it will open that file; you can then find the relevant sheet.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1
Question

How to link two sheets if the other file is in drive c?

Tinkerer02

Top Answerer

Suppose you want to link file A.xlsx to data in the file mydata.xlsx. Open both files in Excel. Click on the cell in sheetA of "A", say C1. Enter "=", then select the sheet you want in "mydata" (sheet3) and click on the cell A1 (or the one you want) in file "mydata", you will get "=[mydata.xlsx]Sheet3!$A$1". Press Enter/click the check mark in file A. Save file A and close both. When you open file A.xlsx again, the cell C1 of sheetA will now contain "='C:\Users\Username\Documents\[mydata.xlsx]Sheet1'!$A$1". A warning will appear that "Automatic update of links has been disabled": click on the button "Enable Content" to allow updating. Now file A.xlsx is linked with file mydata.xlsx on drive C:. Save the file A for the permission to be permanent.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 0
Question

I successfully linked two sheets. When I drag the destination cell, I get data from the source cell in each of the dragged cells. What should I do?

Tinkerer02

Top Answerer

When adding a linked sheet in a formula, the result is "=Sheet1!$A$1". This notation with the $ sign means that the column A and the row 1 are fixed and will not be updated when dragging cells. If you want the row to increment, then change the formula to "=Sheet1!$A1". Conversely, if you want to have the column to vary, change the formula to "=Sheet1!A$1". If you want both to vary, then use "=Sheet1!A1".

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0