can somebody help me on how to interlink two work sheet of the same workbook using HYPERLINK please?
Answers
Answer:
Add a hyperlink from the context menu
The first method of creating a hyperlink within one workbook is to use the Hyperlink command.
Select a cell where you want to insert a hyperlink.
Right-click on the cell and choose the Hyperlink option from the context menu.
Click on Hyperlink in the context menu to open the Insert Hyperlink dialog box
The Insert Hyperlink dialog window appears on the screen.
Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
Select the worksheet that you want to link to in the Or select a place in this document field.
Enter the cell address in the Type the cell reference box if you want to link to a certain cell of another worksheet.
Enter a value or name into the Text to display box to represent the hyperlink in the cell.
Choose the worksheet and enter the cell address to add a hyperlink
Click OK.
Click OK to see a hyperlink in a cell
The cell content becomes underlined and highlighted in blue. It means that the cell contains the hyperlink. To check if the link works, just hover the pointer over the underlined text and click on it to go to the specified location.