Comments on: 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. Continue reading →

Comments page 3. Total comments: 131

  1. Good Thank You Ite Really Help full

  2. THNX DEAR

  3. Very useful and easy. Thank you.

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

  5. 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

  6. 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.

  7. Please can you attach a sample file.

    It makes learning faster

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

  9. Its very informative, great job guys.

  10. 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.

  11. Thank you so much!
    It is very useful!

  12. Good write up.
    Very very helpful.

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

  14. Thank you. I got many benefit from here.

  15. 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.

  16. Thanks!!!

  17. Hyperlink it make the task simple

    Thank you

  18. Hi,
    how to hyperlink with formula if the sheet names are in number?

    Thanks.
    Kinsen

  19. Quite useful.Thank you.

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

  21. hey

    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

  22. 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?

  23. Its very precise and composed article. much appreciated !!

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

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

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

  27. 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.

  28. Truly fantastic. Thanks a million

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

  30. thankyou

  31. Seriously your site is helpful and very revealing.
    Thanks

  32. 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?

  33. Great...Thank a lot.

  34. 100% working and helpful

  35. 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?

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

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

  38. THANK YOU

  39. 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
    Sheet1.
    SR.NO DATE PRODUCT QTY
    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

    Sheet2.
    SR.NO PRODUCT TOTAL QTY
    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…

  40. Thank you so much! This information saved my bacon!

    1. Please say me solution

  41. It's Awesome one !! Thanks

  42. 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?

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

  44. 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

  45. Nice.

  46. 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.

    1. Nothing I have tried has worked.

  47. 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.

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

  49. excellent posting. very useful

  50. very very effective info thanks.

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 :)