When using WPS Hyperlink, common questions usually involve link opening, batch creation, and display style; this FAQ includes 3 common questions and a short glossary.
FAQ
What should I do if nothing happens when I click a hyperlink?
- Check whether the link address, file path, or cell reference is correct.
- Make sure the target webpage or cloud document is accessible, and that the local file has not been moved or deleted.
- If your current setup requires a modifier key, hold
Ctrland click the hyperlink again.
How do I add hyperlinks in batch?
- For batch creation, you can use the
HYPERLINKfunction to generate clickable links. - Confirm that the references for the target address and display text are correct.
- After generating the formula, use fill to copy it to other cells and review the results one by one.
Can I change the hyperlink text color in WPS Sheets?
- Select the cell that contains the hyperlink.
- Open the font settings on the Home tab.
- Change the font color or other text styles as needed.
Glossary
| Term | Definition |
|---|---|
| Hyperlink | A clickable link in a document or spreadsheet that can jump to a webpage, file, email address, or location in a document. |
| Cell reference | A location identifier used to point to a cell in a spreadsheet, such as A1 or B2. |
| HYPERLINK function | A spreadsheet function used to generate clickable links with both a target address and display text. |