Function Problems

How to Create a Dynamic Hyperlink in Excel Using Cell Values

WPS Content Manager Sep 28, 2026 870 views

Question details

The user needs to create an internal hyperlink in Excel where both the destination address and the displayed text are dynamically generated using values from other cells, and the formula can be dragged down a column.

How to Create a Dynamic Hyperlink in Excel Using Cell Values

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating reusable dynamic links across a spreadsheet that automatically adjust row references and text output when filled down.
Observed behavior: The user requires the correct HYPERLINK syntax combined with the CELL function to generate functional internal links, with considerations for localized Excel versions.

Before you start

Verify the exact name of the target worksheet and identify the specific cells you want to reference for both the hyperlink destination and the display text.

Solution 1Recommended

Use the HYPERLINK and CELL Functions

Combine the HYPERLINK function with the CELL function to dynamically generate a link address and friendly display text based on cell references.

Excel's HYPERLINK function requires two arguments: a link location and a friendly name (the text displayed in the cell). By nesting the CELL function within HYPERLINK, you can dynamically extract the exact address of a target cell. Appending a '#' symbol before the address ensures Excel treats it as an internal link to the current workbook.

Select the Destination Cell

Click on the cell where you want the dynamic hyperlink to appear.

Enter the Formula

Type the formula combining HYPERLINK and CELL. For example: =HYPERLINK("#"&CELL("address",'Ibk-h-1932'!B4),'Ibk-h-1932'!J4&" + ID "&'Ibk-h-1932'!B4). This formula points to cell B4 on the 'Ibk-h-1932' sheet, and uses the value in J4 plus the ID in B4 as the display text.

Fill the Formula Down

Press Enter to apply the formula. Then, click the small square at the bottom-right corner of the cell and drag it down to apply the dynamic hyperlink to subsequent rows.

Localization Requirements: If you are using a non-English version of Excel, you may need to translate function names (e.g., HYPERLINK and CELL) and parameters (e.g., "address" becomes "adresse" in French). Additionally, ensure your list separators match your regional settings (such as using a semicolon instead of a comma).

Manage Dynamic Spreadsheets with WPS Office

Easily Create Dynamic Hyperlinks in WPS Spreadsheet

WPS Office provides full support for advanced functions like HYPERLINK and CELL, allowing you to build highly dynamic, interactive spreadsheets. It works exactly like Microsoft Excel, so you can apply the same formulas seamlessly.

1. Open Your Workbook: Launch WPS Spreadsheet and open the document where you want to add the dynamic links.
2. Input the Formula: Select the target cell and enter your =HYPERLINK and CELL combination formula.
3. Drag to Fill: Press Enter, then use the fill handle at the bottom right of the cell to drag the formula down the column effortlessly.

100% compatibility with Microsoft Excel (.xlsx) file formats and formulasFull support for advanced lookup, reference, and text functionsFree, lightweight, and fast-loading spreadsheet applicationFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my HYPERLINK formula return an error?

This is often caused by regional settings. If you are in a region that uses a comma as a decimal separator, you must use semicolons (;) instead of commas (,) to separate the arguments in your formula. Also, ensure your function names and parameters like "address" are translated to your local language.

What is the purpose of the '#' symbol in the formula?

The '#' symbol is a required prefix in Excel and WPS Spreadsheet when creating internal hyperlinks. It tells the program that the link destination is located within the current workbook rather than an external website or file.

Can I link to a different worksheet dynamically?

Yes. By including the sheet name in the cell reference inside the CELL function (e.g., CELL("address", 'SalesData'!A1)), the hyperlink will successfully redirect the user to that specific sheet and cell when clicked.

Excel & Data Problems