Feature Summary

Add hyperlinks to cell text, which can link to external web pages, internal document locations, or other files.

Feature Description

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

Steps

Insert Hyperlink

Feature Entry
「Insert」 tab → 「Link」 button

  1. Select the cell where you want to add a link
  2. Click the 「Link」 button in the 「Insert」 tab, or press Command+K
  3. Set the link information in the pop-up window:
  • 「Text」: Enter the text content to display for the link
  • 「Type」: Select the link type from the dropdown
  • 「Link/Address」: Enter the corresponding address or select the target based on the chosen type
  1. Click 「OK」 to complete the insertion

image

Edit/Delete Existing Link

  1. Hover the cursor over the object with the inserted link.
  2. Select 「Copy Link」 to copy the target address
  3. Select 「Edit Link」 to modify the target address
  4. Select 「Remove Link」 to delete the link and keep the original content

image

FAQ

Q1: What should I do if clicking the link does nothing?

  • Solution: Check if the link address is complete (web links must include the https:// prefix). Some link types require holding down the Ctrl key while clicking to jump.

Q2: How do I batch add links with the same prefix?

  • Solution: Use the formula =HYPERLINK() to insert hyperlinks.

Q3: What should I do if the inserted link address displays as code instead of text?

  • Solution: Right-click the cell → 「Format Cells」 → 「Number Format」 tab → Select 「General」 or 「Text」, then re-enter.

Notes

  • Hover over to view the link address for easy target confirmation
  • Select a cell with an inserted link and click 「Clear Format」 to convert the link to plain text
  • Right-click a cell to also insert a link from the context menu that appears