Document Editing Problems

How to Add a Hyperlink to Part of Text in an Excel Cell

WPS Content Manager Sep 30, 2026 868 views

Question details

The user wants to apply a hyperlink to specific words within a text string inside a single Excel cell, rather than linking the entire cell's contents.

How to Add a Hyperlink to Part of Text in an Excel Cell

Product: Spreadsheets
Device & OS: not provided
Scenario: Formatting and inserting hyperlinks in spreadsheet cells containing long text.
Observed behavior: By default, spreadsheet applications apply hyperlinks to the entire contents of a cell, preventing users from linking only a specific portion of the text natively.

Before you start

Since spreadsheet software treats hyperlinks as a cell-level property rather than a character-level format, you will need to use drawing tools or alternative formatting layouts to achieve the desired visual result.

Solution 1Recommended

Use a Transparent Shape Over the Text

This is the most seamless workaround to make specific words appear linked without affecting the rest of the text in the cell.

By overlaying an invisible, clickable shape on top of your text, you simulate a partial hyperlink. To make it convincing, you should manually format the target text to look like a standard link.

Format the target text

Double-click the cell, highlight the specific words you want to act as a link, and manually change their font color to blue and apply an underline.

Insert a shape

Navigate to the 'Insert' tab, select 'Shapes', and choose the 'Rectangle' tool.

Position the shape

Draw the rectangle directly over the specific words you just formatted.

Make the shape transparent

Right-click the shape and select 'Format Shape'. Set both the 'Shape Fill' to 'No Fill' and 'Shape Outline' (or Line) to 'No Line'.

Add the hyperlink

Right-click the now-invisible shape, choose 'Hyperlink' or 'Link', and enter your destination URL.

Cell Adjustment Warning: Because the shape floats over the cell, if you resize the row or column later, you may need to manually reposition the transparent shape to keep it aligned with your text.

Solution 2

Split the Sentence Across Adjacent Cells

Divide your sentence into separate columns so you can apply the hyperlink to just one specific cell containing the target words.

Advanced Formatting with WPS Office

Apply Flexible Hyperlinks Using WPS Spreadsheet

WPS Spreadsheet offers an intuitive interface with precise shape alignment tools, making it exceptionally easy to create partial-text hyperlinks using the transparent shape workaround.

1. Enter and format text: Open your document in WPS Spreadsheet, type the complete sentence, and manually format the target words (blue font, underlined).
2. Insert a rectangle: Go to the 'Insert' tab on the top ribbon, click 'Shapes', and draw a rectangle over the target words.
3. Remove fill and outline: Using the 'Drawing Tools' menu, set both Shape Fill and Shape Outline to 'No Fill/No Line'.
4. Insert the hyperlink: Right-click the invisible shape, select 'Hyperlink', and input the web address.
5. Test the link: Click outside the cell, then hover over the invisible shape to verify the cursor changes and the hyperlink works.

Free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsPrecise shape positioning and formatting toolsRich text formatting capabilities within single cells

microsoft office alternative - wps office

Frequently Asked Questions

Can I add multiple hyperlinks to different words in the same cell?

Yes, by utilizing the transparent shape workaround. You can draw multiple invisible shapes over different words in the same cell and assign a unique hyperlink to each individual shape.

Why doesn't spreadsheet software allow linking part of a text string directly?

Spreadsheets are primarily designed for data processing and calculation rather than complex word processing. As a result, hyperlinks are engineered as cell-level properties rather than character-level formats.

Will the transparent shape hyperlinks work if I convert the file to PDF?

Yes, in most cases. When you export or save the spreadsheet as a PDF using standard PDF converters, hyperlinks attached to shapes usually remain functional and clickable in the resulting document.

Does this shape workaround work on mobile spreadsheet apps?

Inserting and linking shapes is typically a feature limited to desktop versions of spreadsheet software. While you might be able to tap an existing linked shape on a mobile app, setting it up requires a PC.

Document & File Issues