MAKEARRAY in WPS on Windows: Introduction

WPS MAKEARRAY on Windows helps you generate array results with specified rows, columns, and calculation logic; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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 MAKEARRAY function in WPS on Windows is a spreadsheet formula feature that returns an array with a specified number of rows and columns and uses formula logic to generate a value for each position.

Core capabilities include:

Enter the MAKEARRAY function directly and view syntax prompts for faster formula editing.
Set array size parameters and calculation logic for structured result ranges.
Recalculate results after data changes for ongoing analysis and worksheet updates.

This feature is useful for generating sample data, building rule-based matrices, practicing array formulas, and creating results based on row and column positions.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for newer formula support
Network	No mandatory internet connection is required for local formula entry and calculation; internet access is needed for download, installation, and account-related actions
Other	It is recommended to use WPS AirSheet and make sure the file is editable

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Installation Notes	Download and install WPS Office, then open WPS AirSheet to use formula editing features
Post-install Check	Launch WPS AirSheet and type `=MAKEARRAY(` in a cell to confirm the formula editing environment is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering `MAKEARRAY(` in WPS AirSheet to generate array results based on parameters and complete formula editing with syntax prompts.	Microsoft Excel provides the MAKEARRAY function and documents the syntax as `MAKEARRAY(rows, cols, LAMBDA(row, col))` for returning a calculated array.	Google Sheets documents ARRAYFORMULA for displaying array results across multiple rows or columns, but the cited page does not describe a direct MAKEARRAY-style row-and-column index generator.	Notion formulas perform calculations with database properties, built-ins, and functions, mainly for database property outputs rather than worksheet grid arrays.	Adobe Acrobat supports calculated PDF form fields with predefined calculations, simplified field notation, and custom calculation scripts for form workflows.
WPS Advantages	Advantage: You can enter the function directly in a worksheet cell and use syntax prompts while editing. Distinct: The workflow stays focused on spreadsheet array generation and recalculation.	Compared with WPS: Microsoft provides a clearly documented equivalent function with formal syntax and examples.	Compared with WPS: Google emphasizes array expansion and ARRAYFORMULA behavior more than a direct MAKEARRAY-style function on the cited page.	Compared with WPS: Notion formulas are centered on database properties instead of cell-based spreadsheet array generation.	Compared with WPS: Adobe calculation features are designed for PDF form fields, not worksheet array formulas.
Official Source	—	MAKEARRAY function	ARRAYFORMULA	Intro to formulas	PDF form fields

Overall Conclusion: If your main task is to generate array results in a worksheet based on row and column rules, WPS MAKEARRAY fits a spreadsheet editing workflow well. Microsoft documents a directly comparable function, while Google, Notion, and Adobe focus on array expansion, database formulas, or PDF form calculations in their official materials.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Generate rule-based matrices	Data organizers	Filling a two-dimensional result range manually takes time	Use MAKEARRAY to generate a full array result by row and column position
2	Practice array formulas	Students and beginners	It is hard to quickly verify how parameters affect results	Enter MAKEARRAY in a cell and learn with syntax prompts
3	Build sample data	Spreadsheet builders and testers	Sample results are needed quickly in batches	Use MAKEARRAY with calculation logic to return multiple results at once

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
MAKEARRAY entry and basic calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday formula learning and basic spreadsheet calculation	Free	You can use MAKEARRAY and other spreadsheet editing features for common tasks
More cloud storage or broader add-on benefits	WPS Member	Suitable if you also need storage, templates, or additional office benefits

WPS membership page: Subscribe now