How to Create Clickable URLs from Page Numbers in Excel
Question details
Generate clickable links in a column by combining a base URL with page numbers located in another column.

- 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.
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.
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).
Click on the cell where you want the clickable link to appear (for example, E1).
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.
Press the Enter key to generate the clickable hyperlink in the cell.
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.

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. Open your workbook: Launch WPS Spreadsheet and open the document containing your page numbers.
- 2. Select the destination cell: Click on the empty cell next to your page number column where the URL should be generated.
- 3. Insert the formula: Enter the formula combining your base URL text string and cell reference using the HYPERLINK function.
- 4. Apply to all rows: Drag the fill handle down to instantly populate the entire column with active web links.

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.




