Office Settings & Configuration

Fix Excel Not Converting URLs to Clickable Hyperlinks Automatically

Nimra Malik Sep 27, 2026 870 views

Question details

The user needs to re-enable or force the spreadsheet software to automatically convert pasted web addresses (URLs) into clickable hyperlinks, as the feature has stopped working.

How to Fix Excel Not Converting URLs to Clickable Hyperlinks Automatically

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pasting or typing internet and network paths into spreadsheet cells.
Observed behavior: Excel leaves the pasted URL as plain text and fails to convert it into an active, clickable hyperlink, despite the feature working correctly in Microsoft Word.

Before you start

Before changing your settings, ensure you are not using the 'Paste Special > Plain Text' command, as this intentionally strips out automatic hyperlink formatting when inserting data.

Solution 1Recommended

Enable AutoFormat As You Type for Hyperlinks

Adjust the Excel Proofing settings to ensure URLs are automatically replaced with clickable links when you type or paste them.

Hyperlink conversion is controlled by Excel's AutoCorrect features. If this gets turned off accidentally, Excel will treat all web addresses as standard text.

Open Excel Options

Launch Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.

Navigate to AutoCorrect Options

In the Excel Options dialog box, select 'Proofing' from the left sidebar, then click the 'AutoCorrect Options...' button.

Enable the Hyperlink Setting

Switch to the 'AutoFormat As You Type' tab. Check the box next to 'Internet and network paths with hyperlinks'.

Save and Test

Click 'OK' twice to apply the settings. Type or paste a new URL into a cell and press Enter to verify it converts to a clickable link.

Enable AutoFormat As You Type for Hyperlinks

Immediate Effect: This setting will apply to all future typing and pasting. Existing plain text URLs will need to be double-clicked and confirmed with 'Enter' to convert.

Solution 2

Create Hyperlinks Manually Using Ctrl+K

If you only need to link a few specific cells and prefer to keep auto-formatting disabled, use a quick keyboard shortcut.

Solution 3

Use the HYPERLINK Function for Bulk Conversion

Ideal for converting a whole column of imported plain text URLs into clickable links using a dynamic formula.

WPS Spreadsheet Solution

Automatically Convert URLs to Hyperlinks in WPS Spreadsheet

WPS Office provides a seamless and free spreadsheet experience. If you are tired of troubleshooting Excel settings, you can easily configure WPS Spreadsheet to automatically convert internet paths to clickable hyperlinks as you type.

1. Open WPS Spreadsheet Options: Launch WPS Spreadsheet, click on the 'Menu' button in the top-left corner, and select 'Options' from the drop-down list.
2. Navigate to the Edit Settings: In the Options dialog box, select the 'Edit' tab from the left-hand navigation pane.
3. Enable Automatic Hyperlinks: Check the box next to 'Replace Internet and network paths with hyperlinks as you type' under the AutoFormat section.
4. Apply and Test: Click 'OK' to save your settings. Paste a web address into a cell and press Enter to verify it instantly becomes clickable.

Completely free and lightweight office suiteSeamless compatibility with Microsoft Excel (.xlsx) formatsFamiliar interface makes finding and adjusting settings easyEfficiently handles large datasets with dynamic hyperlink support

microsoft office alternative - wps office

Frequently Asked Questions

Why do my pasted links still appear as plain text after enabling the setting?

The AutoCorrect setting only applies to new data entered after the feature is turned on. For existing URLs already in your spreadsheet, you need to double-click inside the cell and press Enter to trigger the conversion.

Will reinstalling Office fix my hyperlink formatting issue?

Reinstalling Office is generally unnecessary for hyperlink issues, as it is a user-level setting in the AutoCorrect menu. However, if you do reinstall the same licensed edition, it should not remove your license provided you have the original activation details.

How do I remove a hyperlink without deleting the cell text?

Right-click the cell containing the clickable link and select 'Remove Hyperlink' from the context menu. This will revert the link back to plain text while keeping the data intact.

Why do hyperlinks work in Word but not in Excel on the same computer?

Microsoft Word and Excel maintain separate AutoCorrect and AutoFormat settings. You must independently enable the 'Replace internet and network paths with hyperlinks' option in Excel's Proofing settings, even if it is already active in Word.

Office App Problems