How To Link Excel Workbooks Using These Simple Steps

Asked By Diamante Adam 0 points N/A Posted on - 08/19/2016

Hi. I have started working on Excel recently and I want to link the two worksheets that I have created in Excel. How to link Excel workbooks? Thanks in advance. Please reply ASAP.

• Status: Open
• Question Views: 363
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Qamar Khan 55 points N/A #125739

How To Link Excel Workbooks Using These Simple Steps

Hi. To learn how to link Excel workbooks, first open the workbooks which need to be linked in MS-Excel. Select the spreadsheet which is the source and then in it, select each cell which you want to link to the destination spreadsheet. While selecting multiple cells from both the spreadsheets, keep on pressing the ctrl key. Next, on the cell which has been selected, right-click and then click on the copy option from the menu. Then, switch over to the destination spreadsheet. Then, click on the cell where the data from the source spreadsheet should be transferred.

Then, in the cell to which the data is to be transferred, right-click and then click on the paste special option and then to create a link between both the spreadsheets, press N. You can also first create a connection between the spreadsheets and then add the tables to the new worksheet by using the import data function.

Hope we helped.

About Qamar Khan

Questions
5

Answers
27

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/19/2016
• Question Category: MS Excel