How to use the Format Painter tool in WPS Spreadsheet

Uploaded time: February 24, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

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.