WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add hyperlink in excel cell to another sheet

July 21, 2022
4.9K Views

Excel's Insert Hyperlink dialogue box can be used to link to an existing file, a website, or a specific location within this document. Use the HYPERLINK feature as well.

In today's fast-paced world, quick access to relevant information is essential. Hyperlinking in Excel allows users to conveniently navigate between different sheets, charts, and files. This article provides a comprehensive step-by-step guide on how to create hyperlinks in Excel, catering to various scenarios and preferences.

Part 1:  Excel Hyperlink to Another Sheet in the Same Workbook (Good and Quick)

Effortlessly navigate between different sheets within the same workbook by mastering the art of hyperlinking. This section provides a straightforward, step-by-step guide on how to create hyperlinks in Excel, enabling swift access to related information without leaving your current worksheet.

Step 1: Open your Excel workbook and select the cell where you want to insert the hyperlink.

Step 2: Go to the "Insert" tab on the Excel ribbon and click on the "Hyperlink" button.

The Hyperlink dialog box


Step 3: In the "Insert Hyperlink" dialog box, select "Place in This Document" on the left-hand side.

Place in This Document


Step 4: A list of sheet names within your workbook will appear. Choose the sheet you want to link to.

Step 5: In the "Cell Reference" box, specify the target cell on the destination sheet, or you can leave it blank to link to the sheet without specifying a particular cell.

Step 6: Click "OK" to create the hyperlink. The selected cell in your current sheet is now linked to the target sheet.

Cell Reference box


Step 7: Test the hyperlink by clicking on the cell with the hyperlink. It should take you directly to the linked sheet.

Step 8: To edit or remove the hyperlink, right-click on the cell containing the hyperlink, and select "Edit Hyperlink" or "Remove Hyperlink" from the context menu.

Edit Hyperlink


Part 2:  Utilize hyperlinks in Excel charts and graphs to another worksheet 

Effortlessly navigate between different sheets within the same workbook by mastering the art of hyperlinking. This section provides a straightforward, step-by-step guide on how to create hyperlinks in Excel, enabling swift access to related information without leaving your current worksheet.

Step 1: Create your chart or graph in Excel by selecting the data and choosing the appropriate chart type.

choose chart type


Step 2: Right-click on the chart element (e.g., data point, bar, pie slice) that you want to link to another worksheet.

Step 3: From the context menu that appears, select "Hyperlink" or "Edit Hyperlink."

Edit Hyperlink


Step 4: In the "Insert Hyperlink" dialog box, choose "Place in This Document" on the left side.

Place in This Document tab


Step 5: A list of sheet names within your workbook will be displayed. Select the worksheet where you want the hyperlink to lead.

Step 6: In the "Cell Reference" box, specify the target cell on the destination worksheet (optional). Leave it blank to link to the entire worksheet.

Step 7: Click "OK" to create the hyperlink. The selected chart element is now linked to the target worksheet.

Cell Reference box


Step 8: Test the hyperlink by clicking on the chart element. It should take you directly to the linked worksheet.

Step 9: Repeat the process to add hyperlinks to other chart elements if needed.

Part 3:  Linking to an existing file in excel 

Need to incorporate information from an external file into your Excel workbook? Discover the process of linking to an existing file, allowing you to access vital data without cluttering your current spreadsheet.

Step 1: Open your Excel workbook and navigate to the cell where you want to insert the hyperlink.

Step 2: Go to the "Insert" tab on the Excel ribbon at the top of the window.

Step 3: Click on the "Hyperlink" button in the "Links" group.

Hyperlink tab


Step 4: In the "Insert Hyperlink" dialog box, select "Existing File or Web Page" on the left side.

Insert Hyperlink dialog box


Step 5: Click the "Browse" button to locate and select the file you want to link to. Alternatively, you can enter the file path or URL in the "Address" box.

Step 6: Add a friendly name for the hyperlink in the "Text to display" box (optional). This name will be visible in the cell.

Step 7: Click "OK" to create the hyperlink. The selected cell now contains a clickable link to the external file.

OK to create the hyperlink


