How to add a hyperlink to another worksheet

In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it.

If you are a real Internet surfer, you know firsthand about the bright sides of hyperlinks. Clicking on hyperlinks you instantly get access to other information no matter where it is located. But do you know the benefits of spreadsheet hyperlinks in Excel workbooks? The time has come to discover them and start using this great Excel feature.

One of the ways you can put spreadsheet hyperlinks to good use is to create a table of contents of your workbook. Excel internal hyperlinks will help you to quickly jump to the necessary part of the workbook without hunting through multiple worksheets.

If you need to add a hyperlink in Excel 2016 or 2013, you can choose one of the following hyperlink types: a link to an existing or new file, to a web page or e-mail address. Since the subject of this article is creating a hyperlink to another worksheet in the same workbook, below you'll find out three ways to do that.

The first method of creating a hyperlink within one workbook is to use the Hyperlink command.

  1. Select a cell where you want to insert a hyperlink.
  2. Right-click on the cell and choose the Hyperlink option from the context menu.
    Click on Hyperlink in the context menu to open the Insert Hyperlink dialog box

    The Insert Hyperlink dialog window appears on the screen.

  3. Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
  4. Select the worksheet that you want to link to in the Or select a place in this document field.
  5. Enter the cell address in the Type the cell reference box if you want to link to a certain cell of another worksheet.
  6. Enter a value or name into the Text to display box to represent the hyperlink in the cell.
    Choose the worksheet and enter the cell address to add a hyperlink
  7. Click OK.
    Click OK to see a hyperlink in a cell

The cell content becomes underlined and highlighted in blue. It means that the cell contains the hyperlink. To check if the link works, just hover the pointer over the underlined text and click on it to go to the specified location.

