Users can create internal hyperlinks using and named ranges in Excel 2022

Inhaltsverzeichnis Show

How to Open the Insert Hyperlink Dialog Box Using the Ribbon
Add a Hyperlink to a Web Page
Add a Hyperlink to an Excel File
How to Create a Bookmark to the Same Worksheet

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.

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

1. Select a cell in one sheet that you want to create a hyperlink to another sheet, and click Insert > Hyperlink. See screenshot:

2. In the Insert Hyperlink dialog box, please do as follows:
(1) Click the Place in This Document button in the Link to box;
(2) Select one sheet that you want to hyperlink to in the Or select a place in this document box;
(3) Enter the text you want to display for the hyperlink in the Text to display;
(4) If you want to hyperlink to specific data in the sheet, please specify the cell in the Type the cell reference.

3. 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:

(1) List all opening workbooks; (2) List all sheets of active workbook;

(3) Show the total number of sheets.

Full Feature Free Trial 30-day!

Create 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 utility, you can quickly create a hyperlink for each worksheet in one worksheet quickly.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!

1. Click Kutools Plus> Worksheet > Create List of Sheet Names. See screenshot:

2. In the Create List of Sheet Names dialog box, specify the settings as follows (see screenshot above):
(1) Please check the Contains a list of hyperlinks option in the Sheet Index Styles section;
(2) Type a name for the new worksheet into the Specify sheet name for Sheet Index box;
(3) Specify the position for the new Index sheet from the Insert the Sheet Index in drop down list;

3. Click the Ok button. And then it will add a new sheet and lists all worksheet names with hyperlinks for navigating to related worksheets. See screenshot below:

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.

Create multiple hyperlinks to all workbooks/files in one folder

Kutools for Excel’s Filename List utility can batch add multiple hyperlinks to all files or one type of files in a certain folder, such as create hyperlinks to all workbooks, to all word documents, to all text files, etc.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!

1. Click Kutools Plus > Import / Export > Filename List.

2. In the opening Filename List dialog box, please (1) specify the folder whose workbooks/files you will create hyperlinks to; (2) check the Specify option and then type the xlsx into below box; (3) check the Create hyperlinks option; (4) and click the Ok button. See screenshot above:

And now multiple hyperlinks are created and linked to all workbooks (.xlsx files) in the specified folder. See screenshot:

Demo: create hyperlinks to another worksheets or workbooks

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

For removing multiple hyperlinks in a selected range, Kutools for Excel’s Delete Hyperlinks utility can help you archive with just one click. This utility can also delete all hyperlinks in active sheet, selected sheets, or active workbook with just one click. Full Feature Free Trial 30-day!

No ratings yet. Be the first to rate!

Ever wondered how to add hyperlinks, bookmarks, or mailto links in Excel? The answers are right here.

The following steps apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011 and Excel Online.

First, let's clarify what we mean with each term.

A hyperlink provides a way to open a web page by selecting a cell in a worksheet. It's also used in Excel to provide quick and easy access to other Excel workbooks.

A bookmark creates a link to a specific area in the current worksheet or to a different worksheet within the same Excel file using cell references.

A mailto link is a link to an email address. Selecting a mailto link opens a new message window in the default email program and inserts the email address into the To line of the message.

In Excel, both hyperlinks and bookmarks are intended to make it easier to navigate between areas of related data. Mailto links make it easier to send an email message to an individual or organization. In all cases:

No matter which type of link is created, it is created by entering the necessary information in the Insert Hyperlink dialog box.
As with links in web pages, links in Excel are attached to anchor text located in a worksheet cell.
Adding this anchor text before opening the dialog box simplifies the task of creating the link, but it can also be entered after the dialog box is open.

The key combination to open the Insert Hyperlink dialog box is Ctrl+K on a PC or Command+K on a Mac.

In an Excel worksheet, select the cell that will contain the hyperlink.
Type a word to act as anchor text such as "Spreadsheets" or "June_Sales.xlsx" and press Enter.
Select the cell with the anchor text a second time.
Press and hold the Ctrl key (in Windows) or the Command key ⌘ (on Mac).
Press and release the letter K key to open the Insert Hyperlink dialog box.

How to Open the Insert Hyperlink Dialog Box Using the Ribbon

