Function Problems

How to Create Clickable URLs from Page Numbers in Excel

John WilsonJohn Wilson Nov 11, 2026 870 views

Question details

Generate clickable links in a column by combining a base URL with page numbers located in another column.

How to Create Clickable URLs from Page Numbers in Excel
Product
Excel
Device & OS
not provided
Scenario
Creating a list of dynamic hyperlinks based on existing cell data.
Observed behavior
The user needs to append values from one column (page numbers) to a specific website address to produce clickable URLs in an adjacent column.
Before you start

Ensure your base URL is formatted correctly (starting with https:// or http://) and ends with the appropriate character, such as a forward slash, before appending the cell data.

Solution 1Recommended

Use the HYPERLINK Function with the Ampersand (&) Operator

Combine the HYPERLINK formula with the ampersand (&) operator to dynamically append cell values to a base URL text string.

The HYPERLINK function allows you to create active shortcuts in a cell, while the ampersand operator (&) connects a static text string (your base URL) with dynamic cell references (your page numbers).

1
Select the target cell

Click on the cell where you want the clickable link to appear (for example, E1).

2
Enter the HYPERLINK formula

Type the formula =HYPERLINK("https://bobsmadeupsite.org/"&D1), replacing the URL with your base address and D1 with your specific reference cell containing the page number.

3
Apply the formula

Press the Enter key to generate the clickable hyperlink in the cell.

4
Fill down the column

Click the small square (fill handle) at the bottom-right corner of the selected cell and drag it down to apply the formula to the rest of your list.

Use the HYPERLINK Function with the Ampersand (&) Operator
Customizing the Link Text: You can add a friendly display name to the link by utilizing the second argument of the function. For example: =HYPERLINK("https://bobsmadeupsite.org/"&D1, "Go to Page "&D1).
Advanced Formulas Made Easy

Create Dynamic Hyperlinks Seamlessly in WPS Spreadsheet

WPS Spreadsheet fully supports advanced functions like HYPERLINK, allowing you to easily concatenate data and generate clickable URLs. It is a robust, lightweight alternative that handles large datasets effortlessly.

  1. 1. Open your workbook: Launch WPS Spreadsheet and open the document containing your page numbers.
  2. 2. Select the destination cell: Click on the empty cell next to your page number column where the URL should be generated.
  3. 3. Insert the formula: Enter the formula combining your base URL text string and cell reference using the HYPERLINK function.
  4. 4. Apply to all rows: Drag the fill handle down to instantly populate the entire column with active web links.
Fully compatible with Microsoft Excel formulas, functions, and .xlsx file formats.Lightweight interface that runs smoothly on Windows, Mac, Linux, iOS, and Android.Includes a comprehensive library of built-in functions for quick data manipulation.Free to use for everyday spreadsheet and data management tasks.
microsoft office alternative - wps office

Frequently Asked Questions

How do I make the link display a friendly name instead of the full URL string?

Use the optional friendly_name argument in the HYPERLINK function. The syntax is =HYPERLINK(link_location, [friendly_name]). For example: =HYPERLINK("https://website.com/"&D1, "Click Here").

Why are my generated hyperlinks returning a #NAME? error?

This usually happens if the base URL text inside the formula is not wrapped in double quotation marks. Ensure your formula looks like =HYPERLINK("https://website.com/"&D1) instead of lacking quotes.

Can I combine text from multiple columns into a single clickable URL?

Yes, you can use multiple ampersands (&) to connect various cells into one URL string. For example: =HYPERLINK("https://website.com/"&A1&"/page/"&B1) will combine the domain, the value in A1, the text '/page/', and the value in B1.