INFO in WPS on Windows: Introduction

Last updated:July 17, 2026

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

MetricValueNotes
Core tasks4Matches the number of rows in the How-to Index
Available without membership4Matches the number of Free rows in the index
Membership-related items0This 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

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office
NetworkNo mandatory internet connection is required for local formula editing; internet access is needed for download, installation, and account-related actions
OtherWPS Office should already be installed, and you should be able to open and edit spreadsheet files

Source: System Requirements for WPS Office

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Check after installationOpen 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

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryIn 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 AdvantagesAdvantage: 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 SourceUse a formula in a Word tableAdd formulas & functionsIntro to formulasAdvanced 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.ScenarioSuitable forMain needHow INFO helps
1Learning function syntaxNew spreadsheet usersThey need to understand the argument formatType INFO and review the syntax guidance
2Entering information formulas quicklyOffice usersThey want to complete a formula with fewer retriesUse the formula bar to enter the function and arguments directly
3Building more complex formulasData-focused usersA single function is not enough for the taskCombine INFO with references or nested formulas
4Checking recalculated resultsSpreadsheet maintainersThey need to confirm that results update after changesPress Enter and review the updated cell result
5Using formulas across sheetsMulti-sheet usersThey need to organize formulas across worksheetsAdd cross-sheet references together with INFO

Membership & Benefits

Free vs WPS Premium

CapabilityFreeWPS Premium
INFO function entry and basic calculation
Basic PDF features
Cloud storage1 GB20 GB
Template downloadsLimitedMore advanced templates and broader benefits
Advanced PDF and extended toolsLimitedMore complete access

Source: WPS Office pricing page

Recommendations

ScenarioRecommended planWhy
You only need the INFO function and regular spreadsheet editingFreeThis function topic does not require membership
You also need more cloud storage, templates, or extended office toolsWPS PremiumIt is more suitable for broader document and productivity needs

How to Subscribe

Source: WPS Office pricing page