Skip to main content

Create a hyperlink to another worksheet in the same workbook

Author: Tech Support Last Modified: 2025-04-14

Microsoft Excel is a versatile powerhouse for data organization and analysis, and one of its most valuable features is the ability to create hyperlinks. Hyperlinks enable you to effortlessly navigate between various worksheets within the same workbook, enhancing accessibility and user-friendliness. In this comprehensive guide, we'll delve into creating, editing, and removing hyperlinks in Excel, with a primary focus on interconnecting worksheets within the same workbook.

A screenshot showing how to create a hyperlink to another worksheet in Excel

Create a hyperlink to another sheet in Excel

Edit a hyperlink in Excel

Remove a hyperlink in Excel


Video: Create a hyperlink to another worksheet in the same workbook


Create a Hyperlink to another sheet in Excel

Creating hyperlinks to link other sheets in Excel is a valuable skill for seamless navigation between different worksheets in the same workbook. Here are four methods to create a hyperlink in Excel.

Create a hyperlink to another sheet by using the Hyperlink command

You can create a hyperlink to another worksheet in the same workbook by employing Excel's built-in "Hyperlink command". Here's how to do it:

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

Here I selected cell "A3" in the "Index" sheet.

A screenshot showing how to select a cell in Excel for hyperlink creation

Step 2: Navigate to the Insert tab and click Link

A screenshot showing the Insert tab and Link option in Excel

Step 3: In the Insert Hyperlink dialog box, please do as follows:

1. Click the "Place in This Document" button in the left "Link to" box.

2. Click on the desired worksheet in the "Or select a place in this document" box to set it as the destination for your hyperlink; here I selected the "Sales" sheet.

3. Enter the cell address in the "Type the cell reference" box if you want to hyperlink to a specific cell in the chosen sheet Sales; Here I entered cell "D1".

4. Enter the text you want to display for the hyperlink in the "Text to display "box; Here I input "Sales".

A screenshot of the Insert Hyperlink dialog box in Excel with the Place in This Document option selected

5. Click "OK".

Result

Now cell "A3" in the "Index" sheet has a hyperlink to the specified cell "D1" in the "Sales" sheet within the same workbook. You can hover over the hyperlink and click on it to go to the specified cell D1 in Sales sheet.

A gif showing the hyperlink creation in Excel and the result of linking to cell D1 in the Sales sheet

Quickly create hyperlinks to each worksheet in one sheet with Kutools

To create individual hyperlinks to each worksheet within the same workbook, the conventional approach requires the repetitive creation of separate hyperlinks for each worksheet, a time-consuming and labor-intensive task. However, with "Kutools for Excel"'s "Create List of Sheet Names "utility, you can quickly create a hyperlink for each worksheet in one worksheet, significantly reducing manual effort and streamlining the process.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

