Function Problems

Create a Clickable Website Link in an Excel Cell

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 869 views

Question details

Create a clickable website link from an address stored in an Excel cell.

Create a Clickable Website Link in an Excel Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet column contains website addresses, and the user wants to open them without adding a separate button.
Observed behavior
A cell displays a clickable link that opens the website address.
Before you start

Check that the source cell contains a valid website address, such as https://www.example.com. If you plan to use a formula, choose an empty cell for the link.

Solution 1Recommended

Create a Link with the HYPERLINK Function

Use a formula when the website address is already stored in another cell.

1
Select an empty cell

Click an empty cell next to the address, such as B2 if the URL is in A2.

2
Enter the formula

Type =HYPERLINK(A2,"Open website") and press Enter. Replace A2 with the cell containing your URL if necessary.

3
Open the website

Click the displayed Open website link to open the address in your browser.

Create a Link with the HYPERLINK Function
Use the formula for more rows: Drag the fill handle down from the formula cell to create links for other addresses in the column.
Create links in WPS Spreadsheets

Turn Website Addresses into Links in WPS Spreadsheets

Use the HYPERLINK function in WPS Spreadsheets to create clickable labels from URLs already stored in your worksheet.

  1. 1. Open your spreadsheet: Open WPS Spreadsheets and select the workbook containing your website addresses.
  2. 2. Select an empty cell: Click an empty cell next to the URL, such as B2 when the address is in A2.
  3. 3. Enter the link formula: Type =HYPERLINK(A2,"Open website") and press Enter.
  4. 4. Test the link: Click Open website to open the URL. Drag the fill handle down to create links for additional rows.
Create clickable website links from existing cell values.Copy a link formula down a column for multiple addresses.Open and edit Microsoft Excel XLSX and XLS files.Work in a familiar spreadsheet interface.
QA img-9

Frequently Asked Questions

Do I need a button to open a website from Excel?

No. You can click a hyperlink directly in a cell. Use =HYPERLINK(A2,"Open website") to create one from an address in A2.

How do I show the URL itself as the link text?

Enter =HYPERLINK(A2,A2) in an empty cell. The formula uses the address in A2 as both the destination and the displayed text.

Why is my typed website address not clickable?

Automatic hyperlink formatting may be disabled. In Excel for Windows, check File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and enable Internet and network paths with hyperlinks.

Can I create links for an entire column of addresses?

Yes. Enter a HYPERLINK formula next to the first address, then drag the formula cell's fill handle down to apply it to the remaining rows.