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 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 move rows in a worksheet
How can move row(s) in WPS Spreadsheet? Here are two options to realize it. The methods could be used for a single row or a continuous row range.(Relavent tutorial: How to move columns in a worksheet) · Option 1: Move a single row by draggingSelect a whole row.Move the cursor to the edge of the row, until the dragging symbol (+) presents.Drag the selected row to the target place.Option 1: Move a single row by dragging · Option 2: Move a single row by cutting and pastingRight-click on t....
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 sort a pivot table
1. Open a Spreadsheet with Pivot Table.2. Place the cursor on the heading cell of the data we want to sort.3. Then click the small drop-down button on the bottom right corner of the cell.4. In the drop-down menu, we can select Ascending or Descending according to our needs. 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 hide columns in excel
· Hide a single column1. Right-click on the target column for operation.2. Choose Hide from the pop-up list. · Hide a columns within a continuous range range1. Right-click to select a continous column range.2. Choose Hide from the pop-up list. · Hide multiple column selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the columns for operation.2. Right click on the last column(s) selected, and choose Hide from the list. To be office excel advanced, you cou....
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....