How to move columns in a worksheet

We can move multiple columns (whether continuous or not) in WPS Spreadsheet.Here are two options to realize it. The methods could be use for a single column or a continuous column range. (Relavent tutorial: How to move rows in a worksheet)· Option 1: Move a single column by dragging1. Select a whole row or column.2. Move the cursor to the edge of the column, until the dragging symbol (+) presents.3. Drag the selected column to the target place.Option 1: Move a single column by dragging....

How to set the series fill type in WPS Spreadsheet

1. Select the cells we want to fill. 2. Click the Home tab → click the Fill drop-down button → select Series in the drop-down menu. 3. In the popup Series dialog box, we can set the type of series fill in Type. WPS Spreadsheet provides us with four different types, namely Linear, Growth, Date, AutoFill.4. After settings, click OK. This skill could also be used in Microsoft Office Excel and OpenOffice.

How to delete the check box in WPS Spreadsheet

1. Open the file in WPS Spreadsheet.2. Click the Home tab → and then click the Find and Replace button.3. In the popup drop-down menu, choose Select Objects. 4. Now we can select the check box. Place the mouse on the check box, and click on it when the cursor turn into a 4-arrow symbol.5. Then press the Delete key. This skill could also be used in Microsoft Office Excel and OpenOffice.

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 do subscript in WPS Spreadsheet

1. Open the Spreadsheet in WPS Office.2. Select the needed cells.3. Right-click to select Format Cells in the popup drop-down menu. We can also use its shortcut key Ctrl+1 to open it. 4. We can now see the Font interface of the Format Cells dialog box. Here, check Subscript in the Effects area. We can also preview the effect in the Preview area.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.

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