Common questions about Insert Link usually involve link behavior, batch creation, and display results; this FAQ includes 3 frequent questions and a glossary.
FAQ
What should I do if clicking the link does nothing?
- Check whether the link address is complete. For web links, include
https://when needed. - Confirm that the target web page, worksheet, or cell location is still accessible.
- Edit the link again, save it, and test it once more.
How do I batch create links with the same prefix in WPS?
- Prepare the text values that need to be combined in the worksheet.
- Use the
=HYPERLINK()formula to generate links in batches. - Check whether the generated results match the intended destinations.
Why is the link address displayed as code instead of text?
- Right-click the cell and open the cell format settings.
- On the Number tab, select General or Text.
- Enter the content again or reset the link.
Glossary
| Term | Definition |
|---|---|
| Hyperlink | A clickable link that jumps to a web page, file, or location inside a spreadsheet. |
| Display text | The visible link text shown in a cell. It does not have to be the same as the actual destination address. |
| Defined Name | A named cell or range in a spreadsheet that can be used for quick reference and navigation. |
| AirScript Script | A script target type that can be used as a link destination for automation-related scenarios. |