How to create hyperlinks?

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)


-- 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


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