How to print gridlines in WPS Spreadsheet

Take this table as an example.1. Click the Page Layout tab → and then select the Print Titles button in the upper menu bar. Then the Page Setup dialog box will pop up.2. Here, we can check Gridlines in the Print area.3. Click OK. Then we can print gridlines in WPS Spreadsheet. This skill could also be used in Microsoft Office Excel and OpenOffice.

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 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 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 freeze panes in WPS Spreadsheet

We can freeze the panes in three different ways.· Freeze to1. Select the cell below the rows and to the right of the columns that we want to freeze when scrolling.2. Click the Home tab → and then click the Freeze Panes button.3. Now click the first option in this drop down menu. · Freeze First Row1. Use WPS Office to open the form and click the Home tab → and then click the Freeze Panes button.2. Now click Freeze First Row.Then we can easily freeze the first row of this table. · Freeze....

How to import external data in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet, and click the drop-down button of Menu in the upper left corner.2. Choose Data → Import External Data → Import Data, and click OK in the popup window.3. In the Step 1: Select data source interface, click Open data file directly, and Select Data Source..., then we can choose the file as needed. 4. In the File Conversion interface, we can select the encoding that makes our document readable. There are two options of Text encoding, one is Windows....