How to add hyperlink in excel cell to another sheet

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.

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

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.

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.

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.

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."

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

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.

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.

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

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.

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."

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

Step 4. Browse and save the new file.

Step 5. Click "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."

Step 4. 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.

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?

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!

Trustpilot4.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.

Free Download

5,820,008 User

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.