How to shade every other row in WPS Spreadsheet

October 19, 2021
572 Views 0

Take this table as an example. 

1. Set the color of part of the table according to our needs.

1.gif

 

2. Select this area and double-click the Format Painter.

2.gif

 

3. Then select the table areas we want to shade.

3.gif

 

In this way, we can quickly shade every other row in WPS Spreadsheet.

 

This skill could also be used in Microsoft Office Excel and OpenOffice.

Was this helpful?