Create a Hyperlink to an Excel Table or Data Range
Question details
Create a hyperlink to an Excel table or data range that remains useful when rows are inserted.

- 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.
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.
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.
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.
On the Table Design tab, enter a short name such as SalesTable in the Table Name box. Use a name without spaces.
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.
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.
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 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. Open the workbook: Open WPS Spreadsheets and use File > Open to select your workbook.
- 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. 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. 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.

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.




