Use WPS Hyperlink with 2 how-to topics, both available directly in a spreadsheet, and follow the index to complete each task step by step.
How-to Index
| # | Topic | Membership |
|---|---|---|
| 1 | 1. Insert a Hyperlink | Free |
| 2 | 2. Edit or Remove a Hyperlink | Free |
How-to Guide
1. Insert a Hyperlink
Entry point: Insert tab → Hyperlink
- Select the cell where you want to add a hyperlink.
- Click Hyperlink on the Insert tab, or press
Ctrl+K. - In the dialog box, choose the link type you need.
- Enter a web URL, file path, cell reference, email address, or choose a WPS Cloud Documents link as needed.
- Click OK to finish. This is the basic workflow for users searching how to insert hyperlink in spreadsheet cells.
Success Criteria
- The cell shows clickable link text or an address.
- Clicking the link opens the related webpage, file, mail app, or target location based on the link type.
Tips While Using
- Check the target carefully when entering a web address or file path.
- If the target is an external file or webpage, system permissions or network status may affect access.
2. Edit or Remove a Hyperlink
Entry point: Right-click menu → Edit Hyperlink / Remove Link
- Right-click the cell that already contains a hyperlink.
- Select Edit Hyperlink to change the target or displayed content.
- Select Remove Link to delete the hyperlink while keeping the displayed text.
- Confirm the result after the change is complete.
Success Criteria
- After editing, the hyperlink opens the new target.
- After removal, the text remains in the cell but no longer jumps anywhere.
Tips While Using
- Before removing a link, confirm whether the original destination is still needed.
- If the worksheet is shared with others, test the updated link again to avoid sending people to the wrong address.