How To Add A Cell From Another Sheet In Excel

Ofttimes, nosotros take to deal with multiple worksheets in Excel and hover to different sheets to find a value. In this article, nosotros demonstrate how to Excel link cell to another sheet.

Let'south say, we have Sale data for Dec'21 of three different cities, New York, Boston, and Los Angeles. These three Sale information are identical in orientation, so, nosotros show only one worksheet equally a dataset.

We want to link each city's Full Sale amount to another sheet using HYPERLINK, INDIRECT functions as well as multiple Excel features.

Download Excel Workbook

7 Easy Ways to Link Jail cell to Some other Canvass in Excel

Method 1: Using Insert Link Selection to Link Cell to Another Sheet

In Insert Tab, Excel offers a feature equally Insert Link. We can make any prison cell link using this feature then insert it in whatever cell we want. In this example, nosotros can make individual links for a cell from any sheet then insert them in whatever worksheet we want. In this way, nosotros tin link a cell to another sheet.

Step 1: First, place the prison cell that you want to insert the link to. The prison cell is F13 of the New York canvas. You have to echo the steps for each cell.

Step ii: Go to another canvas where y'all want to insert the link to the cell. Place the mouse (i.e., C5) where you desire to insert the link. And so, Become to Insert Tab > Select Insert Link (from Link department).

Step 3: The Insert Hyperlink window opens up. In the window,

Select Identify in the Document (under Link to options).

Type F13 (in the Type the cell reference option)

Select 'New York' (nether Or select a place in this document)

Afterward, you lot see 'New York'!F13 every bit Text to display.

Click OK.

⏩ Clicking OK inserts the link to the jail cell (i.eastward., C5) in the desired canvass.

⏩ Repeat Steps 2 and 3 to insert corresponding cell links in some other canvass. Repeating Steps 2 and 3 results in something like the image beneath.

⏩ If you lot want to bank check the link, merely click on information technology.

⏩ It'll take you lot to the New York canvass where the value sits.

⏩ The Context Bill of fare option can besides be used to bring out the Insert Hyperlink window. Also, Keyboard Shortcuts CTRL+K does the job.

Read More: How to Link Files in Excel (five Different Approaches)

Method 2: Using Cell Reference to Link Cell to Some other Sheet in Excel

Excel allows us to link a prison cell to some other worksheet using cell reference. For instance, nosotros desire the urban center-wise (i.e., New York, Boston, or Los Angeles) monthly Total Sale in other sheets.

Footstep 1: To insert a formula, just Type the Equal Sign (=) in the formula bar.

Step two: After typing the Equal Sign (=) in the Formula Bar, Go to the corresponding sheet (i.e., New York) you want to reference a cell from then Select Full Sale sum amount cell (i.eastward., F13) as reference.

Pace three: As you select the reference jail cell, Hit ENTER. You'll jump back to the destined worksheet with the sum amount of Full Sale for New York City Auction December'21 similar to the image below.

Yous tin link other sum amounts by repeating the same steps (i.e., Steps 1 to 3) mentioned earlier. And you'll come up with something like the post-obit pic.

In this method, nosotros can employ any cell reference to link the jail cell to another worksheet.

Read More than: How to Reference Worksheet Name in Formula in Excel (three Easy Ways)

Method 3: Using Copy Paste Characteristic to Link Cell Some other Sheet in Excel

Excel Copy and Paste feature can copy and paste prison cell links anywhere in Excel. As a upshot, we can utilize the Copy and Paste feature to link cells to another sheet.

Step 1: Motility to the cell, you lot want to copy the link. Right-Click on the cell (i.e., F13). It brings the Context Menu. Select Copy (from the options).

Step 2: Go to the sheet (i.e., Copy and Paste) where you desire to link the cell. Right-Click on the destined cell (i.e., C5) in that canvass (i.e., Copy and Paste). The Context Card appears. From the Context Menu,

Select Paste Special > Select Paste Link (from Other Paste Options).

⏩ The Total Auction value appears in the cell equally shown in the following paradigm.

⏩ Afterward repeating Steps i and ii for other entries, y'all go the values nosotros want to link the cells in some other sail.

Read More than: How to Link Multiple Cells from Some other Worksheet in Excel (5 Like shooting fish in a barrel Means)

Similar Readings

Reference from Another Excel Workbook without Opening (v Examples)
Transfer Specific Data from One Worksheet to Another for Reports
How to Link Two Sheets in Excel (3 Ways)
Link Information in Excel from 1 Canvas to Another (4 Ways)

Method 4: Using Name Box to Link Cell to Some other Sheet

Excel offers a feature called Name Box. Using the Name Box feature, we tin can refer to any cell or range in Excel. For this instance, we tin can utilize the Name Box to name a certain cell in sheets so link it to some other sheet. As we want to link the sum amount of each sheet, we have to assign a name to each sum Total Auction cell in the corresponding sheets.

Step 1: Assign a name (i.e., NY_Total_Sale) for New York to cell F13 using the Name Box. Repeat the stride for other sheets such as Boston and Los Angeles.

⏩ You can check whether naming by Name Box successfully does the job or not. To do so, Get to Formulas Tab > Select Name Managing director (from the Defined Names section).

