CELL in WPS on Windows: Introduction

Last updated:July 17, 2026

WPS CELL is an information function in Spreadsheet on Windows; 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 items0Matches the number of membership-related rows in the index
Version limitsNoneAvailable in Spreadsheet across supported Windows versions

About This Feature

Overview

The CELL function in WPS Spreadsheet returns information related to a cell, reference, or cell content, making it useful for data checks, formula workflows, and spreadsheet analysis.

Core capabilities include:

  • Start the function quickly by typing =CELL( in a cell.
  • Review syntax prompts while editing the formula.
  • Return information for a specified cell based on the selected arguments.
  • Use cross-worksheet references and let results recalculate when source data changes.

Common use cases include spreadsheet review, formula troubleshooting, data analysis, and reference checking across worksheets.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office
App versionThe latest version of WPS Office is recommended
NetworkNo mandatory internet connection is required for local formula calculation; internet access is needed for download and account-related actions
OtherWPS Office should be installed, and you should be able to open a Spreadsheet file

Source: System Requirements for WPS Office

Download & Installation

Before using the CELL function, install WPS Office for Windows and open Spreadsheet.

ItemDetails
Official downloadWPS Office Free Download
Check after installationOpen WPS Office, launch Spreadsheet, and type =CELL( in a cell to confirm that the function prompt appears

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryIn WPS Spreadsheet, the CELL function can return information about a cell based on its arguments, supports cross-worksheet references, and recalculates when data changes.Excel's CELL function returns information about the formatting, location, or contents of a cell and uses the CELL(info_type, [reference]) syntax.Google Sheets provides a CELL function that returns requested information about a specified cell, including address, column, contents, type, width, and sheet name.Notion provides formula syntax, properties, built-ins, and functions for database calculations, but it does not provide a spreadsheet-style CELL equivalent centered on worksheet cell references.Adobe Acrobat provides document properties and metadata tools for PDF files rather than spreadsheet cell information functions.
WPS AdvantagesAdvantage: You can enter CELL directly in Spreadsheet and continue editing from the in-product syntax prompt. Distinct: It fits worksheet-based information lookup, cross-sheet references, and recalculation in one workbook.Compared with WPS: Excel offers a direct counterpart with detailed argument documentation and similar worksheet-based usage.Compared with WPS: Google Sheets also offers a same-name function and documents several info_type values for web-based spreadsheets.Compared with WPS: Notion formulas focus on database properties and formula expressions instead of cell-address-based worksheet references.Compared with WPS: Acrobat focuses on PDF document properties and metadata, not spreadsheet formula calculation.
Official SourceCELL functionCELL functionFormula syntax and functionsDocument properties and metadata overview

Overall Conclusion
If you need worksheet-based cell information for follow-up calculations, WPS CELL covers everyday spreadsheet use directly inside WPS Spreadsheet. Microsoft Excel and Google Sheets provide closely related function support, while Notion and Adobe focus on database formulas or PDF document information instead of spreadsheet cell functions.

Use Cases

No.ScenarioSuitable forMain challengeHow CELL helps
1Check a cell's content typeData staffIt can be hard to confirm whether a value is ready for further calculationUse CELL to return cell information before building the next formula
2Read information across worksheetsFinance and operations usersCross-worksheet references can be difficult to verify quicklyUse CELL with cross-worksheet references to inspect the target cell
3Troubleshoot formulasSpreadsheet maintainersIt can take time to locate a reference issue when a result looks wrongEnter CELL in the formula bar and review the returned result with the syntax prompt
4Keep analysis updatedEveryday office usersResults need to stay aligned with changing source dataUse automatic recalculation to keep returned information updated

Membership & Benefits

Free vs WPS Premium

CapabilityFreeWPS Premium
Enter and calculate the CELL function
Basic spreadsheet editing
Cloud storage1 GB20 GB
Template downloadsLimitedMore advanced templates and broader access
PDF and advanced toolsBasic featuresMore advanced tools

Source: WPS download page

Source: WPS Office pricing page

Recommendations

ScenarioRecommended planWhy
You only need the CELL function and basic spreadsheet calculationFreeThe feature itself has no membership limit and works well for routine spreadsheet tasks
You also need more cloud storage, templates, and advanced toolsWPS PremiumA better fit for users who work with multiple document types and want broader product benefits

How to Subscribe

Source: WPS Office pricing page