How to delete blank cells in WPS Spreadsheet

1. Open the table in WPS Spreadsheet.2. Click the Home tab → and then select the Find and Replace button.3. In the drop-down menu, click Go To. Then a Go To dialog box will pop up. We can also use its shortcut key Ctrl+G to open it.4. Check Blanks in the Go To dialog box, then click the Go To button in the upper right corner. 5. Now we have successfully selected all the blank cells. Right-click to select Delete in the drop-down menu. WPS Spreadsheet has provided us with different ways ....

How to move cells in a worksheet

Here are two options to move cells in a worksheet.· Option 1: Move cells by dragging1. Select the cells we want to move.2. Move the cursor to the edge of the row, until the dragging symbol (+) presents.3. Drag the selected cells to the target place. · Option 2: Move cells by cutting and pasting1. Right-click on the cells to be moved.2. Choose Cut from the drop-down list. (Shortcut key: Ctrl + X)3. Right-click on the target cells, and choose Paste in the drop-down list. (Shortcut key: C....

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 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 make a double slashes header in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet, click the Insert tab and then click the Shapes button. Select a straight line from the drop-down menu. Then insert a straight line into the table. 2. Insert a straight line again.3. Click the drop-down button of Text Box in the Insert tab, and select the Horizontal Text Box.4. Then draw a text box at the designated position, and enter the needed text in the text box. We can adjust the text box according to our needs. If the content in the text....

How to unmerge cells in WPS Spreadsheet

1. Use WPS Office to open the table, select the merged cells, and click the Home tab. 2. Then click the drop-down button of Merge and Center.3. We can see two ways to split cells in WPS Spreadsheets: Unmerge Cells and Unmerge and Fill.We can choose one of them according to our needs.This skill could be also used in Microsoft Office Excel and Openoffice.