Hi,
Im Mudit and im new to this forum.
Can anyone tell me how i can hyperlink a cell in one sheet to a column in another sheet,
so that when i click the link it goes to that particular column and highlights it automatically???
Hi,
Im Mudit and im new to this forum.
Can anyone tell me how i can hyperlink a cell in one sheet to a column in another sheet,
so that when i click the link it goes to that particular column and highlights it automatically???
Hi and welcome to the board
Select the column - Insert Name Define
Then give a name to your selection
Go to the cell where you want the hyperlink
Select Insert Hyperlink - Select " Place in this document" and select the name you created.
Hyperlink → Link To (Place in this doucument) →select the sheet →type the cell reference, then click OK.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks