hyperlinks to sheets within workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1684108%22%20slang%3D%22en-US%22%3Ehyperlinks%20to%20sheets%20within%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1684108%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20in%20a%20spreadsheet%20that%20someone%20else%20created%2C%20so%20not%20sure%20how%20hyperlinks%20were%20originally%20created.%26nbsp%3B%20There%20are%20hyperlinks%20under%20Cell%20Reference%2C%20which%20are%20the%20actual%20names%20of%20the%20tabs%2C%20but%20there%20are%20also%20links%20under%20Defined%20Names%20and%20they%20appear%20to%20link%20to%20a%20particular%20cell%20within%20the%20sheet.%26nbsp%3B%20Is%20there%20a%20way%20to%20get%20rid%20of%20those%20options%3F%26nbsp%3B%20I%20am%20trying%20to%20clean%20up%20the%20spreadsheet%20and%20minimize%20potential%20for%20error%20for%20future%20users.%26nbsp%3B%20Also%2C%20I'm%20concerned%20about%20anyone%20changing%20the%20names%20of%20the%20tabs%2Fsheets%20and%20breaking%20the%20hyperlinks%20to%20that%20tab.%26nbsp%3B%20Is%20linking%20to%20the%20Cell%20Reference%20a%20dynamic%20hyperlink%20or%20how%20do%20I%20need%20to%20create%20a%20dynamic%20hyperlink%3F%26nbsp%3B%20Is%20there%20an%20easy%20way%20to%20create%20them%3F%26nbsp%3B%20I'm%20not%20real%20savvy%20with%20Excel.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kimwagner_0-1600439018828.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219559iCC188950E8ECD1AC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kimwagner_0-1600439018828.png%22%20alt%3D%22kimwagner_0-1600439018828.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1684108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1684186%22%20slang%3D%22en-US%22%3ERe%3A%20hyperlinks%20to%20sheets%20within%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1684186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798849%22%20target%3D%22_blank%22%3E%40kimwagner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20view%20the%20definition%20of%20the%20defined%20names%20by%20clicking%20on%20Name%20Manager%20in%20the%20Defined%20Names%20group%20of%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EIf%20you%20delete%20a%20defined%20name%2C%20a%20hyperlink%20referring%20to%20it%20won't%20work%20anymore.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20want%20users%20to%20change%20the%20name%20of%20worksheets%2C%20click%20Protect%20Workbook%20in%20the%20Protect%20group%20of%20the%20Review%20tab%20of%20the%20ribbon.%20You%20can%20specify%20a%20password%20if%20you%20like%20(don't%20forget%20it!)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Working in a spreadsheet that someone else created, so not sure how hyperlinks were originally created.  There are hyperlinks under Cell Reference, which are the actual names of the tabs, but there are also links under Defined Names and they appear to link to a particular cell within the sheet.  Is there a way to get rid of those options?  I am trying to clean up the spreadsheet and minimize potential for error for future users.  Also, I'm concerned about anyone changing the names of the tabs/sheets and breaking the hyperlinks to that tab.  Is linking to the Cell Reference a dynamic hyperlink or how do I need to create a dynamic hyperlink?  Is there an easy way to create them?  I'm not real savvy with Excel.

kimwagner_0-1600439018828.png

 

3 Replies

@kimwagner 

You can view the definition of the defined names by clicking on Name Manager in the Defined Names group of the Formulas tab of the ribbon.

If you delete a defined name, a hyperlink referring to it won't work anymore.

 

If you don't want users to change the name of worksheets, click Protect Workbook in the Protect group of the Review tab of the ribbon. You can specify a password if you like (don't forget it!)

@Hans Vogelaar 

 

Thank you for your response.  Do you think it's preferable to use the Cell Reference type hyperlink as opposed to Defined Names?  Also, does there need to be a value in the Type the cell reference field?

 

kimwagner_0-1600440905006.png

 

@kimwagner 

Named ranges can be a handy way to clarify what a cell means. If you use named ranges, it makes sense to use them in hyperlinks too. Apart from that, there is no special reason to prefer one above the other.

 

If you create a hyperlink to another sheet and leave the Cell Reference box empty, Excel will automatically enter A1 as cell reference.