WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Use format painter to adjust the styles in batches

Uploaded time: September 27, 2021 Difficulty Beginner

Use format painter to adjust the styles in batches

Use format painter to adjust the styles in batches

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?

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