How to Display a Friendly Name Instead of a Link URL in Excel
Question details
The user wants to replace long, visually cluttered URLs or file paths in Excel cells with clean, readable custom text.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Organizing and formatting spreadsheets that contain external web links or internal file paths to improve readability.
- Observed behavior
- Excel displays the complete URL or file path by default, which can make the spreadsheet look disorganized and difficult to scan.
Ensure you have the exact target URL or file path copied to your clipboard before creating the hyperlink.
Change the Link Display Text Using the Insert Menu
Use Excel's built-in Link dialog to quickly add a URL and customize the text shown in the cell.
This is the most straightforward method for manually creating a hyperlink with custom display text. It allows you to specify both the web address and the friendly name in a single interface.
Click on the cell where you want the readable hyperlink to appear.
Go to the 'Insert' tab on the top ribbon and click on 'Link'. Alternatively, you can right-click the cell and select 'Link' from the context menu.
Paste your destination URL or file path into the 'Address' field located at the bottom of the dialog box.
Locate the 'Text to display' field at the top of the dialog box. Type the clean, readable name you want to show, such as 'My PDF' or 'Visit Website', and click 'OK' to apply.
Create a Friendly Link Name Using the HYPERLINK Function
Use an Excel formula to create clickable text, which is ideal for dynamically generating links across multiple rows.
Easily Manage Hyperlinks in WPS Office Spreadsheet
WPS Spreadsheet provides intuitive tools to insert, format, and manage hyperlinks, helping you keep your data clean and readable. It fully supports standard Excel hyperlink functions and dialogs.
- 1. Select your cell: Open your document in WPS Spreadsheet and select the cell where you want to place the link.
- 2. Insert the hyperlink: Press 'Ctrl + K' or navigate to 'Insert' > 'Hyperlink' on the ribbon to open the link management dialog.
- 3. Set the address and display text: Paste the destination web address into the 'Link To' field, then type your desired readable name into the 'Text to display' field.
- 4. Confirm your changes: Click 'OK'. Your cell will instantly show the friendly name as a clickable link instead of the messy URL.
Frequently Asked Questions
Why is my HYPERLINK formula returning an error?
If you receive a formula error, verify that both the URL and the friendly name in your formula are enclosed in double quotes, like this: =HYPERLINK("https://example.com", "Link"). Additionally, make sure the web address includes 'http://' or 'https://'.
Can I change the display text of an existing hyperlink?
Yes. Right-click the existing hyperlink in your spreadsheet and select 'Edit Hyperlink'. Update the text in the 'Text to display' box at the very top of the dialog window, then click 'OK' to save the changes.
How do I make multiple links display friendly names at once?
If you have a column of URLs, you can use the HYPERLINK function to reference that column. For instance, if cell A1 contains the URL and cell B1 contains the friendly name, enter =HYPERLINK(A1, B1) in cell C1. You can then drag the fill handle down to apply this formula to multiple rows automatically.
How do I remove a hyperlink but keep the friendly text?
Right-click the cell containing the active hyperlink and select 'Remove Hyperlink' from the context menu. The clickable link behavior will be removed, but the friendly text will remain in the cell.
