WPS Features
Resources
Free AI Tools
Docs Center

How to Use the INFO Function in WPS on Windows

Last updated:July 13, 2026

This guide includes 3 task topics for using INFO, covering insertion from the function dialog box, direct formula entry, and syntax review; 3 are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert INFO from the Insert Function dialog boxFree
22. Type the INFO formula directly in a cellFree
33. Review INFO syntax and parameter guidanceFree

How-to Guide

1. Insert INFO from the Insert Function dialog box

Entry point: Formula 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 Formula tab.
  3. Search for INFO in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish the formula entry.

Success Criteria

  • The current cell now contains the INFO function.
  • The full formula is visible in the formula bar.
  • The worksheet remains editable and can be saved.

Tips While Using

  • It is helpful to check the function name as uppercase INFO when searching.
  • Confirm the target cell and referenced content before filling in parameters.

2. Type the INFO formula directly in a cell

Entry point: Cell → Formula bar

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

Success Criteria

  • The cell accepts the formula input.
  • After you press Enter, the cell shows the result or keeps the formula state as expected.
  • You can review and edit the formula again in the formula bar.

Tips While Using

  • Start the formula with the equals sign =.
  • Keep separators and references correct to avoid input-related errors.

3. Review INFO syntax and parameter guidance

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter INFO in the search box.
  3. Select the function and review the syntax area.
  4. Open the related help entry if you need more detailed guidance.

Success Criteria

  • You can see the INFO function name and syntax area.
  • You can continue filling in parameters based on the guidance.
  • You can return to the worksheet and keep editing the formula.

Tips While Using

  • Keep the function name and bracket format consistent with the actual formula you enter.
  • If the help entry opens online content, make sure your internet connection is available.