How to Shorten the Display Text of a Hyperlink in Excel
Question details
The user wants to display a short, readable label instead of a long URL while keeping the hyperlink active in the spreadsheet.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting a spreadsheet that contains very long URLs to make the data look cleaner and more professional.
- Observed behavior
- Long URLs clutter the cells and make the spreadsheet difficult to read. The goal is to hide the long URL behind a custom, shortened text string.
Make sure you have the exact destination URL copied to your clipboard before setting up your custom hyperlink.
Use the HYPERLINK Function
The most efficient way to shorten a link's appearance is to use the HYPERLINK formula to specify a custom friendly name.
The HYPERLINK function allows you to create a clickable link while completely controlling the text displayed in the cell. The formula syntax requires two arguments: the destination URL and the friendly name.
Click on the cell where you want the shortened hyperlink to be displayed.
Type =HYPERLINK( to begin the function.
Enter your full URL enclosed in quotation marks, followed by a comma. Then, type your desired short display text also enclosed in quotation marks. For example: =HYPERLINK("https://example.com/a-very-long-url", "Open Link")
Press Enter. The cell will now display "Open Link" as a clickable hyperlink instead of the full URL.

Edit the 'Text to Display' via the Right-Click Menu
If you prefer not to use formulas, you can manually insert a hyperlink and change the display text using the standard link interface.
Easily Manage and Format Hyperlinks in WPS Spreadsheet
WPS Spreadsheet fully supports the HYPERLINK function and offers a highly intuitive interface for inserting, editing, and managing hyperlinks. You can quickly tidy up your data with custom display text using the exact same methods you would use in Microsoft Excel.
- 1. Open your file in WPS: Launch WPS Office and open your spreadsheet document.
- 2. Select the cell: Click on the cell where you wish to shorten the hyperlink text.
- 3. Apply the hyperlink: Use the =HYPERLINK("URL", "Text") formula or right-click to select 'Hyperlink' and customize the 'Text to display'.

Frequently Asked Questions
Why does my HYPERLINK formula return an error?
This usually happens if you forget to enclose the URL or the display text in double quotation marks. Ensure your syntax matches this exact format: =HYPERLINK("https://website.com", "Click Here").
How do I change the text of an existing hyperlink?
Right-click the cell containing the hyperlink and select 'Edit Hyperlink' from the menu. In the dialog box that appears, modify the wording in the 'Text to display' box at the top and click OK.
Can I link to another worksheet and use a short name?
Yes. You can use the HYPERLINK function to jump to another sheet by adding a hash symbol (#) before the sheet reference. For example: =HYPERLINK("#Sheet2!A1", "Go to Sheet 2").
Will shortening the display text break the link?
No. The display text is purely cosmetic. As long as the destination URL in the formula's first argument or the 'Address' field is accurate, the link will remain fully functional.




