COLUMNS in WPS on Windows: Introduction

COLUMNS in WPS is a spreadsheet function for counting the number of columns in a referenced range; it includes 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	Matches the number of membership-related rows in the index

About This Feature

Overview

The COLUMNS function in WPS Spreadsheets returns the number of columns in a referenced range. It is useful for spreadsheet calculation and data analysis when you need to count column dimensions quickly. The function supports direct formula entry, syntax prompts during input, cross-sheet references, and automatic recalculation after range changes.

Core capabilities include:

Enter the COLUMNS formula and return a result for everyday spreadsheet work.
Use syntax prompts to check parameter requirements and reduce input mistakes.
Apply the function in cross-sheet references and nested formulas for more complex models.
Keep results updated automatically when the referenced range changes.

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 function calculation
Other	You need access to WPS Spreadsheets and editable worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office, open Spreadsheets, and confirm that the Formulas tab and formula bar are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the COLUMNS function for counting the number of columns in a referenced range, with formula-bar input, syntax prompts, cross-sheet references, and automatic recalculation.	Microsoft Word official guidance for columns focuses on page layout columns in documents rather than spreadsheet functions for counting columns in a cell range.	Google Docs product information focuses on online document creation, collaboration, templates, and AI-assisted writing rather than spreadsheet-style column-count functions inside a document.	Notion formulas support calculations with properties, built-ins, and functions in databases, which fits database logic rather than spreadsheet-compatible range functions.	Adobe Acrobat form JavaScript supports calculations, formatting, and validation in PDF forms, which is designed for form workflows rather than worksheet functions.
WPS Advantages	Advantage: Directly fits spreadsheet column-count analysis. Distinct: The workflow starts in a worksheet cell and updates automatically when the referenced range changes.	Compared with WPS: Word columns are for document layout and text flow, not worksheet formula calculation.	Compared with WPS: Google Docs centers on document collaboration and content creation instead of worksheet function entry.	Compared with WPS: Notion formulas are oriented to database properties and automation logic rather than spreadsheet range references.	Compared with WPS: Adobe focuses on PDF form scripting and field behavior instead of regular spreadsheet formula editing.
Official Source	—	Create multiple columns in Word	Google Docs product page	Intro to formulas	Using JavaScript in Forms

Overall Conclusion
The COLUMNS function in WPS is a direct fit for worksheet-based column counting and formula analysis on Windows. Other products cover document layout, collaborative documents, database formulas, or PDF form scripting, but they do not follow the same worksheet function path for this task.

Use Cases

No.	Scenario	Suitable for	Main issue	Solution
1	Count columns in a referenced range	Spreadsheet editors	Need to know how many columns a data range contains	Enter the COLUMNS function in a target cell to return the column count
2	Check whether formula parameters are correct	Beginners	Unsure about the required argument format	Review the syntax prompt while entering the function
3	Analyze data across worksheets	Data organizers	Need to count columns in a range from another sheet	Add a cross-sheet reference in the formula
4	Track changing data ranges	Report maintainers	Need updated results after the range changes	Use automatic recalculation to refresh the result

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of the COLUMNS function	✅	✅
Basic PDF features	✅	✅
Cloud storage	1 GB	20 GB
Template access	Limited	More advanced templates and extended benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday use of COLUMNS and other basic functions	Free version	The COLUMNS function itself is available without membership for regular spreadsheet calculation
Need more cloud storage and broader office benefits	WPS Premium	Suitable if you also need more storage, templates, and additional office features

WPS membership center: Subscribe now