INFO in WPS on Windows: Introduction

INFO in WPS on Windows is a spreadsheet function for returning environment-related information during formula entry and calculation; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The INFO function in WPS Spreadsheet helps you enter a formula and return a result based on the specified information type. When you type =INFO(, WPS shows syntax guidance, parameter requirements, and examples so you can complete the formula with fewer input errors.

Core capabilities include:

Showing syntax guidance when you type =INFO(.
Letting you enter the function in a cell or in the formula bar.
Returning a result that updates with spreadsheet recalculation.

This is useful for learning formula syntax, checking formula input, and working with spreadsheet functions in WPS on Windows.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection is required for local function use; downloading, installation, and account actions require internet access
Other	You need to open WPS Spreadsheet and edit worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, select a worksheet cell, and type `=INFO(` to confirm that syntax guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, typing `=INFO(` opens the function workflow with syntax guidance, parameter hints, and examples for formula entry.	Excel provides Formula AutoComplete, which shows a dynamic drop-down list of valid functions, names, and text strings, along with detailed ScreenTips.	Google Sheets highlights AI-assisted spreadsheet work, including formula creation, data analysis, and suggestions in Sheets.	Notion provides a formula language with properties, built-ins, and functions for database calculations.	Adobe Acrobat supports calculation rules for PDF form fields rather than spreadsheet-style function entry in cells.
WPS Advantages	Advantage: WPS keeps the INFO function workflow directly inside the spreadsheet editing area, so you can type the function, review syntax guidance, and confirm the result in one place.	Compared with WPS: Excel documents a broader formula autocomplete system with drop-down navigation and ScreenTips, while this WPS workflow is focused on entering the INFO function and viewing syntax guidance.	Compared with WPS: Google emphasizes AI-assisted formula creation and data analysis rather than a function-specific syntax prompt workflow for INFO.	Compared with WPS: Notion formulas are designed for database properties instead of worksheet cell formulas in a spreadsheet grid.	Compared with WPS: Adobe calculation features are built for PDF forms, so the workflow is different from spreadsheet formula entry and recalculation.
Official Source	—	Formula AutoComplete in Excel	Google Sheets product page	Formula syntax and functions in Notion	Form field calculations in Acrobat

Overall Conclusion
For spreadsheet users on Windows, WPS keeps the INFO function workflow close to everyday cell editing and formula entry. The alternatives listed here focus more on broad autocomplete systems, AI-assisted spreadsheet work, database formulas, or PDF form calculations.

Use Cases

No.	Scenario	Suitable For	Main Need	How INFO Helps
1	Learning function entry	New spreadsheet users	They are not sure how to write the INFO function correctly	Type `=INFO(` to view syntax guidance
2	Faster formula input	Office users	Manual formula entry can cause mistakes	Use the formula bar and on-screen guidance together
3	Result checking	Data users	It is hard to identify whether the issue comes from formula input	Recheck the parameter format and function syntax
4	Preparing a worksheet calculation	Intermediate users	They want to confirm the function returns a result before using it further	Test INFO in a target cell first
5	Recalculation review	Worksheet maintainers	They need to confirm whether results update after changes	Recalculate and review the INFO result again

Membership & Benefits

Free vs WPS Premium

Feature Area	Free	WPS Premium
INFO function entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available with a broader feature range
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and broader benefits
AI tools	Limited access to some tools	More AI-related tools are included as described on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need INFO and other basic spreadsheet functions	Free	Basic function entry and calculation are already available
You also need more cloud storage, templates, or additional office tools	WPS Premium	A better fit for users who want broader office benefits alongside spreadsheet work

Subscribe here: Get WPS Premium