Use WPS Hyperlink with 4 topics: insert a web link, insert an email link, insert a link to this document, and finish insertion before opening the link; choose a topic from the How-to Index and follow the steps.
How-to Index
| # | Topic | Membership |
|---|---|---|
| 1 | 1. Insert a Web Link | Free |
| 2 | 2. Insert an Email Link | Free |
| 3 | 3. Insert a Link to This Document | Free |
| 4 | 4. Finish Insertion and Open the Link | Free |
How-to Guide
1. Insert a Web Link
Entry point: Tools at the bottom > Insert > Hyperlink
- Open the spreadsheet file that you want to edit.
- Tap Tools at the bottom.
- Select the Insert tab.
- Tap Hyperlink.
- Choose Web Address as the link type.
- Enter the URL and confirm the insertion.
Success Criteria
- UI state: the target cell shows recognizable linked content.
- Next actions: tap the link in the cell to try opening the target web page.
Tips While Using
- Common mistakes: if the URL does not include http:// or https://, opening the web page may not work as expected.
- Environment limits: opening an external web page requires an internet connection.
2. Insert an Email Link
Entry point: Tools at the bottom > Insert > Hyperlink
- Open the spreadsheet and select the target cell.
- Tap Tools and go to Insert.
- Tap Hyperlink.
- Choose Email.
- Enter the email address and confirm.
Success Criteria
- UI state: the cell shows email-related linked content.
- Next actions: tapping the link can call the email handling option available on the device.
Tips While Using
- Common mistakes: an incomplete email address can make the link unusable.
- Environment limits: the device needs an available email handling environment.
3. Insert a Link to This Document
Entry point: Tools at the bottom > Insert > Hyperlink
- Open the current workbook and select the cell where you want to place the link.
- Tap Tools and go to Insert.
- Tap Hyperlink.
- Choose Place in This Document.
- Select a worksheet or location in the current workbook.
- Tap OK to finish.
Success Criteria
- UI state: the cell now contains linked content.
- Next actions: tap the link to jump to the target location in the current workbook.
Tips While Using
- Common mistakes: if you do not confirm the target worksheet or location first, the link may point to the wrong area.
- Environment limits: this link works most clearly when the current document structure stays available.
4. Finish Insertion and Open the Link
Entry point: a cell that already contains a hyperlink
- Finish inserting any hyperlink type.
- Return to the spreadsheet and check the linked content in the target cell.
- Tap the link.
- Jump to the web page, email address, or place in the current workbook based on the link type.
Success Criteria
- UI state: tapping the link produces the expected jump result.
- Next actions: you can return to the spreadsheet and continue editing other cells.
Tips While Using
- Common mistakes: incorrect link content can cause the jump to fail.
- Environment limits: if the target requires permission, make sure you already have access.