INFO in WPS on Windows helps you enter and use an information function in spreadsheets; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 4 | Matches the number of Free rows in the index |
| Membership-related items | 0 | This feature can be used without WPS membership |
About This Feature
Overview
INFO is an information function in WPS Spreadsheet that is used to return specific details about the current working environment, system settings, or calculation context. When you type the function, WPS shows syntax guidance in the editing area so you can confirm the required argument format more quickly.
Core capabilities include:
- Enter the INFO function and view syntax guidance while editing a formula.
- Fill in arguments based on the function requirements for information lookup scenarios.
- Combine the function with cross-sheet references or nested formulas when needed.
- Recalculate results after related data or calculation conditions change.
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 internet connection is required for local formula editing; internet access is needed for download, installation, and account-related actions |
| Other | WPS Office should already be installed, and you should be able to open and edit spreadsheet files |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, create or open a spreadsheet, and confirm that you can type the INFO function in the formula bar |
Source: WPS download center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Spreadsheet, you can type the INFO function, view syntax guidance, complete arguments, and calculate results in cells. | Microsoft Word supports formulas in table cells and can update formula results, but the feature is centered on document tables rather than a full spreadsheet grid. | Google Sheets lets users type formulas and functions in cells and shows a function help box with syntax and examples during editing. | Notion formulas work in database properties and use built-in functions, properties, and operators for calculated outputs. | Adobe Acrobat supports calculated form fields in PDF forms for totals and other field-based calculations. |
| WPS Advantages | Advantage: The workflow is built around spreadsheet cell formulas, which fits day-to-day worksheet editing and recalculation. | Compared with WPS: Word formula features are tied to document tables, so the editing model is narrower than a spreadsheet formula environment. | Compared with WPS: Google provides strong formula help in cloud spreadsheets, while WPS keeps the workflow in the desktop spreadsheet app on Windows. | Compared with WPS: Notion formulas are designed for database properties instead of traditional spreadsheet cells and formula bars. | Compared with WPS: Acrobat calculations focus on PDF form fields rather than spreadsheet-style formula entry and sheet references. |
| Official Source | — | Use a formula in a Word table | Add formulas & functions | Intro to formulas | Advanced form fields |
Overall Conclusion
If your main task is entering and managing spreadsheet formulas in cells, WPS provides a workflow that stays close to everyday worksheet editing on Windows. Microsoft Word, Google, Notion, and Adobe also support calculations, but they focus on document tables, cloud sheets, database properties, or PDF forms in different ways.
Use Cases
| No. | Scenario | Suitable for | Main need | How INFO helps |
|---|---|---|---|---|
| 1 | Learning function syntax | New spreadsheet users | They need to understand the argument format | Type INFO and review the syntax guidance |
| 2 | Entering information formulas quickly | Office users | They want to complete a formula with fewer retries | Use the formula bar to enter the function and arguments directly |
| 3 | Building more complex formulas | Data-focused users | A single function is not enough for the task | Combine INFO with references or nested formulas |
| 4 | Checking recalculated results | Spreadsheet maintainers | They need to confirm that results update after changes | Press Enter and review the updated cell result |
| 5 | Using formulas across sheets | Multi-sheet users | They need to organize formulas across worksheets | Add cross-sheet references together with INFO |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| INFO function entry and basic calculation | ✅ | ✅ |
| Basic PDF features | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced templates and broader benefits |
| Advanced PDF and extended tools | Limited | More complete access |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You only need the INFO function and regular spreadsheet editing | Free | This function topic does not require membership |
| You also need more cloud storage, templates, or extended office tools | WPS Premium | It is more suitable for broader document and productivity needs |
How to Subscribe
- WPS membership: Subscribe now
Source: WPS Office pricing page