How to link an Excel cell to a cell in another file?

Linking cells together in Excel is very simple. You can reference them in different sheets. The Excel cell can be linked to the cell in the file, which has its own advantages and uses. Now, you learn how to link an Excel cell to a cell in another file.

A simple way to link a cell to a cell in another file

First open both files to use the data of another Excel file. Suppose the name of one is A and the other is B. The goal is to have the C2 cell from file B (just one sheet) equal to the data A4 cell in file A. In file A, select the cell A4 and copy it. It does not matter if you do this with the shortcut Ctrl + C or use the copy button in Excel.

How to link an Excel cell to a cell in another file?

The next step is to select cell C in file B. The last step is to paste, but not normally, use the Advanced Paste button in the right-click menu or the Paste menu in Clipboard box in Home tab. Click on the icon that appears on the link.

How to link an Excel cell to a cell in another file?

How to link an Excel cell to a cell in another file?

How to link an Excel cell to a cell in another file?

Notice that the link created means that the cell from the file A always depends on the file B. If the path of the files is changed, the link disappears. However, you do not need to have both files in a folder.

How to link an Excel cell to a cell in another file?
3.6 (71.76%) 17 vote[s]

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *