Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency.

Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painterbutton, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells.

Then how do we use Format Painter to copy and paste the format to multiple cells? Select the cell range in the first row, double-click the Format Painter button, lock the Format Painter function, and click on the cell that needs to be applied. Then we can apply the format to other cells indefinitely. Click the format painter again to unlock.

If we use this method to interlaced filling, it is still a little bit troublesome. So how do we use the format painter to interlace the color we filled? Take this table as an example. First, select the A2:D3 cell range, double-click the format painter, and then select other cell ranges. In this way, we can quickly interlace the color we filled in the table.

What a practical feature! Easy your work with WPS Spreadsheet like Microsoft Excel.Did you get it?