Excel has a function named HYPERLINK that you can also use for creating links between spreadsheets in the workbook. If you are not good at entering Excel formulas immediately in the Formula bar, do the following:

  1. Select the cell to which you want to add a hyperlink.
  2. Go to Function Library on the FORMULAS tab.
  3. Open the Lookup & Reference drop-down list and choose HYPERLINK.
    Click on HYPERLINK in the Lookup & Reference drop-down menu to start entering the formula

    Now you can see the function name in the Formula bar. Just enter the following two HYPERLINK function arguments in the dialog window: link_location and friendly_name.

    In our case link_location refers to a specific cell in another Excel worksheet and friendly_name is the jump text to display in the cell.
    Fill in the link_location and friendly_name text boxes in the Function Arguments dialog window

    Note. It's not a must to enter friendly_name. But if you want the hyperlink to look neat and clear, I'd recommend to do it. If you don't type in friendly_name, the cell will display the link_location as the jump text.
  4. Fill in the Link_location text box.
    Tip. If you don't know what address to enter, just use the Select range icon to pick the destination cell.

    Click on the Select range icon to pick the destination cell

    The address displays in the Link_location text box.
    Click Enter or the Select range icon again to display the address in the Link_location text box

  5. Add the number sign (#) before the specified location.
    Note. It is crucial to type the number sign. It indicates that the location is within the current workbook. If you forget to enter it, the link won't work and an error will appear when you click on it.

    Add the number sign before the specified location to indicate that the location is within the same workbook

    When you move to the Friendly_name text box, you see the formula result in the bottom-left corner of the Function Arguments dialog.

  6. Enter Friendly_name that you want to display in the cell.
  7. Click OK.

    Click OK to insert a hyperlink into a cell and to see the hyperlink formula in the formula bar

Here you are! Everything is as it should be: the formula is in the Formula bar, the link is in the cell. Click on the link to check where it follows.

The quickest way of creating hyperlinks within one workbook is using the drag-and-drop technique. Let me show you how it works.

As an example, I'll take a workbook of two sheets and create a hyperlink in Sheet 1 to a cell in Sheet 2.

Note. Make sure that the workbook is saved because this method doesn't work in new workbooks.
  1. Select the hyperlink destination cell in Sheet 2.
  2. Point to one of the cell borders and right-click.
    Point to one of the cell borders and right-click to grab the cell
  3. Hold the button and go down to the sheet tabs.
    Right-click and hold down the button to drag the cell into the other worksheet
  4. Press the Alt key and mouse over the Sheet 1 tab.

    Having the Alt key pressed automatically takes you to the other sheet. Once Sheet 1 is activated, you can stop holding the key.

  5. Keep dragging to the place where you want to insert a hyperlink.
    Have the Alt key pressed to switch to the other sheet
  6. Release the right mouse button for the popup menu to appear.
  7. Choose Create Hyperlink Here from the menu.
    Release the right mouse button and choose Create Hyperlink Here from the popup menu

After you do that, the hyperlink appears in the cell. When you click on it, you'll switch to the destination cell in Sheet 2.

No doubt that dragging is the fastest way to insert a hyperlink into an Excel worksheet. It combines several operations into a single action. It takes you less time, but a bit more attention concentration than two other methods. So it's up to you which way
to go.

You can edit an existing hyperlink in your workbook by changing its destination, its appearance, or the text that is used to represent it.

As this article deals with hyperlinks between spreadsheets of the same workbook, the hyperlink destination in this case is a specific cell from another spreadsheet. If you want to change the hyperlink destination, you need to modify the cell reference or choose another sheet. You can do both, if necessary.

  1. Right-click the hyperlink you want to edit.
  2. Choose Edit Hyperlink from the popup menu.
     Right-click and choose Edit Hyperlink to open the Edit Hyperlink dialog box

    The Edit Hyperlink dialog box appears on the screen. You see that it looks the same as the Insert Hyperlink dialog and has the identical fields and layout.
    Make changes in the appropriate fields of the Edit Hyperlink dialog

    Note. There are, at least, two more ways to open the Edit Hyperlink dialog. You can press Ctrl + K or click on Hyperlink in the Links group on the INSERT tab. But don't forget to select the necessary cell before doing it.
  3. Update the information in the appropriate fields of the Edit Hyperlink dialog.
  4. Click OK and check where the hyperlink jumps to now.
    Note. In case you used Method 2 to add a hyperlink in Excel, you need to edit the formula to change the hyperlink destination. Select the cell that contains the link, and then place the cursor in the Formula bar to edit it.

Most of the time hyperlinks are shown as an underlined text of blue color. If the typical appearance of hyperlink text seems to you boring and you'd like to stand out of the crowd, go ahead and read below how to do it:

  1. Go to the Styles group on the HOME tab.
  2. Open the Cell Styles list.
  3. Right-click on Hyperlink to change the appearance of the hyperlink that was not clicked. Or right-click Followed Hyperlink if the hyperlink was activated.
  4. Choose the Modify option from the context menu.
    Right-click on Hyperlink or Followed Hyperlink and choose Modify to open the Styles dialog box
  5. Click on Formatin the Styles dialog box.
  6. Make the necessary changes in the Format Cells dialog window. Here you can change the hyperlink alignment and font or add fill color.
  7. When you are done, click OK.
  8. Make sure that all the changes are marked under Style includes in the Style dialog box.
  9. Press OK.
    Make the changes in the Format Cells dialog window and have them marked in the Style dialog box

Now you can enjoy a new individual style of the hyperlinks in your workbook. Pay attention that the changes you made affect all the hyperlinks in the current workbook. You can't change the appearance of a single hyperlink.

It will take you a few seconds and no efforts to delete a hyperlink from the worksheet.

  1. Right-click the hyperlink you want to remove.
  2. Choose the Remove Hyperlink option from the popup menu.
    Right-click on the cell and choose Remove Hyperlink to delete the hyperlink from the worksheet

The text remains in the cell, but it is no longer a hyperlink.

Note. If you want to delete a hyperlink and the text that represents it, right-click the cell that contains the link and choose the Clear Contents option from the menu.

This trick helps you to delete a single hyperlink. If you want to know how to remove multiple (all) hyperlinks from Excel worksheets at a time, follow the link to our previous blog post.

I hope that in this article you saw the simplicity and effectiveness of using internal hyperlinks in a workbook. Just a few clicks to create, jump and discover the massive content of complex Excel documents.

You may also be interested in

Category: Excel Tips

Table of contents

92 responses to "How to add a hyperlink to another worksheet"

  1. Arivanantham Saravanan says:

    good thank u

  2. Anonymous says:

    Very useful. Thank You.

  3. Chris says:

    but what if I insert a row before the destination cell? will the hyperlink self adjust to continue pointing to the originally intended destination cell, or would I need to manually adjust the hyperlink to point to the new destination?

  4. Anonymous says:

    HI i want to to find out the Cell references in the next sheet, Example in sheet1 i have data 1 to 10 and in Sheet2 the has the data 1 to 10. i need to know the matching cell referneces. in sheet 2 if 1 is at D9, the formulae should show the cell references D9. Is there any formulae like that.

  5. Paul says:

    Is there a way to connect a filter with the link? For example: I have a table of monthly sales. My hyperlink is the sales quantity for each month. My data that is feeding my table (where the hyperlink is connected) has all of my sales quantity by month. I would like to be able to click the hyperlink and have my source filter down based on the month. Is this possible with the hyperlink function?

  6. Nancy says:

    Hello, is there a way for the selected cell to go to the top of the page? Currently the hyperlink goes to a cell like A124 and that is displayed at the bottom of the page. How can I create a hyperlink that will go to that page and display A124 at the top of the page? Any assistance would be greatly appreciated!

  7. HH says:


  8. Justin says:

    When I use the first method to create HYPERLINK to another sheet, it says "cannot open the file specified".
    Little help here.. :)

  9. sarah says:

    I have been trying to hyperlink between two sheets in the same workbook, and your "Insert a link by cell drag-and-drop" method is the ONLY one that hasn't resulted in an "cannot open the specified file" error message. THANK YOU :)

  10. Robert says:

    I have never seen the tip to add the "#" before the target of the link to indicate that the link is in the current worksheet. It works exactly as I would want it to and is impervious to file name or location changes. In contrast, adding a link using the insert hyperlink dialogue (even when speciying that it is within the current workbook) results in a file name being inserted into the link which falls apart if either the filename, or its location, is changed.

    Thank you very much!!!

  11. Murali says:

    Very useful info. Thank You

  12. Idrees says:

    very very effective info thanks.

  13. suresh patel says:

    excellent posting. very useful

  14. prasanna s s says:

    how to connection data to another excel sheets
    for example
    now i have 10 data in book1 but now while i changed 15 data in book1.
    but it automatic changed in book2.

  15. Damian says:

    Excellent! I have, quite literally, found the missing link.

    It was all in the need for the #, which I've not seen documented before. Great job, thanks.

  16. g says:

    Can you hyperlink from one cell in one document to another cell in a separate document? Basically, I want to be able to click on a cell and it open the other document at the same place.

  17. G says:

    From a dropdown list of set values, (Yes and No) I am trying to link Yes to another tab
    When I hyperlink it, Yes and No both take you to the linked tab

  18. abhinand says:

    Does this hyperlink works only with the Sheet1 only or can we rename the sheet name ??

  19. Niall says:

    It seems pretty useless if the link has to go the file location even when linking to a different sheet in the same workbook. If that is the case, the links won't work if you send the file to someone who can't access your file location (ie.. external client). There should be a way to simply have the workbook refer directly to other cells or sheets in the same workbook without need to access the location where the file is stored on your computer. Am I missing something?

  20. vivek says:

    It's Awesome one !! Thanks

  21. Naomi says:

    Thank you so much! This information saved my bacon!

  22. ram says:

    Respected Sir,

    In our factory there is 3 types of product.
    So I will maintain the records in daily basis on EXCEL sheet.(Sheet1)

    Sheet 1: There is A type of product are manufacture on 16/09/2016 will be 2 Qty, after that 20/09/2016 will be 3 Qty.Total Qty of A= ,2+3=5
    How to link Total Qty of A in Sheet1 to the Total Qty of Sheet2
    1 16/09/16 A 2
    2 17/09/17 B 2
    3 18/09/18 C 3
    4 19/09/19 C 6
    5 20/09/20 A 3

    1 A
    2 B
    3 C

    How to link Sheet 1 of product to the sheet 2
    Just i will enter the Qty in Sheet1 (on Daily basis ), Automatically total Qty of products coming towords sheet2.
    Pls send me solution…

  23. ZAR ZAR says:


  24. Amanda says:

    Thank you you make it nice and easy to follow and very explicit diagrams!

  25. Andy says:

    "Insert a link by cell drag-and-drop"
    It WORKS!!!!
    Thank you SO much. Hours of work saved.

  26. Jamal says:

    i wanted to insert a hyperlink to a worksheet displaying the worksheet name dynamically, so if i rename the worksheet, the hyperlink display changes to the new name. is there a solution?

  27. RAJ says:

    100% working and helpful

  28. Brian says:

    Great...Thank a lot.

  29. Scott says:

    Hi I am trying to link a specific name on one tab and once i click on it find that specific name on the next tab is this possible?

  30. Hosea says:

    Seriously your site is helpful and very revealing.

  31. Mukunda says:


  32. Ma Thiri says:

    Thank you so much. I have no enough proficient in Excel Usage. Thank you for your helpful.

  33. John says:

    Truly fantastic. Thanks a million

  34. Pia says:

    I am Planning to put a print button in excel file.

    Scenario is:
    I am having one Excel file in that one Master Sheet and other 4 sheets are There.
    In Master Sheet I want four print buttons for these 4 other sheets.
    So that Print button Assigned for Sheet 1 in Master Sheet will print that Sheet 1 from Master sheet itself no need of going to sheet 1.
    Same for other sheets.

  35. Kids Parenting says:

    I like your blog Insert a hyperlink in Excel and really nice information about hyperlink types. Thanks for this information.

  36. Vishal says:

    Very helpful simple excel tips and hacks. Thank you so much!

  37. KERR says:

    The info about including the "#" was excellent and saved heaps of time and frustration.

  38. salman Javed says:

    Its very precise and composed article. much appreciated !!

  39. fogharty says:

    Late to the party.

    "Insert a link by cell drag-and-drop"

    This works, but is there a way to create the link automatically? If a cell in sheet four matches a cell in sheet one, can the Sheet 4 cell have a hyperlink to the Sheet 1 cell automatically?

    I can flag the duplicates with conditional formatting, but I just can't figure out the next step. Possibly a "IF/THEN statement?

  40. EMAURYAA says:


    Thanks For information but i want to link cell to worksheet of wps spreadsheet
    please let me know the information..

    thanks and regards
    Mauryaa Bhalerao

  41. carol duggan says:

    Thank you so much, it was clearly explained and easy to follow. Will be back again I'm sure.

  42. Sajid Raheem says:

    Quite useful.Thank you.

  43. Kinsen says:

    how to hyperlink with formula if the sheet names are in number?



    Hyperlink it make the task simple

    Thank you

  45. Exeq says:


  46. Linda L Rigsbee says:

    None of this is working for me. Directions don't match what I'm seeing and pictures don't show the #, so where does it go? I used to do this stuff in Excel all the time, but now that I have Windows 10 and office 16, it seems like everything is so difficult. Every time I look for instructions, the instruction pictures don't match what I'm seeing on screen.

  47. Phyo says:

    Thank you. I got many benefit from here.

  48. Rajesh Maharjan says:

    Can we hyperlink between the two cells of different sheet of same excel file matching the text of cell?

  49. Setu Saxena says:

    Good write up.
    Very very helpful.

  50. Zuu says:

    Thank you so much!
    It is very useful!

  51. Aneesh S says:

    Hi, I had split the single sheet to multiple sheet in excel and I tried to put hyperlink am not able to get the exact cell since there are multiple cell reference in one sheet.

  52. Asad Hanif Khan says:

    Its very informative, great job guys.

  53. Anita Bassignana says:

    Can I link one spreadsheet to another so when I input the date on the first spreadsheet it will automatically populates into the other?

  54. Ali says:

    Please can you attach a sample file.

    It makes learning faster

  55. Ann says:

    I am having an issue when adding the same hyperlink from one tab to another tab only after giving the original hyperlink a friendly name. The # and "" don't seem to help. Is there a solution to this issue? For now I have just changed it to two cells, one with the hyperlink and one with the name I want to use throughout the workbook. This works, but isn't very pretty.

  56. john says:

    hello someone their to help me?

    how to display the details in same sheet in excel?
    like for example
    sheet1: in column A1 (A1 144 and A2 145)when i click A1 144 or A2 145, the details will be display in D1 or etc. Same sheet..

    thank you

  57. Dave says:

    Great article! Very comprehensive, informative and well set out. It is an A-Z of Hyperlinks.
    Thanks, it helped me greatly.

  58. James Retnarajan says:

    Very useful and easy. Thank you.

  59. YOUNAS says:


  60. Sivakumar Pandiyan says:

    Good Thank You Ite Really Help full

  61. Marie says:

    Very helpful, thanks!

  62. Rashid says:

    Really helpful. Thanks a lot!

  63. Noli says:

    Very helpful. I've learned a lot from this article.

  64. Neil says:

    I hyperlinked cells in a column to different location in another sheet. I added another column in the 2nd sheet and now I want to include that column to be hyperlinked too. So is it a way that that I do it once for all cells?

  65. Pose says:

    This is good one. Is there formula when you press on the link and it jumps to another sheet and finds the specific text (or part of the text)?

    Thanks in advance

  66. Afzaal Ahmed says:

    I did not find the solution of my problem here, i need your help in this regard.
    i want to open sheets( also hidden sheet if possible) from the drop down menu of hyperlinks with single click without VBA.

  67. Sowmya says:

    Thank you :) , it's very useful .

  68. Simi says:

    How we know that what items are link and what are nt link in trial balance and balane sheet

  69. Ranjith says:

    Can we use this hyperlink with data filter option?

  70. ahmed sheikh ali says:

    very useful post thanks

  71. Arun Kank says:

    I have a data in one excel file in which for specific part no. i had different geometrical parameters like diam., length. Now i have another excel file in which i have to prepare inspection report so, is their any way if i put the specific part no. in inspection report so all geometrical parameters will come automatically in inspection report. plz revert.

  72. Bajeerao says:

    Please explain how to hyperlink a complete worksheet of the same file. Or how to hyperlink sheet 1 & sheet 2.
    Please guide

  73. Muhammad Ashikuzzaman says:

    Very helpful post, thanks.

  74. Kenneth Cheng says:

    Very helpful post, thanks!

  75. Neha says:

    Easy guide to understand, Thanks a lot, It worked for me !

  76. Joe says:

    Thanks for your example to make sure to use the "#" before a cell sheet reference!

  77. Shahid says:

    Is there anyway to open hyperlink function cell , without using mouse click.

  78. nicole says:

    in google sheet, you can get a link to a specific row of cells. is there a similar function in excel? an example would be that I want to reference a specific row of data from an excel doc into another document like a word file.

  79. ESWamm says:

    I am certain I am not the only person with this question, so hopefully it can be answered easily?

    I have varying reports that are compared at different intervals but all cross-reference each other. i.e., budget projections reports v actuals, receivables v outstanding etc.

    So when a comparison needs to be set up, can spreadsheet cells across varying workbooks/documents be hyperlinked into one spreadsheet/workbook to produce 'differences/results' reporting?

    Hope that's a clear question!? I apologize if its confusing - but I've been out of work 20 years and I'm trying to refresh all my OLD accounting skills used in much earlier versions of the software!

    Thank you!

  80. m.o.Dawood says:

    in column A i have the heading ITEM, column B the heading COST and in column C the heading PROFIT. in column G (in the same sheet) i just want to type the ITEM and it must display the ITEM and the COST and the PROFIT. is it possible for you to HELP PLEASE?(each heading must display in its own cell)

  81. Darren Fitch says:

    I am having an issue that I was hopping someone here can maybe answer or have a solution to. I use the hyperlink function to reference a specific cell within the same workbook, but on a different sheet or page (Sheet A). When on Sheet B & I click on the hyperlink that takes me exactly to the correct & corresponding cell on Sheet A.

    But then, when on sheet A, I will sort the data to fit my needs at any given time. The rub/ issue I am experiencing is that once I sort on Sheet A the hyperlink on Sheet B will now link to the old location and not update.

    On sheet B I click on hyperlink. Excel jumps over to Sheet A, Cell A4. On Sheet A I then sort the data in a column from ascending order to descending. The data on Sheet A updates and moves around accordingly. Then when I go back to Sheet B, and click on the same hyperlink as before, I am redirected to Sheet A, Cell A4. However, because of the sort function & data movement, the information is now inaccurate as the hyperlink in Sheet B is still refencing the old/ previous location (Sheet A, Cell A4) when instead it should direct me to the new location (lets just say... Sheet A, Cell A1) after the sort function has completed.

    Is there a way to embed a hyperlink that points to a different page & cell within the same workbook, that also updates if the "Sort & Filter" function is performed?

    Thanks! Fingers Crossed!

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)