Function Problems

How to Create an Excel Cell Link That Opens a Specific Worksheet

Ayan Masood Oct 15, 2026 869 views

Question details

The user needs to create a clickable link inside a cell that directly navigates to a specific worksheet and cell reference within the same workbook.

How to Create an Excel Cell Link That Opens a Specific Worksheet

Product: Excel
Device & OS: not provided
Scenario: Navigating quickly between multiple worksheets in a large workbook without manually scrolling through sheet tabs.
Observed behavior: The user wants to set up a functional cell hyperlink using a formula that targets an internal sheet.

Before you start

Ensure that the target worksheet you want to link to already exists in your current workbook. Make a note of the exact spelling of the worksheet name, as incorrect names will result in a broken link.

Solution 1Recommended

Use the HYPERLINK Function for Standard Sheet Names

Apply a simple HYPERLINK formula to create a link to a worksheet whose name contains no spaces or special characters.

The HYPERLINK function allows you to build dynamic navigation links directly inside your cells. When linking to a location within the same file, the target address must be preceded by a pound sign (#).

Select the cell

Click on the cell where you want the clickable link to appear.

Enter the HYPERLINK formula

Type =HYPERLINK("#SheetName!A1","Display Text"). Replace 'SheetName' with the exact name of your target sheet (e.g., #Andreas!A1) and 'Display Text' with the text you want users to see in the cell (e.g., "Andreas").

Apply the formula

Press Enter. The cell will now display as a standard underlined link that takes you to cell A1 of the designated worksheet when clicked.

Use the HYPERLINK Function for Standard Sheet Names

Pound Sign Requirement: The pound sign (#) is strictly required at the beginning of the sheet reference string to indicate that the destination is located within the current workbook.

Solution 2

Use the HYPERLINK Function for Sheet Names with Spaces

Modify the HYPERLINK formula with single quotes when your target worksheet name contains spaces or special characters.

Seamless Spreadsheet Management

Create Hyperlinks Easily with WPS Spreadsheet

WPS Spreadsheet fully supports the HYPERLINK function and offers a highly intuitive visual tool to manage internal links, making workbook navigation effortless without needing to memorize formulas.

1. Open your workbook: Launch WPS Spreadsheet and open your multi-sheet workbook.
2. Select a cell: Click on the specific cell where you want to place the navigation link.
3. Open the Hyperlink menu: Go to the 'Insert' tab on the top ribbon and click on 'Hyperlink', or simply press the keyboard shortcut Ctrl + K.
4. Choose the internal destination: In the dialog box that appears, select 'Place in this document' from the left sidebar.
5. Finalize the link: Select your target worksheet from the list, optionally specify the exact cell reference, type your display text at the top, and click 'OK'.

Easily create internal workbook links to seamlessly navigate massive datasets.Fully compatible with Microsoft Excel (.xlsx, .xls) files, including all formulas and referencing rules.Built-in visual hyperlink insertion tool for a code-free linking experience.Lightweight software that ensures smooth performance even with heavy calculations.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my HYPERLINK formula return a 'Reference isn't valid' error?

This error typically occurs if the target worksheet name is misspelled, the worksheet has been deleted or renamed, or you forgot to include the pound sign (#) at the very beginning of the internal cell reference.

Can I link to a specific range instead of a single cell?

Yes, you can specify a range in the formula, such as =HYPERLINK("#Sheet2!A1:B10","Go to Range"). Clicking the link will open the target sheet and highlight the entire specified range.

How do I edit or remove a hyperlink from a cell?

If you used the HYPERLINK function, simply click the cell (click and hold to avoid triggering the link) and edit or delete the formula in the formula bar. If you used the Insert Hyperlink feature, right-click the cell and select 'Remove Hyperlink' from the context menu.

Excel & Data Problems