Excel help for Hyperlinks

Question

I have an Excel workbook with over 200 sheets, and my first sheet is a summary page that totals all the amounts. I'm having trouble creating a hyperlink that links the cell name to the exact Excel sheet. For example, on my summary page, one of my cells is named "American Family Insurance" on Cell A13. I want it so that when I click the account name, it takes me to the exact Excel sheet that mentions "American Family Insurance," specifically to cell K5 on that sheet. How can I fix that?

Answer 1

Use a hyperlink (or the HYPERLINK function) that points directly to cell K5 on the target sheet.

Assuming the sheet that contains cell K5 for American Family Insurance is named American Family Insurance (or any other known sheet name), there are two main options.

Option 1 – Insert a hyperlink via the UI

1. Go to the summary sheet and select cell A13 (the cell that shows "American Family Insurance").
2. On the ribbon, select Insert > Link (or right‑click the cell and select Link, or press Ctrl+K).
3. In the Insert Hyperlink dialog:
   • Under Link to, select Place in This Document.
   • In the Or select a place in this document box, under Cell Reference, click the sheet that contains the American Family Insurance data.
   • In Type in the cell reference, enter K5.
4. In Text to display, make sure it shows American Family Insurance (or whatever text is in A13).
5. Select OK.

Now clicking A13 will jump directly to cell K5 on that sheet.

Option 2 – Use the HYPERLINK function in a formula

If the sheet name is known and fixed, enter a formula like this in A13 (or another cell):

=HYPERLINK("#'American Family Insurance'!K5","American Family Insurance")

Key points:

• #'American Family Insurance'!K5 is the link location (the # indicates a location inside the current workbook).
• The second argument is the friendly text shown in the cell.
• If the sheet name has spaces or non‑alphabetical characters, enclose it in single quotes '...'.

If each account name on the summary sheet exactly matches a sheet name, and the target is always K5, you can make this dynamic. For example, if A13 contains the text American Family Insurance, put this in another column (say B13):

=HYPERLINK("#'" & A13 & "'!K5", A13)

This will create a clickable link based on the sheet name stored in A13.

---

References:

• Work with links in Excel
• Create a link to a specific location in a workbook
• Create a custom link by using the HYPERLINK function
• HYPERLINK function
• Create or change a cell reference