1 Microsoft Excel 2013 – Hyperlink to another Cell in another

Microsoft Excel 2013 – Hyperlink to another Cell in another Workbook

Suppose you want to link a cell’s details from one workbook to another. First you should

be sure those workbooks are located inside the same folder.

The amount that you put in the cell does not need to be the same as the cell you are

hyperlinking to. It can be the same or not because it is just a link to that specific cell in

another workbook.

The example for this tutorial is a workbook called Band which has a cell’s details that I

want to link to in a workbook called Expenses.

For this example I want the amounts to be the same in the cell that I am linking to, but it

does not have to be the same details. Remember, it is just a hyperlink.

The final example will show a workbook that has more than one worksheet.

Shown below the top workbook is called Expenses and the bottom one is called Band.

I want to link from Expenses (D7) to Band (G25) cell. Both cells are in yellow.

Since I want to link from the Expense workbook to a cell (G25 which is yellow) in the

Band workbook. Right mouse on the cell details in Expenses, then choose Hyperlink.

An Insert Hyperlink dialog box appears. Select the workbook called Band.

Once the Band workbook is selected click on the Bookmark button on right.

A Select Place in Document dialog box appears.

By default it will have A1 in the Type in the cell reference dialog box as shown below.

You need to type in the cell number you want to be linked to and that will appear when

clicked on. See next screen shot for exact details.

Here is what it will look like for our example by typing in G25 for the Cell Reference.

Make sure Band is selected on the bottom of dialog box. Click OK

You then will come back to the Insert Hyperlink dialog box, click OK.

Save both files & try out the hyperlink.

Now suppose the workbook you need to hyperlink to has more than one worksheet.

Shown below is the same workbook called Band that has 3 worksheets now, Band,

Chorus & Sports.

When you get to the step to Select Place in Document be sure to select the worksheet

and type in the cell number in the Cell Reference.