Create a Clickable Website Link in an Excel Cell
Question details
Create a clickable website link from an address stored 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.
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.
Create a Link with the HYPERLINK Function
Use a formula when the website address is already stored in another cell.
Click an empty cell next to the address, such as B2 if the URL is in A2.
Type =HYPERLINK(A2,"Open website") and press Enter. Replace A2 with the cell containing your URL if necessary.
Click the displayed Open website link to open the address in your browser.

Insert a Website Link Manually
Use Excel's link command when you want to add a hyperlink to a selected cell.
Enable Automatic Links for Typed Website Addresses
Use automatic formatting to make newly entered website addresses clickable.
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. Open your spreadsheet: Open WPS Spreadsheets and select the workbook containing your website addresses.
- 2. Select an empty cell: Click an empty cell next to the URL, such as B2 when the address is in A2.
- 3. Enter the link formula: Type =HYPERLINK(A2,"Open website") and press Enter.
- 4. Test the link: Click Open website to open the URL. Drag the fill handle down to create links for additional rows.

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.




