Use Insert Link with 4 how-to topics in WPS Spreadsheets on Windows; choose a topic from the index and follow the entry path and steps to complete the task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert a hyperlink | Free |
| 2 | 2. Set link details | Free |
| 3 | 3. Edit an existing link | Free |
| 4 | 4. Remove an existing link | Free |
How-to Guide
1. Insert a hyperlink
Feature entry: Insert tab → Link
- Select the cell where you want to add a link.
- Click Link on the Insert tab, or press
Ctrl+K. - Open the link settings window.
Success Criteria
- The link settings window opens.
- The selected cell is ready for link configuration.
Tips While Using
- If the shortcut does not respond, open the feature from the Insert tab directly.
2. Set link details
Feature entry: Link settings window
- Enter the text you want to show in the Text field.
- Select a link type from the Type drop-down list.
- Enter the destination in Link/Address, or choose the target location.
- Click OK to finish inserting the link.
Success Criteria
- The cell shows the configured link text.
- Clicking the link opens the expected destination.
Tips While Using
- Available types include Link, Cell, Worksheet, Dashboard, Defined Name, and AirScript Script.
- For web links, enter the full address when possible.
3. Edit an existing link
Feature entry: Right-click menu → Edit Link
- Right-click the object that already contains a link.
- Select Edit Link.
- Change the destination or related details.
- Click OK to save the changes.
Success Criteria
- The link destination is updated.
- The original cell content still displays and works normally.
Tips While Using
- Check the current destination before editing so you do not change the wrong link.
4. Remove an existing link
Feature entry: Right-click menu → Cancel Link
- Right-click the object that already contains a link.
- Select Cancel Link.
- Keep the original content while removing the jump action.
Success Criteria
- The original text or content remains.
- Clicking no longer triggers a jump.
Tips While Using
- Removing a link only deletes the jump behavior and does not automatically delete the original text in the cell.