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 the Format Painter tool in WPS Spreadsheet

Uploaded time: February 24, 2022 Difficulty Beginner

How to use the Format Painter tool in WPS Spreadsheet

How to use the Format Painter tool in WPS Spreadsheet

Do you format cells one by one when editing a table? The Format Paintertool can quickly copy the specified format and paste it into several cells.

Take this table as an example. Assume that we want to copy the format of cell A1, and apply it in several cells.

Select  cell A1, click Edit, and open the tools bar. In the Home menu bar, select Format Painter.

Click the cells you want to apply the format to paste the format.

If you drag the triangle symbol, this cell format will be pasted in the continuous range of cells.

After completing the setting, how can we exit the edit state of the format painter? You can simply click Done in the upper right corner.

We can also fill  the desired cells with color across columns using the Format Painter.

Select the format range of cells you want to copy, activate the Format Painter function, click on the fourth row of the table, and drag the triangle symbol down.

In this way, we can quickly interlace the color we filled in the table.

We can also use format painter across sheets.

For example, now we want to copy the format in sheet 1 and paste it in sheet 2. Switch the sheet and click the desired cell, then the cell format will change accordingly.

In WPS Office on PC, the use of Format Painter is more diversified. It's recommended to use this function in WPS Office on PC.

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