Common questions about WPS Hyperlink on macOS usually involve links that do not open, batch link creation, and hyperlink display changes. This section covers 3 frequent questions.
FAQ
What should I do if a hyperlink does not open?
- Check whether the link address, file path, or email address is correct.
- Make sure the target web page is available or the target file is still stored in the original location.
- In some settings, hold
Cmdand then click the hyperlink to open it.
How do I add hyperlinks in batches in WPS Spreadsheet on macOS?
- Use the formula
=HYPERLINK("url","display text")in the target cell. - Confirm that the first result works as expected.
- Use fill to copy the formula to other cells.
- Review the copied links to make sure the target addresses and displayed text are correct.
Can I change the color of hyperlink text?
- Select the cell that contains the hyperlink.
- Open the font color settings and choose the display color you want.
- Check that the hyperlink still works after the style change.
Glossary
| Term | Definition |
|---|---|
| Hyperlink | A clickable entry in a cell that can point to a web page, file, email address, or a location in the current workbook. |
| Place in This Document | A link target inside the current workbook or sheet, used to jump to a specific cell or area. |
| HYPERLINK function | A spreadsheet function that creates a clickable link from a target address and displayed text. |