In an Excel worksheet, select the cell that will contain the hyperlink.
Type a word to act as anchor text such as "Spreadsheets" or "June_Sales.xlsx" and press Enter.
Select the cell with the anchor text a second time.
Select Insert. (In Excel 2011 for Mac go to the Insert menu.)
Select Hyperlink or Link > Insert Link in the Links group. The Insert Hyperlink dialog box opens.

Here's how to set up a hyperlink to jump to a web page or to an Excel file.

Add a Hyperlink to a Web Page

Open the Insert Hyperlink dialog box using one of the methods outlined above.
Select the Existing File or Web Page tab.
In the Address line, type a full URL address.
Select OK to complete the hyperlink and close the dialog box.

The anchor text in the worksheet cell is blue in color and underlined to indicate it contains a hyperlink. Whenever it is selected, it will open the designated website in the default browser.

Add a Hyperlink to an Excel File

Note: This option is not available in Excel Online.

Open the Insert Hyperlink dialog box.
Select the Existing File or Web Page tab.
Select Browse for file to open the Link to file dialog box.
Browse to find the Excel file name, select the file, and select OK. The file name is added to the Address line in the Insert Hyperlink dialog box.
Select OK to complete the hyperlink and close the dialog box.

The anchor text in the worksheet cell changes to blue in color and is underlined to indicate it contains a hyperlink. Whenever it is selected, it will open the designated Excel workbook.

A bookmark in Excel is similar to a hyperlink except that it is used to create a link to a specific area on the current worksheet or to a different worksheet within the same Excel file.

While hyperlinks use file names to create links to other Excel files, bookmarks use cell references and worksheet names to create links.

How to Create a Bookmark to the Same Worksheet

The following example creates a bookmark to a different location in the same Excel worksheet.

Type a name in a cell that will act as the anchor text for the bookmark and press Enter.
Select that cell to make it the active cell.
Open the Insert Hyperlink dialog box.
Select the Place in This Document tab (or select the Place in this document button in Excel Online).
In the Type the cell reference text box, enter a cell reference to a different location on the same worksheet, such as "Z100."
Select OK to complete the bookmark and close the dialog box.

The anchor text in the worksheet cell is now blue in color and underlined to indicate that it contains a bookmark.

Select the bookmark and the active cell cursor moves to the cell reference entered for the bookmark.

Creating bookmarks to different worksheets within the same Excel file or workbook has an additional step. You'll also identify the destination worksheet for the bookmark. Renaming worksheets can make it easier to create bookmarks in files with a large number of worksheets.

Open a multi-sheet Excel workbook or add additional sheets to a single sheet file.
On one of the sheets, type a name in a cell to act as the anchor text for the bookmark.
Select that cell to make it the active cell.
Open the Insert Hyperlink dialog box.
Select the Place in This Document tab (or select the Place in this Document button in Excel Online).
Enter a cell reference in the field under Type in the cell reference.
In the Or select a place in this document field, select the destination sheet name. Unnamed sheets are identified as Sheet1, Sheet2, Sheet3 and so on.
Select OK to complete the bookmark and close the dialog box.

The anchor text in the worksheet cell is now blue in color and underlined to indicate that it contains a bookmark.

Select the bookmark and the active cell cursor moves to the cell reference on the sheet entered for the bookmark.

Adding contact information to an Excel worksheet makes it easy to send an email from the document.

Type a name in a cell that will act as the anchor text for the mailto link and press Enter.
Select that cell to make it the active cell.
Open the Insert Hyperlink dialog box.
Select the E-mail Address tab (or select the Email Address button in Excel Online).
In the Email address field, enter the email address of the person who will receive the email. This address is entered in the To line of a new email message when the link is selected.
Under the Subject line, enter the subject for the email. This text is entered into the subject line in the new message. This option is not available in Excel Online.
Select OK to complete the mailto link and close the dialog box.

The anchor text in the worksheet cell is now blue in color and underlined to indicate it contains a hyperlink.

Select the mailto link and the default email program opens a new message with the address and subject text entered.

When you no longer need a hyperlink, you can remove the link information without removing the text that served as the anchor.

Position the mouse pointer over the hyperlink to be removed. The arrow pointer should change to the hand symbol.
Right-click on the hyperlink anchor text to open the context menu.
Select Remove Hyperlink.

The blue color and the underline should is removed from the anchor text to indicate that the hyperlink has been removed.

Thanks for letting us know!

Tell us why!