Function Problems

How to Create Hyperlinks in Excel Using Values from Other Cells

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to generate and fill clickable hyperlinks across thousands of rows in an Excel worksheet by referencing and combining values from specific columns.

Product: Microsoft Excel 2021
Device & OS: not provided
Scenario: Creating dynamic internal links to specific cells (e.g., B4 through B20125) while displaying custom text that combines multiple column values like IDs.
Observed behavior: Requires a functional formula or VBA macro to concatenate cell references into a valid hyperlink and drag it down successfully without syntax or localization errors.

Before you start

Verify that your worksheet names and cell references exactly match your data, and note that formula parameters may require localized terminology depending on your system language.

Solution 1Recommended

Use the HYPERLINK and CELL Functions

Create dynamic links using a formula that references the destination cell address and combines cell values for the display text.

The most efficient way to generate dynamic links across multiple rows is by nesting the CELL function within the HYPERLINK function. This allows you to construct a clickable URL while dynamically pulling display text from your columns.

Select the target cell

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

Enter the formula

Type the HYPERLINK formula combining your target sheet and cell references. For example: =HYPERLINK("#" & CELL("address", 'Ibk-h-1932'!B4), 'Ibk-h-1932'!J4 & " + ID " & 'Ibk-h-1932'!B4). Press Enter to generate the link.

Fill the formula down

Select the cell containing your new hyperlink, click and hold the fill handle (the small square at the bottom-right corner), and drag it down to fill the formula through your desired rows (e.g., down to row 20125).

Localization Note: If you are using a non-English version of Excel, you must translate the 'address' parameter inside the CELL function. For example, use 'adresse' in the French version of Excel.

Solution 2

Use a VBA Script for Advanced Formatting

Apply a VBA macro to automatically generate links and apply advanced rich-text formatting to specific parts of the hyperlink text.

Efficient Spreadsheet Management

Easily Create Dynamic Hyperlinks in WPS Office

WPS Office Spreadsheet fully supports complex formulas, including the HYPERLINK and CELL functions, allowing you to seamlessly create dynamic links from other cell values. It is highly compatible with Microsoft Excel file formats and completely free to use.

1. Open your workbook: Launch WPS Spreadsheet and open your existing data file.
2. Input the formula: Select the target cell and enter your =HYPERLINK formula referencing the necessary columns.
3. Auto-fill the column: Press Enter, then simply double-click the fill handle to automatically copy the hyperlink formula down to the end of your dataset.

100% compatible with Microsoft Excel (.xlsx) formatsSupports advanced formulas and dynamic arraysLightweight, fast, and features a user-friendly interface

microsoft office alternative - wps office

Frequently Asked Questions

Why is my CELL function returning a #VALUE! error?

If your Excel is installed in a language other than English, the 'address' parameter within the CELL function must be localized. For instance, French Excel requires 'adresse' instead of 'address'. Update the text string to match your local language.

How do I link to another sheet using the HYPERLINK function?

To link to a cell on another worksheet, prepend the sheet name enclosed in single quotes and an exclamation mark to the cell reference. Ensure the entire reference is prefixed with a '#' symbol, formatted like this: =HYPERLINK("#'Sheet2'!A1", "Click Here").

Can I format part of the hyperlink text differently using a formula?

No, standard Excel formulas do not allow rich text formatting (such as bolding or changing the color of a single word) within the formula's output. To apply character-specific formatting, you must use a VBA script to generate the text and apply styles.

Excel & Data Problems