WPS Fill is a spreadsheet fill feature on iOS for copying repeated values and extending simple series; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | 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
WPS Fill on iOS helps you fill spreadsheet cells faster by copying repeated content or extending simple number and date patterns. After you select a cell or range, you can open Fill from the floating editing bar and drag in four directions to apply the result.
Core tasks include:
- Start Fill: open the fill state from the floating editing bar and drag a direction arrow to fill a target area.
- Switch fill mode: change between Copy Fill and Series Fill during the fill process for different data-entry needs.
This feature is useful for batch numbering, extending date sequences, and copying the same content into nearby cells. Fill can overwrite existing data in the target area, so it is a good idea to check the destination before you apply it.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No required network connection for local fill actions; internet access is needed for download, sign-in, or sync |
| Other | You need to open a spreadsheet file and have permission to edit it |
Download & Installation
Before using Fill, install WPS Office on your iPhone or iPad and open a spreadsheet in editing mode.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office, open a spreadsheet, select a cell, and confirm that the Fill entry appears in the floating editing bar |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides a Fill entry in spreadsheets on iOS, supports dragging direction arrows up, down, left, and right, and lets you switch between Copy Fill and Series Fill after dragging. | Excel Auto Fill can fill cells with data that follows a pattern or is based on other cells, and users can drag the fill handle and choose Auto Fill Options. | The Google Docs product page focuses on collaborative document creation, templates, smart chips, and content blocks, and does not describe a directly equivalent spreadsheet cell fill workflow. | Notion Autofill is designed for database properties and can generate summaries, extract key information, translate content, or categorize entries rather than drag-fill spreadsheet cells. | Acrobat automatic fill is designed for PDF forms and can save commonly used information for future form filling rather than spreadsheet series expansion. |
| WPS Advantages | Advantage: direct four-direction fill in a mobile spreadsheet interface. Distinct: lets you switch between Copy Fill and Series Fill within the same fill flow. | Compared with WPS: Excel officially documents fill handles and Auto Fill Options for worksheet patterns, but the referenced guidance is centered on Excel worksheet behavior rather than an iOS floating-bar workflow. | Compared with WPS: Google Docs emphasizes document collaboration and reusable content blocks, not spreadsheet-style series filling in cells on the referenced page. | Compared with WPS: Notion Autofill is better suited to AI-assisted database property generation than copying or incrementing adjacent spreadsheet cells. | Compared with WPS: Acrobat automatic fill is aimed at reusing form information in PDFs, not filling spreadsheet rows or columns with repeated or sequential values. |
| Official Source | — | Fill data automatically in worksheet cells | Google Docs product page | Notion AI for databases – Autofill | Fill forms automatically in Acrobat |
Overall Conclusion
If you need to copy values or extend simple sequences in a spreadsheet on iOS, WPS Fill is closely aligned with mobile spreadsheet entry. Excel also supports worksheet autofill patterns, while the referenced Notion and Adobe features focus on database generation or PDF form reuse instead of spreadsheet cell filling.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How Fill Helps |
|---|---|---|---|---|
| 1 | Copying the same content in batches | Mobile office users | Nearby cells need the same text or number repeatedly | Use Fill and switch to Copy Fill to extend the same value across the target area |
| 2 | Creating continuous numbering | Spreadsheet record keepers | Manual numbering is slow and easy to get wrong | Use Series Fill to increase or decrease numbers automatically |
| 3 | Extending date sequences | Scheduling and reporting users | Entering dates one by one takes time | Set a starting pattern and use Series Fill to continue it |
| 4 | Organizing horizontal or vertical data quickly | Light spreadsheet users | The same content must appear across rows or columns | Drag in four directions to fill adjacent cells efficiently |
| 5 | Adjusting the fill result during editing | Users who review as they go | The first fill result should be copied instead of extended, or the reverse | Switch the fill mode from the top of the fill interface before finishing |
Membership & Benefits
This feature can currently be used as a free capability; this section outlines general differences between free access and membership plans, plus the subscription entry.
Free vs WPS Premium
| Feature Area | Free Users | WPS Premium |
|---|---|---|
| Fill in spreadsheets | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced office and PDF benefits | Depends on the in-product plan display | Includes more advanced capabilities and extended benefits |
| Cloud storage | 1 GB | 20 GB |
Source: WPS Office pricing page
Recommendations
| Usage Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday light spreadsheet entry | Free | Fill itself is available and works well for basic copy and series filling |
| Need more cloud storage or broader advanced office features | WPS Premium | Better suited if you also need additional benefits beyond this feature |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page