Create hyperlink in a cell to another sheet in the same workbook

Do you know how to create a hyperlink in a cell in one sheet to a specific cell in another worksheet in the same workbook? By doing this, you can quickly navigate to specific cell of another sheet by clicking the hyperlink in Excel. The hyperlinks will help you switch to the other worksheet and locate specific cell quickly. Here are two tricky ways to create hyperlinks to specific cell in another worksheet in the same workbook.

Create hyperlinks to specific cell in another worksheet with Hyperlinks

Create one hyperlink to each worksheet in one sheet with Kutools for Excel

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

arrow blue right bubbleCreate hyperlinks to specific cell in another worksheet with Hyperlinks

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Actually, we can make hyperlinks to other worksheets with Hyperlinks command easily.

Step 1: Select a cell in one sheet that you want to create a hyperlink to another sheet.

Step 2: Click the Hyperlink button under Insert tab or right click your mouse and choose Hyperlink as follows:

Step 3: In the Insert Hyperlink dialog box:

blue-dotClick the Place in This Document button in the Link to box;

blue-dotSelect one sheet that you want to hyperlink to in the Or select a place in this document box.

blue-dotEnter the text you want to display for the hyperlink in the Text to display.

Iblue-dotf you want to hyperlink to specific data in the sheet, please specify the cell in the Type the cell reference.

Step 4: Click OK.

Then the selected cell is added a hyperlink to the specific cell of specific worksheet in the same workbook. See the following screen shot:


arrow blue right bubbleCreate one hyperlink to each worksheet in one sheet with Kutools for Excel

If you want to create one hyperlink to each worksheet in one sheet of the same workbook, you may need to create a hyperlink for each worksheet again and again. But with Kutools for Excel's Create List of Sheet Names tool, you can quickly create a hyperlink for each worksheet in one worksheet quickly.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 45 days. Get it Now.

Step 1: Click the Enterprise >> Worksheet Tools >> Create List of Sheet Names…

Step 2: In the Create List of Sheet Names dialog box, specify the settings, and click OK.

Then it will add a new sheet and lists all worksheet names with hyperlinks for navigating to related worksheets. See screenshot:

Kutools for Excel's Create List of Sheet Names tool can create a list of all worksheet names of the active workbook in a new worksheet, which contains hyperlinks or macro buttons for quickly navigate to other worksheets. Click to know more…


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

+7#uruser2013-12-11 11:36
this link was very useful . very well written and simple to use
Reply | Reply with quote | Quote
+3#ali2014-02-12 23:15
thank you :-)
i really liked it
Reply | Reply with quote | Quote
+1#monkeydude2014-03-14 13:33
hey..

i want to create a link to an Excel file on a website. however, i want the link to direct it to a specific sheet

how do i go about this

thanks for the help
Reply | Reply with quote | Quote
+1#jaishiv meena2014-03-14 14:18
thanks you so much ,very useful.
Reply | Reply with quote | Quote

Add comment


Security code
Refresh