How to Link Cell to Another Sheet in Excel (7 Methods)

We have sales data for December’21 for three different cities: New York, Boston, and Los Angeles. They are in separate sheets, but all follow the same format. We want to link each city’s Total Sale amount to another sheet.

Method 1 – Using the Insert Link Option to Link a Cell to Another Sheet

Steps:

• Identify the cell that you want to insert the link to. The cell is F13 of the New York sheet. You’ll need to repeat the steps for each cell you want to link.

• Go to another sheet where you want to insert the link to the cell.
• Select the cell (i.e., C5) where you want to insert the link.
• Go to the Insert tab and select Insert Link (from the Link section).

• The Insert Hyperlink window opens.
• Select Place in the Document (under Link to options).
• Put F13 (in the Type the cell reference option)
• Select ‘New York’ under Or select a place in this document.
• You’ll see ‘New York’!F13 as Text to display.
• Click OK.

• Clicking OK inserts the link to the cell.

• Repeat for every cell you need to link.

• To check the link, click on it.

• The first cell correctly links to the F13 cell in the New York sheet.

• The Context Menu option can also be used to bring out the Insert Hyperlink window. You can also use Ctrl + K.

Read More: How to Link Excel Data Across Multiple Sheets

Method 2 – Using a Cell Reference to Link a Cell to Another Sheet in Excel

Steps:

• Type the Equal Sign (=) in the formula bar in the cell you want.

• Go to the respective sheet (i.e., New York) you want to reference a cell from, then select the Total Sale sum amount cell (i.e., F13) as reference.

• Hit Enter.

Repeat for other cells and sheets.

Read More: How to Link Data in Excel from One Sheet to Another

Method 3 – Utilizing the Copy Paste Feature to Link a Cell to Another Sheet in Excel

Steps:

• Select the cell you want to link from.
• Right-click on the cell (i.e., F13).
• Select Copy (from the options).

• Go to the sheet (i.e., Copy and Paste) where you want to link the cell.
• Right-click on the destination cell (i.e., C5) in that sheet.
• The Context Menu appears.
• Select Paste Special.
• Select Paste Link (from Other Paste Options).

• The Total Sale value appears in the cell as shown in the following image.

• Repeat the process for other cells and links.

Read More: How to Reference Cell in Another Excel Sheet Based on Cell Value

Method 4 – Using the Name Box to Link a Cell to Another Sheet

Step 1:

• Assign a name (i.e., NY_Total_Sale) for New York to cell F13 using the Name Box. Repeat for other cells you need to link.

• Go to the Formulas tab and select Name Manager (from the Defined Names section) to check your names.

• The Name Manager window pops up and you can find all the assigned names in the workbook.

• Go to any worksheet and type =NY… to insert the sum value from the New York sheet.
• You’ll see assigned names as selectable options. Select the option you need.

• The sum of the Total Sale (for New York) value appears in the cell.

• Repeat the process for other cells.

Method 5 – Using the HYPERLINK Function

The syntax of the HYPERLINK function is

link_location; path to the cell you want to jump.

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

Steps:

• We entered the sheet names in the cells in column B (B5:B7).
• Paste the following formula the destination cell (i.e., C5):

 “#'”&B5&”‘!F13″= link_location

B5=[friendly_name]

• Press Enter and drag the Fill Handle down to make the other hyperlinks appear in cells C6 and C7.

• Click on a hyperlink to check if it works.

• Excel will point you to the cell you needed.

Method 6 – Applying the INDIRECT Function

The syntax of the INDIRECT function is

ref_text; reference in the form of text.

[a1]; a boolean indication for A1 or R1C1 style reference [Optional]. The default option represents TRUE=A1 style.

Steps:

• Use the following formula in the result cell (i.e., C5).

The cell reference for the sum of Total Sale is in F13 for all three sheets, and B5 represents the sheet name from where the data will be fetched.

• Hit Enter and drag the Fill Handle down.

Read More: How to Link Sheets in Excel with a Formula

Method 7 – Using the Drag and Drop Method

Steps:

• Place the cursor at the edge of a cell’s (i.e., F13) border and wait until the entire selection icon appears.

• Right-click on the mouse so the Excel shows the cell number under the cursor.

• Holding the right-click, press Alt and drag the cursor to the destination sheet (where you want to insert the link). After moving closer to the destination sheet, Excel selects it.

• Place the cursor where you want the link (i.e., C5 in the Drag and Drop Sheet).
• Release the right-click, and a Context Menu appears.
• Select the Create Hyperlink Here option.

• This will insert the cell’s link in the Drag and Drop sheet’s C5 cell.

• Repeat the process to insert the links of all required cells in the sheet.

Download the Excel Workbook

Related Articles

• How to Link Two Sheets in Excel
• How to Link Sheets to a Master Sheet in Excel
• How to Link a Table in Excel to Another Sheet

<< Go Back To Excel Link Sheets | Linking in Excel | Learn Excel