How to link multiple cells from another worksheet in Excel

When you link a cell in Excel to a cell in another worksheet, the cell that contains the link shows the same information as the cell in the other worksheet. The cell that contains the link is called a dependent cell. The cell in the other worksheet that contains the data to which the link is referenced is called the preceding cell. The dependent cell changes automatically if the preceding cell changes. If you want to link multiple cells in another spreadsheet, you can use a matrix function, which allows you to link a range of cells with a formula.

Click on the tab of the spreadsheet, at the bottom of the screen, which contains a range of preceding cells that you want to link. A range is a block or group of adjacent cells. For example, suppose you want to link a range of empty cells in “Sheet1” to a range of preceding cells in “Sheet2”. Click on the “Sheet2” tab.

How to link multiple cells from another worksheet in Excel

Determine the width of the preceding rank in columns, and its height in rows. In this example, suppose that the cells from A1 to A4 of “Sheet2” contain a list of numbers 1, 2, 3 and 4, respectively, which will be your previous cells. This preceding rank has a column width by four rows high.

Click on the tab of the spreadsheet, at the bottom of the screen, which contains the empty cells in which you will insert the link. In this example, click on the “Sheet1” tab.

Select the range of empty cells you want to link to the preceding cells. This range must be the same size as the preceding range, but it may be in a different location on the spreadsheet. Click and hold the mouse button on the upper left cell of the range, drag the mouse cursor to the lower right cell of this range and release the button to select. In this example, assume that you want to link cells C1 to C4 to the preceding range. Click on cell C1, drag the mouse to cell C4 and release the mouse to highlight the range.

Write “=”, the name of the sheet that contains the preceding cells, “!”, The upper left cell of the preceding range,: “and the lower right cell of the preceding range, press” Ctrl “,” Shift “and” Enter ” “simultaneously to complete the matrix formula, each dependent cell is now linked to its respective cell in the preceding range, in this example, write” = Sheet2! A1: A4 “and press” Ctrl “,” Shift “and” Enter “simultaneously Cells C1 through C4 of the “Sheet1”, now contain the formula “{= Sheet2! A1: A4”} “, demarcated by brackets, and shows the same data as the previous cells in” Sheet2 “.

 

You may also like...