How to shade every other row in WPS Spreadsheet

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.

How to add border in WPS Writer

Take this document as an example.1. Click the Page Layout tab → and click the Page Borders button. Then the Borders and Shading dialog box will pop up. 2. Select Page Border in the Borders and Shading interface. We can use the preset style provided by WPS Office in settings. Here, we can also set the Style, Color, Width and Art according to our needs. We can also preview the borders settings in Preview. 3. Finally, click OK. This skill could also be used in Microsoft Office Word and O....

How to refresh the pivot table in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet.2. Click the Data tab → and then click the Refresh All button. This skill could also be used in Microsoft Office Excel and OpenOffice.

How to delete a pivot table in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet.2. Click the pivot table we want to delete.3. Click the Options tab → and then click the Delete PivotTable button. This skill could also be used in Microsoft Office Excel and OpenOffice.

How to highlight text in a PDF

1. Use WPS Office to open the PDF file. 2. Click the Home tab → and then click the Highlight button.3. We can see the icon of mouse cursor has changed to a pen. Now select the needed content, then the text will be highlighted successfully. With WPS PDF, you can easily read, edit, and manage PDF pages on android and easily convert between PDF and other types of documents. Currently support doc/ppt/word/excel/image/xls.

How to hide gridlines in WPS Spreadsheet

· Option 11. Use WPS Office to open the form.2. Click Menu in the upper left corner → and then select Options in the upper left corner. 3. Select View in the Options popup box, then uncheck Gridline, and click OK. · Option 21. Open the file in WPS Spreadsheet.2. Click the View tab → then uncheck View Gridlines. This skill could also be used in Microsoft Office Excel and OpenOffice.

How to unmerge cells in WPS Spreadsheet

1. Select the cell that needs to be unmerged.2. Click the Home tab → and then click the drop-down button of Merge and Center.3. Now we can see Unmerge Cells and Unmerge and Fill.· Unmerge CellsClick Unmerge Cells. Now we can see the cell has been unmerged, but only the first cell has been filled with content. · Unmerge and FillClick Unmerge and Fill. Now we can see the cell has been unmerged and all the cells have been filled with content. This skill could also be used in Microsoft Off....

How to remove hyperlink

1. Right-click the hyberlink we want to remove.2. Select Edit Hyberlink in the drop-down menu. Then the Edit Hyberlink box will pop up.3. Now click Remove Link. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.