Document Editing Problems

Change Hyperlink Display Text in Excel Without Removing the Link

Olivia MillerOlivia Miller Nov 18, 2026 871 views

Question details

Change or remove unwanted wording from a hyperlink's displayed text without deleting the link.

Change Hyperlink Display Text in Excel Without Removing 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.
Before you start

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.

Solution 1Recommended

Edit the hyperlink's text to display

Use this method for a hyperlink inserted through Excel's hyperlink dialog.

1
Open the hyperlink editor

Select the cell and press Ctrl+K, or right-click the cell and choose Edit Hyperlink.

2
Change the visible wording

In the Text to display field, replace the unwanted wording with the text you want readers to see.

3
Check the destination

Confirm that the Address field or the selected location in the workbook still points to the intended destination, then click OK.

4
Test the link

Click the hyperlink to verify that it opens the intended URL or cell range. Repeat these steps for other affected links.

Edit the hyperlink's text to display
Use a short label if needed: Removing unwanted words is more reliable than leaving the display text entirely blank, which may cause Excel to show the destination instead.
Edit spreadsheet hyperlinks

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Open the link editor: Right-click the linked cell and choose Edit Hyperlink.
  3. 3. Update the label: Change the text to display, check that the link destination remains correct, and click OK.
  4. 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.
Replace unwanted hyperlink wording with a clear label.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface to review link destinations.
microsoft office alternative - wps office

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.