After downloading and installing Kutools for Excel, select "Kutools Plus "> "Worksheet " > "Create List of Sheet Names". In the "Create List of Sheet Names" dialog box, please do as follows.

    1. In the "Sheet Index Styles" section, check the "Contains a list of hyperlinks "option; (Here, you can also create buttons to link to other sheets as you need.๏ผ‰
    2. In the "Specify sheet name for Sheet Index" box, type a name for the new worksheet where will the hyperlinks will be located;
    3. In the "Insert the Sheet Index in" drop-down list, specify the position for the new Index sheet;
    4. Click "OK".

A screenshot showing the Create List of Sheet Names dialog box with options selected for hyperlinks

Result

Now hyperlinks to each worksheet are inserted in the newly-created "Index" sheet. You can click on any of the hyperlinks to quickly navigate to other worksheets.

A screenshot showing the Index sheet with hyperlinks to each worksheet created in Kutools for Excel

Tip: To use the "Create List of Sheet Names" feature, you should install "Kutools for Excel" first, please click to download Kutools for Excel.

Create a hyperlink to another sheet by using the HYPERLINK Function

With the "HYPERLINK" function, you also can create a hyperlink to another sheet within the same workbook. Clicking on the cell with the "HYPERLINK function" will take you to the specified sheet.

Step 1: Click on the cell where you want to create the hyperlink

Here I selected cell "A3" in the "Index" sheet.

A screenshot showing cell A3 in the Index sheet where the HYPERLINK function will be applied to create a hyperlink

Step 2: Enter the HYPERLINK formula

Type the "HYPERLINK "formula below and press "Enter" key.

=HYPERLINK("#Sales!D1", "Sales data")
Formula explanation:
  • "#Sales!D1": The destination of the hyperlink. In this case, it is a reference to a specific cell (cell "D1") within the sheet named "Sales".
  • "Sales data": The text that will be displayed for the hyperlink. In this formula, it will appear as the clickable link text "Sales data".
Result

Now the formula creates a hyperlink with the text "Sales data" in cell "A3" of the "Index" sheet. When you click on it, it will take you to cell "D1" in the "Sales" sheet within the same workbook.

A gif showing the result of clicking the HYPERLINK function link 'Sales data' in cell A3 of the Index sheet to navigate to cell D1 in the Sales sheet

ย 

Create a hyperlink to another sheet by using the Drag-and-Drop Method

Excel's "drag-and-drop" feature provides a quick way to establish hyperlinks within the same workbook. To illustrate the process, we have provided a step-by-step "GIF" below.

A gif showing the drag-and-drop process of creating a hyperlink to another sheet in Excel

Note: Before using this method, you must save the workbook first, as this technique is not effective in unsaved, newly created workbooks
Step-by-Step Descriptions:

1. Select the hyperlink destination cell in a sheet. Here I selected cell "D1" in the "Sales" sheet.

A screenshot showing the destination cell D1 in the Sales sheet before creating a hyperlink

2. Point to one of the cell borders and press the "right mouse" button and hold it.

3. Press the "Alt" key, and drag the cell onto the other sheetโ€™s tab. Here I selected the "Index" sheet.

4. Once the other sheet is activated, release the "Alt" key, and keep dragging the cell to the place where you want to insert a hyperlink. Here I selected cell "A3" in the "Index" sheet to insert the hyperlink.

5. Release the "right mouse" button. In the popping-up menu, click "Create Hyperlink Here".

A screenshot showing the right-click menu with the 'Create Hyperlink Here' option after dragging a cell to another sheet in Excel

Result

Now a hyperlink will appear in cell "A3" in the "Index "sheet, with the text from cell" D1" in the "Sales" sheet. When you click on it, it will take you to cell D1 in the Sales sheet within the same workbook.

A gif showing the result of clicking the hyperlink in cell A3 of the Index sheet to navigate to cell D1 in the Sales sheet

ย 


A screenshot of the Navigation Pane in Kutools for Excel displaying hyperlinks to all sheets in the workbook

Navigation Pane:

List hyperlinks to each sheet

One click to effortlessly navigate through your Excel workbooks and worksheets using the Navigation Pane feature of Kutools for Excel.

  • ๐Ÿ“˜ List all opening workbooks
  • ๐Ÿ“„ List all sheets of the active workbook
  • ๐Ÿ“Š Show the total number of sheets

๐Ÿš€ Kutools for Excel: Your Time-Saving Excel Companion


Edit a Hyperlink in Excel

After creating a hyperlink, you may need to modify it to change the link destination, link text or adjust its format. In this section, we will show you two methods to edit a hyperlink.

Change the link destination/link text

To modify the destination or text of an existing hyperlink, please do as follows:

Step 1: Right-click on the hyperlink and select Edit Hyperlink from the drop-down menu

A screenshot of the Edit Hyperlink option in Excel

Step 2: In the popping-up Edit Hyperlink dialog, please do as follows:

You can make the desired changes to the "link text" or "link location" or both. For example, I want to change the link destination to "C1" in the "Expenses" sheet, and change the link text to "Expenses".

1. Click on the "Expenses" sheet in the "Or select a place in this document" box.

2. Enter cell" C1 "in the "Type the cell reference" box.

3. Enter the text "Expenses" in the "Text to display" box.

A screenshot of the Edit Hyperlink dialog showing changes to link text and destination in Excel

4. Click "OK".

Result

Now the link destination and link text are modified successfully.

A screenshot of the modified hyperlink showing updated link text and destination in Excel

Tip: To edit a hyperlink created by using the HYPERLINK function, select the cell containing the Hyperlink formula and modify the arguments accordingly.

Modify the hyperlink format

Excel hyperlinks are initially displayed with a traditional underlined blue formatting by default. To modify the default format of a hyperlink, follow these steps:

Step 1: Click on the cell containing the hyperlink.
Step 2: Navigate to the Home tab and locate the Styles group.
    • Right-click on "Hyperlink" and select "Modify" to change the format of hyperlinks that have not been clicked.
    • Or right-click on "Followed Hyperlink" and select "Modify" to adjust the formatting of hyperlinks that have been clicked.

A screenshot of the Modify Hyperlink option in Excel

ย 

Step 3: In the popping-up "Style" dialog box, click Format.

A screenshot of the Style dialog box in Excel for modifying hyperlink format

Step 4: In the Format Cells dialog, modify the hyperlink alignment, font, and fill color as you need

Go to the "Alignment"tab, or the "Font" tab, or the "Fill" tab to make necessary changes. Here I changed the font of the hyperlink under the "Font" tab. Click "OK" to save the changes.

A screenshot of the Format Cells dialog showing font modifications for hyperlinks in Excel

Result

Now the format of the hyperlink has been changed successfully.

A screenshot of the modified hyperlink format in Excel

Tip: Changes made to "Hyperlink" or "Followed Hyperlink" styles are applied to all hyperlinks in the current workbook. You can't only change the format of individual hyperlinks.

๐ŸŒŸ 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, all word documents, or all text files, etc. Say goodbye to file chaos and hello to streamlined organization! ๐Ÿ’ช

A screenshot of Kutools for Excel Filename List utility in action

๐Ÿ“Š Kutools for Excel: Your Time-Saving Excel Companion ๐Ÿš€

Download Now

Remove a Hyperlink in Excel

Sometimes, you might want to remove hyperlinks without losing the formatting or content associated with it. In this section, we will explore two methods to help you achieve this goal.

Remove a hyperlink by using the Remove Hyperlink feature

Excel provides a straightforward way to remove a hyperlink using the "Remove Hyperlink" feature. Simply "right-click" on the cell containing the hyperlink and select "Remove Hyperlink" from the drop-down menu.

A screenshot of the Remove Hyperlink option in Excel

Now the hyperlink is removed while the link text is kept in the cell.

A screenshot showing the hyperlink removed but the link text still visible in Excel

Tips:
  • If you want to delete a hyperlink and the link text that represents it, you should right-click the cell that contains the hyperlink and select "Clear Contents" from the drop-down menu.
  • To remove hyperlinks from multiple cells, select the cells that contain hyperlinks and right-click on any cell of the selected cells and select "Remove hyperlinks" from the drop-down menu.

Easily remove hyperlinks without losing formatting using a smart tool

If you use the Remove Hyperlink feature to remove a hyperlink in Excel, the formatting of the hyperlink will be cleared. But we sometimes do need to keep the formatting, such as background color, font, size. Donโ€™t worry. The "Remove Hyperlinks Without Losing Formatting" feature of "Kutools for Excel" can remove the hyperlinks while keeping the formatting, no matter in "a selected range", "an active sheet", "multiple selected sheets", or "the entire workbook". In this case, we need to remove hyperlinks in selected cells while keeping the formatting.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

After downloading and installing Kutools for Excel, firstly select cells where you want to delete the hyperlinks, then click "Kutools" > "Link" > "Remove Hyperlinks Without Losing Formatting". Select "In selected Range" from the drop-down menu.

A screenshot of Kutools for Excel's Remove Hyperlinks Without Losing Formatting feature

Now all hyperlinks in selected cells are removed at once but the formatting is retained as needed.

A screenshot showing hyperlinks removed from selected cells while formatting is retained in Excel

Tip: To use the "Remove Hyperlinks Without Losing Formatting" feature, you should install "Kutools for Excel" first, please click to download Kutools for Excel.