Function Problems

How to Convert Excel HYPERLINK Formulas into Clickable Links

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs to convert existing HYPERLINK formulas in a spreadsheet into standard, clickable hyperlinks while preserving both the friendly names and the URLs, without writing any macros.

Product: Excel
Device & OS: not provided
Scenario: Transforming dynamically generated formula links into static clickable hyperlink objects.
Observed behavior: The links are currently driven by HYPERLINK formulas, requiring conversion to standard usable links without losing the underlying destination URL.

Before you start

Ensure you have both your spreadsheet software and a word processor (like Microsoft Word or WPS Writer) open, as this method relies on a quick clipboard workaround between the two programs.

Solution 1Recommended

Convert HYPERLINK Formulas Using a Word Processor

Use a simple copy-paste method through a word processing application to easily convert formulas to static clickable links without needing VBA macros.

Pasting as 'Values' directly in your spreadsheet will only keep the text and strip away the underlying URL. By pasting the cells into a word processor first, the application automatically translates the formula outputs into rich text hyperlinks. Pasting this rich text back into the spreadsheet preserves both the link formatting and the destination URL.

Copy the formulas

Select the cells containing the HYPERLINK formulas in your spreadsheet and press Ctrl+C (or right-click and select Copy).

Paste into a Word document

Open a blank Microsoft Word document (or WPS Writer) and press Ctrl+V to paste the copied cells. They will appear as a table filled with clickable links.

Copy the table from Word

Click the small crosshair icon at the top-left of the table in the Word document to select the entire table, then press Ctrl+C to copy it.

Paste back into Excel

Return to your spreadsheet, select the destination cell range, and press Ctrl+V. The formulas will now be completely converted into standard, static clickable links.

Macro-Free Workflow: This workaround perfectly preserves friendly names and URLs, completely bypassing the need for complex VBA macro programming.

Seamless Spreadsheet Management

Easily Manage and Convert Hyperlinks with WPS Office

WPS Office provides a tightly integrated productivity suite. You can effortlessly copy your HYPERLINK formulas from WPS Spreadsheet and paste them into WPS Writer to instantly convert them to static links, enjoying a smooth, macro-free experience.

1. Copy from WPS Spreadsheet: Open your workbook in WPS Spreadsheet, highlight the cells with the HYPERLINK function, and copy them.
2. Paste into WPS Writer: Launch WPS Writer, create a new blank document, and paste the cells to generate a hyperlink table.
3. Copy the Writer table: Select and copy the newly generated table from WPS Writer.
4. Paste back as static links: Paste the table back into your WPS Spreadsheet. The formulas are now converted to standard clickable links.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats.Flawless rich-text clipboard sharing between Spreadsheet and Writer.Familiar user interface requiring zero learning curve.Lightweight, fast-loading, and completely free to use.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I just use 'Paste Special -> Values' to convert the formulas?

Using 'Paste Special -> Values' in Excel only retains the visible text (the friendly name) of the cell. It permanently removes the underlying URL, making the text unclickable. The Word copy-paste workaround preserves both the text and the URL.

Does this conversion trick work for multiple columns at once?

Yes, you can highlight an entire block of cells containing HYPERLINK formulas across multiple rows and columns, paste them into the word processor as one large table, and copy them back into the spreadsheet in a single step.

Can I use a VBA macro to perform this conversion instead?

Yes. If you are comfortable with coding, you can write a VBA script to iterate through the cells, extract the URL string from the formula, and add a true Hyperlink object. However, the Word clipboard method is generally faster and much easier for users who want to avoid programming.

Will this copy-paste method work on a Mac?

Yes, this clipboard workaround relies on standard rich-text handling between spreadsheet and word processing applications, so it works similarly on both Windows and Mac operating systems.

Excel & Data Problems