How to Make a Pasted URL an Active Hyperlink in Excel
Question details
The user needs a method to convert a web URL that was pasted into a spreadsheet cell from plain text into an active, clickable hyperlink.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Pasting web addresses into a spreadsheet where they remain inactive and unclickable.
- Observed behavior
- The pasted URL appears as plain black text instead of automatically formatting as a blue, underlined hyperlink that opens a website.
Ensure that the cell's number format is set to 'General' rather than 'Text', as applying a strict text format can prevent the spreadsheet from automatically recognizing and converting URLs into active hyperlinks.
Use the F2 Key to Activate the Hyperlink
A quick manual method to force the application to re-evaluate the cell contents and recognize the plain text as a web link.
By entering the cell's edit mode and triggering a subtle change, you prompt the software's auto-format feature to step in and convert the text string into a working hyperlink.
Click on the cell that contains the plain text URL.
Press the F2 key on your keyboard to enter the cell's edit mode. Your cursor will appear at the end of the text.
Press the Spacebar once to add a space at the end of the URL.
Press the Enter key. The text should now be reformatted automatically as a blue, underlined active hyperlink.
Use the Hyperlink Insert Menu
A reliable way to manually assign a hyperlink to any selected text or cell, regardless of its current formatting.
Easily Manage Hyperlinks with WPS Spreadsheet
WPS Spreadsheet provides intuitive auto-formatting features that instantly recognize URLs and convert them to active hyperlinks, saving you time when organizing web data.
- 1. Open WPS Spreadsheet: Launch WPS Office and create a new spreadsheet or open your existing workbook.
- 2. Paste your web address: Select a cell and paste your URL. WPS Spreadsheet's smart AutoFormat will typically convert it into an active hyperlink immediately upon pressing Enter.
- 3. Use quick shortcuts: If a link remains inactive, simply right-click the cell, select 'Hyperlink', verify the address, and click OK to manually activate it.
Frequently Asked Questions
Why do my URLs paste as plain text instead of hyperlinks?
URLs can paste as plain text if you pasted them using 'Keep Text Only' or if the destination cell is formatted as 'Text'. Additionally, if the 'Internet and network paths with hyperlinks' option is disabled in your AutoCorrect settings, automatic linking will not occur.
How can I convert multiple plain text URLs into clickable links at once?
If you have a long list of inactive URLs, you can use the HYPERLINK formula. For example, if your plain text URL is in cell A1, type '=HYPERLINK(A1)' in an adjacent column and drag the fill handle down to convert the entire list.
How do I turn off automatic hyperlinks?
To stop URLs from automatically turning into clickable links, go to File > Options > Proofing, and click 'AutoCorrect Options'. Under the 'AutoFormat As You Type' tab, uncheck the box for 'Internet and network paths with hyperlinks'.
