How to unhide rows in excel
When using WPS Spreadsheet to process data, the Hidden Row function can hide the data temporarily not in need. The double line presents in between two columns means one/several column(s) has/have been hidden. For instance, Column B is hidden in the following screenshot. How can we show the hidden rows again in excel?1. Select Columns A to C.2. Right-click on it, and choose Unhide. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
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 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....
Find and replace functions in Spreadsheet
· Option 1:[Find]1. Click Home → Find and Replace → Find 2. Enter the keyword you want to find. [Replace]1. Click Home → Find and Replace → Replace2. Enter the keyword you want to find in the first box, with contents to replace with in the second box. 3. Click Replace to replace the items one by one. 4. You can also click Replace All to replace all items. · Option 2: Use short keys [Find] Ctrl + F [Replace] Ctrl + HTo be office excel advanced, you could learn how to use WPS O....
How to use the data validation feature
We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Since this feature is quite complicated, we only briefly introduce some basic usages here. If you want to learn more, you may feel free to watch more related videos in our WPS Academy.First, select the cell range where we want to fill data, and click the Data tab → the Validation button in the upper menu bar. At this time, the data validation box will pop up. We can s....
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 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 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.