⏩ The Name Director window pops up and yous can find all the assigned names in the workbook.

From the to a higher place screenshot, yous can see the assigned names that we named after sure cells.

Stride two: Subsequently assigning names, Go to any worksheet, Type =NY… for inserting the sum value from the New York sheet. You run into assigned names as selectable options. Select the option.

⏩ As you select the pick, the sum of Total Sale (for New York) value appears in the cell.

⏩ If you repeat the Steps (i.east., Steps ane and 2) for other cities, y'all'll become all the values for respective cities equally shown in the following image.

Read More: How to reference jail cell in another Excel sheet based on cell value!

Method five: Using HYPERLINK Part

As we want to link cells to another sheet, we can employ the HYPERLINK function to link cells as clickable hyperlink destinations in another canvas. The HYPERLINK function converts a destination and a given text into a hyperlink. For this purpose, we tin can instantly move to a cell equally per our demand but by clicking on the links existing in another sheet.

The syntax of the HYPERLINK function is

HYPERLINK (link_location, [friendly_name])

In the formula,

link_location; path to the prison cell you lot want to spring.

[friendly_name]; display text in the cell where nosotros insert the hyperlink [Optional].

Footstep 1: Paste the following formula in any cell (i.e., C5).

=HYPERLINK("#'"&B5&"'!F13",B5)

If we compare the arguments,

"#'"&B5&"'!F13″= link_location

B5=[friendly_name]

Step 2: Press ENTER and then Drag the Fill up Handle to make the other hyperlinks appear in cells C6 and C7.

Y'all encounter hyperlinks for Boston and Los Angeles appear as they did for New York.

⏩ You can bank check whether the hyperlinks piece of work or non, by clicking on whatever hyperlinks. For this reason, nosotros click on the New York named hyperlink.

⏩ In a moment nosotros bound to the New York canvass's F13 cell (as directed in the formula) as shown in the prototype below.

You lot can test the hyperlinks for each prison cell and every fourth dimension you'll jump to the destination as directed in the formula. For better agreement and brief representation, we utilise only three worksheets to fetch the data from, you can use equally many equally you lot want.

Read More than: How to Link Sheets in Excel with a Formula (4 Methods)

Method half dozen: Using INDIRECT Function

We want to link a cell to some other sail using functions and Excel'southward features. This can likewise exist achieved using the INDIRECT part. The INDIRECT office creates a cell reference using a text string. The syntax of the INDIRECT function is

INDIRECT (ref_text, [a1])

The arguments refer,

ref_text; reference in the form of text.

[a1]; a boolean indication for A1 or R1C1 style reference [Optional]. Default option represents True=A1 style.

Step 1: Write the post-obit formula in any blank cell (i.eastward., C5).

=INDIRECT("'"&B5&"'!F13")

As we know the cell reference for the sum of Full Auction is in F13 for all three sheets and B5 represents the sheet name from where the data will be fetched.

Step 2: Pressing ENTER, elevate the Fill Handle to bring out the amount for other sheets. In a moment, you'll see the sum amounts of Total Sale appear.

Read More: How to Link Sheets to a Main Sheet in Excel (5 Means)

Method 7: Using Elevate and Drop Method

We used the HYPERLINK function or Insert Link feature to insert a link of a prison cell in another sheet in previous methods. Excel offers a manual way to insert a link of a cell in any sheet nosotros want.

Stride i: Identify the cursor at the edge of a jail cell's (i.east., F13) border and wait until the unabridged pick icon appears.

Step two: Right-Click on the mouse the Excel shows the cell number nether the cursor.

Footstep 3: Holding the Right-Click press ALT and Drag the cursor towards the destined canvass (where you want to insert the link). ALT key is used to shift between sheets in Excel. Later moving closer to the destined sheet (i.e., Drag and Drop), Excel selects the destined sheet.

Step 4: Place the cursor where you lot want the link (i.e., C5 in Drag and Drop Canvas). Then Release the Right Click holding, a Context Menu appears. Select the Create Hyperlink Here option.

⏩ Selecting Create Hyperlink Here inserts the jail cell's link in the Elevate and Drop Canvas'south C5 cell.

⏩ Repeat the sequences (i.e., Steps 1 to 3) to insert links of all required cells in the sheet.

You can check whether the inserted links work or not by simply clicking on them.

Read More than: How to Link Excel Sheets to Another Canvass (5 Means)

Conclusion

In the article, we demonstrate multiple ways to Excel link cell to some other sheet. To do then, we utilise HYPERLINK and INDIRECT functions as well equally multiple Excel features. Some methods create clickable links to the cell and others just fetch the values from the respected cells. You can use whatever of the methods to link a cell to another sail according to your dataset demand. Hope the above-described methods practise your job. If you have further queries or something to add together, experience free to comment in the comment section.

Link Excel Workbooks for Automatic Update (5 Methods)
How to Link Word Document to Excel (two Like shooting fish in a barrel Methods)
Link Excel Workbooks (4 Constructive Methods)
How to Link Two Workbooks in Excel (5 Methods)
Link Data from 1 Spreadsheet to Another in Excel