- All Tutorials
- Video Tutorials
- Quick Tutorials
220 Search results
How to use the Excel MID function01:54
How to use the Excel MID function
When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....
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 hide rows in excel
· Hide a single row1. Right-click on the target row for operation.2. Choose Hide from the pop-up list. · Hide rows within a continuous range range1. Right-click to select a continuous row range.2. Choose Hide from the pop-up list. · Hide multiple row selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the rows for operations.2. Right-click on the last row(s) selected, and choose Hide from the list. To be office excel advanced, you could learn how to use....
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....
The COUNTA function in excel
In WPS Spreadsheet, the COUNTA function can help us count the amount of cells left non-empty. · The COUNTA function:=COUNTA(value1, [value2], ...) · Use the COUNTA function for total attendance:In the following example, we use the COUNTA function to calculate total attendance. 1. Enter the formula =COUNTA(C5:C11)2. Press Enter to get the result. As we can see, since 4 cells in total are filled with '√', the result is '4', with the empty cells skipped.Use the COUNTA func....
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....
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....
How to switch data from rows to columns in Excel
1. Select the table for operation, and right-click to copy it (Shortcut key: Ctrl + C).2. Right-click on the cell for the new table → click Special Paste → click Transpose.WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.