How to create hyperlinks?



0
How do I create a Hyperlink to open specific worksheet, within the excel workbook that I am working on?
Ex: If i click the text on my excel sheet saying, "Please refer to Sheet 2", i want it to link to Sheet 2 of my work book.

1 Answer(s)


0

-- HYPERLINK function

Creates a shortcut that opens a document, when you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file that is stored at link_location.

-- Syntax

HYPERLINK(link_location,display_name)


-- Steps
1) Go to Insert tab
2) Select Hyperlink option
3) Select Place in this Document
4) Choose the desired link location

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password