I have created some hyperlinks in an Excel sheet (from an cell to another).
The hyperlinks do not seem to adjust themselves whenever rows are added/deleted from the sheet.
I there a way to enforce automatic adjustmest of such hyperlinks ?
I have created some hyperlinks in an Excel sheet (from an cell to another).
The hyperlinks do not seem to adjust themselves whenever rows are added/deleted from the sheet.
I there a way to enforce automatic adjustmest of such hyperlinks ?
Hi [email protected]
If you name the cell the hyperlink will remain locked to it.
Select the destination cell, then goto the toolbar and select 'Insert' then 'Name' then 'Define' and input a name for the cell then 'OK'
Open the 'Edit Hyperlink' for the cell where the hyperlink exists and below the 'Defined Names' you will see the names for your cells, select the required name and OK.
Your Hyperlink will remain locked to that cell
Cheers
JT
You can also use the hyperlink function
=HYPERLINK(CELL("address",Sheet2!E14),"Test")
This will ensure the cell referenced will addjust as rows/columns are added or removed.
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks