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 2. Total comments: 131

  1. 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)

  2. 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!

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

    1. Hello!
      I hope you have studied the recommendations in the tutorial above. It contains answers to your question.
      All links that are possible are described with the article above. A link to a Word document is also possible.
      You can learn more about hyperlink in Excel in this article on our blog.

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

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

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

  7. Very helpful post, thanks!

  8. Very helpful post, thanks.

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

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

  11. very useful post thanks

  12. Can we use this hyperlink with data filter option?

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

  14. Thank you :) , it's very useful .

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

  16. Hello
    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

  17. Hii
    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?

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

  19. Really helpful. Thanks a lot!

  20. Very helpful, thanks!

  21. Good Thank You Ite Really Help full

  22. THNX DEAR

  23. Very useful and easy. Thank you.

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

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

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

  27. Please can you attach a sample file.

    It makes learning faster

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

  29. Its very informative, great job guys.

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

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

  32. Good write up.
    Very very helpful.

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

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

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

  36. Thanks!!!

  37. Hyperlink it make the task simple

    Thank you

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

    Thanks.
    Kinsen

  39. Quite useful.Thank you.

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

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

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

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

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

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

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

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

  48. Truly fantastic. Thanks a million

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

  50. thankyou

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