When we use WPS Spreadsheet at work, if we want to quickly copy the formatting of a cell to another cell, we can use the Format Painter function in WPS Spreadsheet. Take this table as an example. We now want to copy and paste the formatting of cell A1 to cell D1.

1. Select cell A1.

2. Click the Home tab first and then click the Format Painter button.

3. Now select cell D1.

There you can copy and paste the formatting of cell A1 to cell D1.

But how can we use Format Painter to copy and paste the formatting to multiple cells?

1. Select cell A1, first double-click the Format Painter button to lock the Format Painter function.

2. Select the cell that has the formatting you want to copy.

In this way, we can copy and paste the formatting of cell A1 to multiple cells. Click the Format Painter again to stop formatting.

In addition, we can also use the format painter to interlace the color you filled. Take this table as an example.

1. Set the color of the A1:C2 cell area.

2. Select the A1:C2 cell area, then double-click the Format Painter.

3. Select the other cell areas.

In this way, we can now use the format painter to interlace the color you filled.

By using the Format Painter and Find function, we can also quickly copy and paste the specified cell formatting into cells with the same content. If we want to fill all “WPS Academy” cells in the table with the same color formatting as the A1 cell “WPS Academy”.

1. We first need to select cell A1 and double-click the Format Painter.

2. Then use the shortcut key Ctrl+F, enter “WPS Academy” in the pop-up search dialog box, and click to search all.

3. Now use Ctrl+A, we can quickly copy and paste the formatting of cell A1 into the cell being found here.

This video could be also used in Microsoft Office Excel and Openoffice. What a practical function, did you get it?

How to delete background in WPS spreadsheet?