Step 8: Test the hyperlink by clicking on the cell. It should open the linked file using the default associated application (e.g., Word, PDF reader).

Step 9: To edit or remove the hyperlink, right-click on the cell containing the hyperlink, and select "Edit Hyperlink" or "Remove Hyperlink" from the context menu.

Part 4: Linking to a New File in excel 

Create a clean and organized Excel workbook by linking to new files instead of embedding them. This section guides you through the steps to hyperlink to a new file, promoting efficiency and ensuring a well-structured document.

Here is step by step:

Step 1. Open new excel file select the cell where you want the hyperlink.

Step 2. Click "Insert" > "Hyperlink."

Insert tab


Step 3. Choose "Existing File or Web Page."

Choose Existing File or Web Page


Step 4. Browse and save the new file.

Step 5. Click "OK" to create the link.

OK to create the link.


Step 6. Test the link by clicking on the cell.

Step 7. Right-click to edit or remove the hyperlink.

Part 5: Creating an Email Address Hyperlink to another worksheet 

Facilitate communication and collaboration by adding email address hyperlinks to your Excel sheets. Learn how to create clickable links that open email clients, simplifying the process of reaching out to contacts from within your workbook.

Step 1. Type the email address (e.g., example@example.com) in the cell.

Step 2. Select the cell with the email address.

Step 3. Click "Insert" > "Hyperlink."

Insert hyperlink tab


Step 4. Choose "Email Address."

Choose Email Address


Step 5. Confirm the email address is correct.

Step 6. Optionally, add a friendly name for the hyperlink.

Step 7. Click "OK" to create the hyperlink.

OK to create the hyperlink.


Step 8. Test the link by clicking the cell.

Step 9. Right-click to edit or remove the hyperlink.

By following these easy steps, you can create clickable email address hyperlinks in Excel for quick communication.

Part 6: Why Use WPS Office?

WPS Office logo


While both Microsoft Excel and WPS Office Spreadsheet offer powerful features, we highly recommend using WPS Office for several compelling reasons:

1. Free: WPS Office is a free all-in-one office suite.

2. Compatibility: It ensures seamless compatibility with common document formats.

3. Features: WPS Office offers additional tools like resume assistants, smart forms, and more.

4. User-friendly Interface: Its interface is easy to use, similar to Microsoft Office.

By choosing WPS Office, you get a cost-effective, feature-rich, and easy-to-use alternative to traditional office suites. Experience the benefits firsthand by downloading WPS Office today!

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs about excel hyperlink to another sheet

Why is my hyperlink to another sheet not working in Excel?

If your Excel hyperlink to another sheet is not working:

1. Check the cell reference for accuracy.

2. Ensure the sheet name is correct.

3. Make sure the target workbook is open.

4. Verify the hyperlink format (e.g., "http://" or "#").

5. Check if the cell is unlocked on a protected sheet.

6. Try opening the linked file in a different instance.

7. Adjust Excel's security settings if needed.

8. Check cell formatting for clickable appearance.

9. Remove extra spaces in the hyperlink.

10. Ensure compatibility with Excel version and software.

How do you hyperlink on a Mac?

To create a hyperlink on a Mac:

Step 1. Select the text or object.

Step 2. Right-click and choose "Add Link" or "Hyperlink."

Step 3. Enter the URL or email address.

Step 4. Click "OK" to create the hyperlink.

Now, the text or object becomes a clickable link on your Mac.

How do you reference a cell in another sheet dynamically in Excel?

To reference a cell in another sheet dynamically in Excel, use this formula:

=INDIRECT("SheetName!CellReference")

Replace "SheetName" with the name of the sheet, and "CellReference" with the cell you want to refer to. The formula will update automatically if the referenced cell changes.

Summary

In conclusion, creating hyperlinks in Excel significantly improves data accessibility and productivity. This article has provided a comprehensive step-by-step guide covering various hyperlinking techniques, along with tips for effective usage. For a seamless experience, we recommend using WPS Office, which offers a user-friendly interface, extensive features, and excellent compatibility, enhancing your Excel workflow.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.