How to Create Excel Hyperlinks to Documents and File Paths in WPS Office Spreadsheet
Question details
The user needs to build clickable Excel document links by storing file names and full file paths in separate columns, so the workbook displays a friendly name and opens the correct document when clicked.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user has a list of document names and file paths in separate columns and needs to convert them into clickable hyperlinks.
- Observed behavior
- The desired result is a clickable cell that shows the document name and opens the target file path when clicked.
Make sure the full file paths stored in column B are accessible from the device where you open the WPS workbook, and verify that the document names in column A are exactly how you want them to appear.
Create a clickable document link with =HYPERLINK(B2,A2)
Use this method when you store document names in one column and full file paths in another and want links that are easy to fill down across many rows.
The HYPERLINK function creates a clickable cell using the path in B2 as the link target and the text in A2 as the display name. This keeps the visible text friendly while preserving the full file path for the link.
Open WPS Office Spreadsheet, then click the cell where you want the clickable document link to appear, such as C2.
Type =HYPERLINK(B2,A2) in the cell and press Enter.
Drag the fill handle from the bottom-right corner of the selected cell down the column to create links for the other rows.
Insert a local document hyperlink manually using the Insert Hyperlink dialog
Use this when you need a one-off link and prefer browsing to the file instead of typing a full path.
Create Excel Document Hyperlinks in WPS Office Spreadsheet
Use WPS Office Spreadsheet's HYPERLINK function or Insert Hyperlink dialog to turn file paths into clickable document links, keeping your workbook organized and links easy to update.
- 1. Open your workbook in WPS Office Spreadsheet: Launch WPS Office Spreadsheet and open the workbook that will contain the document links.
- 2. Enter the document name and full file path: Type the document name in column A and the complete file path in column B, for example A2 and B2.
- 3. Create the hyperlink formula: In cell C2, enter =HYPERLINK(B2,A2) and press Enter to create a clickable link.
- 4. Apply the formula to other rows: Use the fill handle to copy the formula down for additional documents.
- 5. Test and update links: Click the generated link to open the target file; if a file moves or is renamed, update the path in column B.
Frequently Asked Questions
What formula creates a hyperlink from a file path in WPS Spreadsheet?
Use =HYPERLINK(B2,A2) when B2 contains the full file path and A2 contains the display name.
Can I show a friendly document name instead of the full path?
Yes. Store the document name in A2 and the full path in B2, then use =HYPERLINK(B2,A2) so the cell displays the document name.
What should I do if the target file is moved or renamed?
Update the path in column B or edit the hyperlink manually. Standard hyperlinks do not reliably track external file changes.
Does this HYPERLINK method work in both WPS Office and Microsoft Excel?
Yes, the HYPERLINK function is compatible with .xlsx workbooks in both WPS Office Spreadsheet and Microsoft Excel.
How do I insert a document hyperlink manually without a formula?
Select the cell, go to Insert > Hyperlink, choose the target file, set the text to display, and click OK.
