Feature Summary

The hyperlink feature supports inserting web links, file shortcuts, in-document navigation, and email links into cells, enabling one-click access.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Insert Hyperlink

Feature Entry
"Insert" tab → "Hyperlink" button

  1. Select the cell where you want to add a hyperlink
  2. Click the "Hyperlink" button in the Insert tab (or press Cmd+K)
  3. Choose the link type based on your needs:
Link Type Description
Existing File or Web Page Enter a web URL or file path; click to open directly
Place in This Document Enter a cell reference; click to jump to the corresponding location
Email Address Enter an email address; click to launch the mail program

4.Click OK to finish adding

image

Edit/Delete Hyperlink

  1. Right-click the cell containing the hyperlink
  2. Select "Edit Hyperlink" to modify the link target
  3. Select "Remove Link" to delete the hyperlink (the displayed text is retained)
  4. Select "Edit Hyperlink" → "Remove Link" to completely remove it

FAQ

Q1: How to add hyperlinks in batches?

  • Solution: You can use the formula =HYPERLINK("url","display text") to generate them in batches, or use the fill feature to quickly copy the same link format.

Q2: Can the hyperlink text color be changed to another color?

  • Solution: Yes. After selecting the cell, change the text color via "Home" → "Font Color". Hyperlinks are displayed in blue with an underline by default.

Notes

  • After adding a hyperlink, it is displayed in blue with an underline by default