Document Editing Problems

How to Create Links to Locations in the Same Excel Worksheet

Maira Mehtab Oct 8, 2026 870 views

Question details

The user needs to create clickable links to jump directly to specific cells, headings, or bookmarks within a single Excel worksheet.

How to Create Links to Locations in the Same Excel Worksheet

Product: Excel
Device & OS: not provided
Scenario: Navigating a long spreadsheet, such as a lengthy price list, to find specific brands or products without excessive scrolling.
Observed behavior: The user wants to establish internal hyperlinks or utilize grouping features to quickly locate and jump to specific data sections.

Before you start

Before creating internal links, identify the exact target cells or define names for your data sections so you know exactly where each link should jump.

Solution 1Recommended

Use the Insert Link Feature to Jump to a Cell

Use Excel's built-in Link function to map a clickable text or image to a specific cell reference within the same document.

This is the most direct way to create a navigation menu or index at the top of a long spreadsheet.

Select the anchor text or object

Click on the cell containing the text, or select the picture/shape you want to turn into a clickable hyperlink.

Open the Insert Hyperlink menu

Right-click your selection and choose 'Link' from the context menu, or navigate to the 'Insert' tab on the top ribbon and click 'Link'.

Choose the internal document location

In the Insert Hyperlink dialog box, click on 'Place in This Document' from the left-hand panel.

Select the target destination

Under 'Type the cell reference', enter the exact cell (e.g., C50), or select a pre-defined bookmark or heading from the list below. Click 'OK' to save.

Use the Insert Link Feature to Jump to a Cell

Pro Tip: Defining a name for your target cell before linking to it ensures your hyperlink remains accurate even if you add or delete rows later.

Solution 2

Organize Data Using Outline and Grouping

Instead of creating multiple links, you can group related rows or columns to expand and collapse sections of your worksheet.

WPS Spreadsheet Solution

Easily Navigate Long Spreadsheets with WPS Office

WPS Spreadsheet provides powerful and intuitive tools for managing large datasets. You can quickly add internal hyperlinks or group your data to streamline navigation, just like in Microsoft Excel.

1. Open Your Spreadsheet: Launch WPS Spreadsheet and open the document containing your long data list.
2. Select the Link Anchor: Click the cell, text, or shape you want to use as your clickable link.
3. Insert the Hyperlink: Go to the 'Insert' tab, click 'Hyperlink', choose 'Place in This Document', and input your target cell reference or defined name.

Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Create internal links, bookmarks, and defined names with a familiar interface.Free, lightweight, and fast office suite for all your daily spreadsheet tasks.Built-in grouping and outlining tools to manage massive data lists effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my internal hyperlink point to the wrong cell after I insert rows?

If you link directly to a specific cell reference (like A50) and then insert rows above it, the data shifts but the hyperlink still points to A50. To fix this, use the 'Define Name' feature to name the target cell, and link to that Defined Name instead of the static cell reference.

How do I remove a hyperlink without deleting the text inside the cell?

Right-click the cell containing the hyperlink and select 'Remove Hyperlink' from the context menu. The clickable link will be deleted, but your text and its formatting will remain intact.

Can I link to a specific location in a different worksheet within the same file?

Yes. When you open the Insert Hyperlink dialog box and select 'Place in This Document', you will see a list of all the sheets in your workbook. Click the sheet you want to jump to, and specify the cell reference for that specific sheet.

Document & File Issues