Document Editing Problems

Create a Hyperlink to an Excel Table or Data Range

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

Create a hyperlink to an Excel table or data range that remains useful when rows are inserted.

Create a Hyperlink to an Excel Table or Data Range
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants a worksheet link that navigates to a table or range instead of relying on a fixed cell address.
Observed behavior
A hyperlink to a specific cell can become unreliable when rows are inserted.
Before you start

Open the workbook and identify the data you want to link to. If the data is already an Excel table, click inside it and check its name on the Table Design tab.

Solution 1Recommended

Link to a defined name that refers to an Excel table

Use a table-backed defined name as the hyperlink destination so the referenced range expands with the table.

1
Create or select the table

Select the data and choose Insert > Table. Confirm the range and whether the table has headers, then click OK. If the data is already a table, click any cell in it.

2
Name the table

On the Table Design tab, enter a short name such as SalesTable in the Table Name box. Use a name without spaces.

3
Define the destination

Choose Formulas > Define Name. Enter a different name, such as SalesDestination, and set Refers to to =SalesTable[#All], replacing SalesTable with your table's name. Click OK.

4
Insert the hyperlink

Select the cell where you want the link, then choose Insert > Link or Hyperlink. Select Place in This Document, choose SalesDestination under Defined Names, and click OK.

5
Test the link

Click the new hyperlink and confirm it takes you to the table. Add a row within the table and test the link again.

Link to a defined name that refers to an Excel table
What the reference includes: The [#All] reference includes the table's headers, data, and totals row if present. The defined name and table name must be different.
Work with spreadsheet links in WPS

Link to a Named Range in WPS Spreadsheets

Use a named range as an internal hyperlink destination in WPS Spreadsheets, then test the link after editing the data.

  1. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your workbook.
  2. 2. Name the range: Select the target cells, then choose Formulas > Define Name. Enter a name such as SalesDestination and confirm the referenced range.
  3. 3. Create the link: Select the cell for the link and choose Insert > Hyperlink. Select the option to link to a place in the document, then select the named range as the destination.
  4. 4. Check the destination: Click the hyperlink to verify that it opens the intended range. After inserting rows, check the range under Formulas > Name Manager and test the link again.
Create internal links to named data rangesOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why use a defined name instead of a cell address?

A defined name gives the hyperlink a named destination. When it refers to an Excel table using a reference such as =SalesTable[#All], the destination follows the table's range as it expands.

Can I link to a range that is not an Excel table?

Yes. Select the cells, choose Formulas > Define Name, and create a name for the range. Then use Insert > Link > Place in This Document and select that name. Check the range after inserting rows, especially at its boundaries.

What does Table[#All] include?

It includes the table's header row, data rows, and totals row if one is displayed. Replace Table with your actual table name when entering the reference in Formulas > Define Name.

What if the table name does not appear in the hyperlink dialog?

Create a separate defined name that refers to the table, such as =SalesTable[#All]. Then select that defined name under Place in This Document when inserting the hyperlink.