Change Hyperlink Display Text in Excel Without Removing the Link
Question details
Change or remove unwanted wording from a hyperlink's displayed text without deleting the link.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains hyperlinks whose displayed text differs from the linked URL or cell range.
- Observed behavior
- Excel shows the hyperlink's friendly text rather than necessarily showing its destination.
Select an affected cell and check the formula bar to see whether it contains a HYPERLINK formula. Note the current destination so you can verify that it remains unchanged.
Edit the hyperlink's text to display
Use this method for a hyperlink inserted through Excel's hyperlink dialog.
Select the cell and press Ctrl+K, or right-click the cell and choose Edit Hyperlink.
In the Text to display field, replace the unwanted wording with the text you want readers to see.
Confirm that the Address field or the selected location in the workbook still points to the intended destination, then click OK.
Click the hyperlink to verify that it opens the intended URL or cell range. Repeat these steps for other affected links.

Change the friendly name in a HYPERLINK formula
Use this method when the cell's link is created by a HYPERLINK formula.
Change hyperlink text in WPS Spreadsheets
Use WPS Spreadsheets to edit a hyperlink's visible label while retaining its destination, or update the friendly name in a HYPERLINK formula.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Open the link editor: Right-click the linked cell and choose Edit Hyperlink.
- 3. Update the label: Change the text to display, check that the link destination remains correct, and click OK.
- 4. Verify and save: Click the link to test it, then select Save. If the cell uses a HYPERLINK formula, edit its second argument in the formula bar instead.

Frequently Asked Questions
How do I change hyperlink text without changing the address?
Right-click the cell in Excel, choose Edit Hyperlink, and change Text to display. Check that the Address or workbook location is unchanged before clicking OK.
Why does my hyperlink show text instead of the URL?
Excel can display a friendly label that differs from the link destination. Open Edit Hyperlink to inspect the address, or check the first argument in the formula bar if the cell uses HYPERLINK.
How do I change text generated by a HYPERLINK formula?
Select the cell and edit the second argument of =HYPERLINK(link_location, friendly_name) in the formula bar. Leave the first argument unchanged to retain the destination.
Can I leave the hyperlink display text blank?
A blank display-text field may cause Excel to show the destination instead. Use a short label in Text to display if you want to remove specific wording while keeping a visible link.




