How to switch rows and columns in WPS Spreadsheet

How to switch rows and columns in WPS Spreadsheet1. First use mouse to select all table contents.2. Use the shortcut key CTRL+C to copy cell contents. 3. Click the sell where we want to put the table.4. Then right-click Paste Special → Transpose. Now the horizontal data is changed to vertical. Remember to select the original data and right-click to delete.This skill could also be used in Microsoft Office Excel and OpenOffice.

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....