Forum Discussion
tlwellborn
Aug 09, 2021Copper Contributor
Hyperlinks
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 poi...
HansVogelaar
Aug 09, 2021MVP
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.