WPS Fill on iOS: Introduction

Last updated:July 20, 2026

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

MetricValueNotes
Core tasks2Matches the number of rows in the How-to Index
Available without membership2Matches the number of Free rows in the index
Membership-related items0Matches 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

ItemRequirement
Operating systemAn iPhone or iPad that can run WPS Office normally
App versionThe latest version of WPS Office is recommended
NetworkNo required network connection for local fill actions; internet access is needed for download, sign-in, or sync
OtherYou 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.

ItemDetails
Official downloadWPS Office Free Download
Post-install checkOpen 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

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryProvides 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 AdvantagesAdvantage: 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 SourceFill data automatically in worksheet cellsGoogle Docs product pageNotion AI for databases – AutofillFill 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.ScenarioSuitable ForMain Pain PointHow Fill Helps
1Copying the same content in batchesMobile office usersNearby cells need the same text or number repeatedlyUse Fill and switch to Copy Fill to extend the same value across the target area
2Creating continuous numberingSpreadsheet record keepersManual numbering is slow and easy to get wrongUse Series Fill to increase or decrease numbers automatically
3Extending date sequencesScheduling and reporting usersEntering dates one by one takes timeSet a starting pattern and use Series Fill to continue it
4Organizing horizontal or vertical data quicklyLight spreadsheet usersThe same content must appear across rows or columnsDrag in four directions to fill adjacent cells efficiently
5Adjusting the fill result during editingUsers who review as they goThe first fill result should be copied instead of extended, or the reverseSwitch 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 AreaFree UsersWPS Premium
Fill in spreadsheets✅ Available✅ Available
Basic spreadsheet editing✅ Available✅ Available
Additional advanced office and PDF benefitsDepends on the in-product plan displayIncludes more advanced capabilities and extended benefits
Cloud storage1 GB20 GB

Source: WPS Office pricing page

Recommendations

Usage ScenarioRecommended PlanWhy
Everyday light spreadsheet entryFreeFill itself is available and works well for basic copy and series filling
Need more cloud storage or broader advanced office featuresWPS PremiumBetter suited if you also need additional benefits beyond this feature

How to Subscribe

Source: WPS Office pricing page