INFO in WPS Spreadsheet is a built-in function workflow for entering formulas and checking syntax on Windows; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | All tasks in this guide are available directly |
About This Feature
Overview
INFO is a built-in function in WPS Spreadsheet. You can use it to enter a function in a worksheet cell, review parameter guidance, and complete formula input through the Insert Function dialog box.
Core tasks in this guide include:
- Insert INFO from the Insert Function dialog box.
- Type
=INFO(...)directly in a cell or in the formula bar. - Review syntax and parameter guidance before confirming the formula.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory connection is required for local formula entry; online help requires internet access |
| Other | You need to open WPS Spreadsheet and edit worksheet cells |
Download & Installation
Install WPS Office for Windows before using the INFO function, then open WPS Spreadsheet.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Start WPS Office, open a spreadsheet file, and confirm that the Formula tab, formula bar, or fx button is available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | INFO can be entered in WPS Spreadsheet through the Insert Function dialog box, the formula bar, or directly in a cell, with a help entry for syntax review. | Microsoft Word officially supports formulas in table cells through the Formula command, where users can type formulas, choose number formats, and paste functions, but the workflow is centered on Word tables. | Google Sheets officially provides online spreadsheets for managing, visualising, and analysing data, and its product page states that Gemini can create formulas and help with calculations. | Notion officially describes formulas as a database property feature that uses properties, built-ins, and functions for calculations inside databases rather than a traditional worksheet cell formula interface. | Adobe officially documents JavaScript-based calculations, formatting, and validation for PDF forms, with a focus on form fields and document workflows. |
| WPS Advantages | Advantage: INFO is used directly in a spreadsheet cell workflow, with clear entry points for formula input and syntax checking in everyday worksheet editing. | Compared with WPS: the official formula workflow is tied to Word table cells instead of a full spreadsheet formula environment. | Compared with WPS: it emphasizes cloud collaboration and AI-assisted spreadsheet work, while browser-based or cloud-first use is more central to the experience. | Compared with WPS: formulas are mainly designed for database properties and row-level logic rather than standard spreadsheet cell entry. | Compared with WPS: the official calculation workflow is designed for PDF forms and JavaScript-driven field behavior rather than spreadsheet formula editing. |
| Official Source | — | Use a formula in a Word table | Google Sheets product page | Intro to formulas | Using JavaScript in Forms |
Overall Conclusion
WPS keeps the INFO workflow close to everyday spreadsheet editing on Windows, which is useful when you want to enter a function quickly and confirm its syntax in place. The other products also support formulas or calculations, but their official workflows focus more on Word tables, cloud collaboration, database properties, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|---|---|---|---|
| 1 | First-time function entry | New spreadsheet users | They are not sure where to start | Use the Insert Function dialog box to search for INFO |
| 2 | Faster formula input | Users who edit worksheets often | They want fewer clicks | Type =INFO(...) directly in a cell or in the formula bar |
| 3 | Syntax review before confirming | Users learning functions | They want to verify parameters and syntax | Open the function description area and review the guidance |
Membership & Benefits
This feature guide includes 3 task topics, and all 3 are available without membership; this section provides a general overview of related benefits and the subscription entry.
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Enter and use the INFO function | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional office and extended benefits | Some features may be limited | More extended benefits are available |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily INFO function entry and learning | Free | The function workflow in this guide is available directly for regular spreadsheet work |
| Broader office needs beyond this function | WPS Premium | Suitable if you also need more extended office benefits |
How to Subscribe
- Membership page: Subscribe to WPS Premium
Source: WPS Office pricing page