Hyperlinks

%3CLINGO-SUB%20id%3D%22lingo-sub-2628327%22%20slang%3D%22en-US%22%3EHyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2628327%22%20slang%3D%22en-US%22%3E%3CP%3EOS%3A%20Windows%2010%3C%2FP%3E%3CP%3EExcel%3A%20365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20a%20hyperlink%20to%20a%20place%20in%20my%20document.%26nbsp%3B%20I%20do%20not%20want%20it%20to%20have%20a%20specific%20cell%20reference%20because%20I%20may%20add%20rows%20to%20the%20page%20where%20my%20hyperlink%20points%20to.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%2C%20I%20have%20assigned%20a%20hyperlink%20(place%20in%20this%20document)%20on%20sheet%20named%20%22work%20orders%22%20and%20it%20points%20to%20cell%20C7%20on%20sheet%20named%20%22dates%22.%26nbsp%3B%20This%20works%20if%20I%20never%20add%20rows%20to%20the%20destination%20sheet.%26nbsp%3B%20If%20I%20add%203%20rows%20above%20row%207%20on%20sheet%20%22dates%22%2C%20then%20my%20hyperlink%20is%20off%20by%203%20rows.%26nbsp%3B%20I%20do%20have%20unique%20headings%20to%20each%20area%20I%20want%20the%20hyperlink%20to%20be%20set%20to.%26nbsp%3B%20i.e.%20%22Work%20Order%205%22%2C%20%22Work%20Order%2012%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20assign%20a%20hyperlink%20to%20a%20unique%20name%20within%20the%20sheet%20and%20it%20will%20always%20point%20to%20%22Work%20Order%205%22%20no%20matter%20which%20row%20it%20is%20located%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2628327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

OS: Windows 10

Excel: 365

 

I would like to add a hyperlink to a place in my document.  I do not want it to have a specific cell reference because I may add rows to the page where my hyperlink points to. 

For instance, I have assigned a hyperlink (place in this document) on sheet named "work orders" and it points to cell C7 on sheet named "dates".  This works if I never add rows to the destination sheet.  If I add 3 rows above row 7 on sheet "dates", then my hyperlink is off by 3 rows.  I do have unique headings to each area I want the hyperlink to be set to.  i.e. "Work Order 5", "Work Order 12". 

 

Can I assign a hyperlink to a unique name within the sheet and it will always point to "Work Order 5" no matter which row it is located?

1 Reply

@tlwellborn 

Select C7 on sheet Dates.

Click in the address box on the left hand side of the formula bar and replace the cell address with a name, for example WorkOrder5 (don't use spaces in the name) and press Enter.

Switch to the sheet with the Work Orders sheet and right-click the cell with the hyperlink.

Select Edit Hyperlink... from the context menu.

You should now see a section Defined Names in the 'Or select a place in this document' tree, with the name that you created under it.

Select it, then click OK.