How to shade every other row in WPS Spreadsheet

October 19, 2021
93 Views 0

Graphic skills

Take this table as an example. 

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



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



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



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.