Function Problems

How to Shorten the Display Text of a Hyperlink in Excel

John WilsonJohn Wilson Nov 10, 2026 870 views

Question details

The user wants to display a short, readable label instead of a long URL while keeping the hyperlink active in the spreadsheet.

How to Shorten the Display Text of a Hyperlink in Excel
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.
Before you start

Make sure you have the exact destination URL copied to your clipboard before setting up your custom hyperlink.

Solution 1Recommended

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.

1
Select the target cell

Click on the cell where you want the shortened hyperlink to be displayed.

2
Enter the formula

Type =HYPERLINK( to begin the function.

3
Add the URL and display text

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")

4
Apply the function

Press Enter. The cell will now display "Open Link" as a clickable hyperlink instead of the full URL.

Use the HYPERLINK Function
Tip: You can also reference other cells instead of typing the text directly. For example, =HYPERLINK(A1, B1) will link to the URL in cell A1 and display the text from cell B1.
Manage Spreadsheets Efficiently

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. 1. Open your file in WPS: Launch WPS Office and open your spreadsheet document.
  2. 2. Select the cell: Click on the cell where you wish to shorten the hyperlink text.
  3. 3. Apply the hyperlink: Use the =HYPERLINK("URL", "Text") formula or right-click to select 'Hyperlink' and customize the 'Text to display'.
Fully compatible with Microsoft Excel .xlsx formats and hyperlink structures.Supports the exact same HYPERLINK formulas, allowing for seamless data migration.Lightweight, fast, and completely free to use for daily spreadsheet tasks.Familiar user interface reduces the learning curve.
microsoft office alternative - wps office

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.