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 duplicate a sheet in WPS Spreadsheet

· Option 1:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Duplicate Sheet. · Option 2:1. Use WPS Office to open the sheet.2. While pressing the Ctrl key, click the left mouse button to drag the sheet to the desired position. Then, we can complete the copy of the sheet. · Option 3:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Move Sheet.3. In the pop-up dialog, choose Move t....

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 rotate text in WPS Spreadsheet

1. Enter the text content that needs to be rotated in the cell.2. Click the right mouse button, and click the Format Cells option in the shortcut menu.3. In the pop-up dialog box, click the Alignment tab.4. In the Orientation area, We can set the degrees of rotation according to the actual needs.5. Finally, click the OK button. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to show gridlines in WPS Spreadsheet

· Option 11. Use WPS Office to open the spreadsheet.2. Click the View tab, and check View Gridlines. · Option 21. Use WPS Office to open the spreadsheet.2. Click Menu → Options → View.3. In the Window options box, click Gridlines.4. Finally, click OK. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to unlock excel sheet in WPS Spreadsheet

· Option 1If we have set up password protection:1. Use WPS Office to open the spreadsheet.2. Click the Review tab.3. Click the Unprotect Sheet button.4. In the pop-up Unprotect Sheet dialog box, enter the password you set before, and then click OK. · Option 2 If there is no password protection:1. Use WPS Office to open the spreadsheet.2. Click the Review tab.3. Click the Unprotect Sheet button. Then we can unlock excel sheet in WPS Spreadsheet. To be office excel advanced, you could le....

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