Create hyperlink in a cell to another worksheet in Excel 2013

Creating a hyperlink in a cell is an efficient way to quickly navigate to specific cell of another worksheet in Excel 2013. The hyperlinks are also helpful to switch to the other worksheet and locate specific cell.

The best example of hyperlinks could be creating index pages in the first excel worksheet which is linked with all other worksheets.

Select a cell from where you want to create a hyperlink to another sheet

1. Open the Hyperlink dialog-box from "Insert" tab

Alternatively, we can use right click button or keyboard shortcuts (Alt+NI or Ctrl+K)

2. Click on "Place in This Document" button on the left, since we want to link the cell with another cell in the worksheet.

3. The options given on the right side needs to be used:

Text to display: Enter the text that needs to be displayed in the cell

Type the cell reference: Enter the cell address where you need to reach in another worksheet (default A1)

Or select a place in this document: Click on the worksheet where you want to hyperlink the cell

4. Click OK

The hyperlink will be created with specified text appearing in blue colour with an underline.

Remember: After you follow a hyperlink text to its destination, the color of its text changes from the traditional blue to a dark shade of purple.