WPS Features
Resources
Free AI Tools
Docs Center

How to Use the HYPERLINK Function in WPS on Windows

Last updated:July 13, 2026

Follow 3 how-to topics to use the HYPERLINK function in WPS on Windows; all 3 are available without membership and can be opened from the index below.

How-to Index

No.TopicMembership Requirement
11. Insert it from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Check syntax and parameter detailsFree

How-to Guide

1. Insert it from the Insert Function dialog box

Entry: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for HYPERLINK in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog box.
  6. Click OK to finish.

Success Criteria

  • The cell shows the HYPERLINK formula result.
  • When you select the cell again, the formula content is visible in the formula bar.

Tips While Using

  • Search with the English function name HYPERLINK.
  • Review the parameters before confirming to reduce rework.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =HYPERLINK(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review the function syntax, type =HYPERLINK( and then press F1 to open the syntax prompt.

Success Criteria

  • After you press Enter, the cell displays the link text or formula result.
  • When you click the result, it can open the target address you set.

Tips While Using

  • Use the correct argument separator for your current formula rules.
  • Check both the target address and the display text to avoid a clickable link with the wrong destination.

3. Check syntax and parameter details

Entry: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter HYPERLINK in the search box.
  3. Select the function to review its syntax information.
  4. Click the help link for the function to view more details.

Success Criteria

  • You can see the function name, syntax structure, and parameter help entry.
  • You can continue entering or revising the formula based on that information.

Tips While Using

  • Make sure the selected function is HYPERLINK before reviewing the help details.
  • Reading the parameter notes first can make the first setup easier.