Use format painter to adjust the styles in batches

Uploaded time: September 27, 2021 Difficulty: Primary

Use format painter to adjust the styles in batches

Use format painter to adjust the styles in batches

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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 Painter button, 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.

_1.gif

 

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.

_2.gif

 

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.

_3.gif

 

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