WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to use flash fill to quickly fill in data

September 28, 2021

Use WPS Office to open the table and select the cell need to be operated.

Place the mouse cursor at the lower right corner of the cell, when the cursor turn into a cross, click and drag down to select all the cells that we want to fill data.

Then click the icon appeared in the lowerright corner, then select Flash Fill in the drop-down menu (or use shortcut key Ctrl+E).

Note: Flash Fill can provide a filling rule that best meets the users' needs by comparing the relationship between strings.

The more correspondences we provide, the more accurate the judgment can be.

This skill could be also used in Microsoft Office Excel and Openoffice.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.