MAKEARRAY in WPS on Windows: Introduction

WPS MAKEARRAY is a spreadsheet function for generating calculated array results by row and column; this guide covers 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 How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index
Version limits	None	Available in Smart Spreadsheet across supported versions
Membership limits	None	Can be used directly

About This Feature

Overview

MAKEARRAY is a function in WPS Office for Windows Smart Spreadsheet that supports data calculation and analysis. You can use the MAKEARRAY function in a formula to generate array results, work with flexible parameters, combine it with nested formulas, reference other worksheets, and keep results updated when source data changes.

Core capabilities include:

Start a formula by entering MAKEARRAY and viewing syntax guidance.
Fill in parameters based on the required formula structure.
Combine MAKEARRAY with cross-worksheet references or other functions.
Keep calculation results updated after source data changes.

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; the function is available in Smart Spreadsheet across supported versions
Network	No mandatory internet connection is required for local formula entry and calculation
Other	You need to be able to open a spreadsheet file and edit cells and formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then open Smart Spreadsheet to use formula features
Post-install check	Launch WPS Smart Spreadsheet, select a cell, and type `=MAKEARRAY(` to confirm that syntax guidance appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In Smart Spreadsheet, entering `=MAKEARRAY(` starts formula editing with syntax guidance, nested calculation support, cross-worksheet references, and recalculation after data changes.	Word supports formulas in table cells and can update results when the document opens or when formulas are refreshed manually, but the workflow is centered on document tables.	Google Sheets lets you type `=` in a cell to start formulas, shows a function help box during editing, and supports nested functions and range selection.	Notion formulas work with database properties, built-ins, and functions for calculated property outputs in databases.	Acrobat can configure calculated PDF form fields with predefined operations such as sum, product, average, minimum, and maximum.
WPS Advantages	Advantage: The workflow stays close to spreadsheet-style cell formula entry and ongoing recalculation for array-based results.	Compared with WPS: Microsoft's referenced workflow is for Word table formulas rather than spreadsheet cell formulas.	Compared with WPS: Google Sheets offers a similar formula-entry experience with help prompts and nested functions for spreadsheet work.	Compared with WPS: Notion formulas are designed for database properties instead of traditional worksheet cell formulas.	Compared with WPS: Adobe focuses on PDF form field calculations rather than spreadsheet formula authoring.
Official Source	—	Use a formula in a Word table	Add formulas & functions	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion

If your main task is entering formulas directly in spreadsheet cells, combining parameters, and keeping results updated as data changes, WPS follows a familiar spreadsheet workflow. Microsoft Word, Notion, and Adobe also support calculations in their own products, but their calculation models are aimed at document tables, database properties, and PDF forms.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	How WPS Helps
1	Generate result ranges in batches	Data organizers	Writing formulas cell by cell takes time	Use MAKEARRAY to generate calculated result areas by row and column
2	Handle multi-parameter calculations	Finance and analysis users	Similar rules need to be repeated many times	Enter parameters with syntax guidance for consistent calculations
3	Build cross-worksheet calculations	Users working across multiple sheets	Data is spread across different worksheets	Reference other worksheets inside the formula
4	Combine nested formulas	Advanced spreadsheet users	A single function may not cover more complex logic	Combine MAKEARRAY with other functions
5	Keep results updated	Users maintaining recurring reports	Results need repeated adjustment after source data changes	Use recalculation behavior to keep results in sync

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
MAKEARRAY function use	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and broader access
Advanced PDF and some advanced tools	Partially limited	More complete access

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Learning formulas and handling everyday spreadsheet calculations	Free	MAKEARRAY itself is available directly for regular editing and practice
Needing more cloud storage, templates, or broader office features	WPS Premium	Suitable if you also need storage, templates, and more office capabilities

WPS membership center: Subscribe now