- All Tutorials
- Video Tutorials
- Quick Tutorials
515 Search results
How to split sheets by content01:16
How to split sheets by content
When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....
How can we create a drop-down list01:33
How can we create a drop-down list
How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....
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....
Insert Table of Figures and refer to the List of Captioned Objects01:20
Insert Table of Figures and refer to the List of Captioned Objects
When there are too many pictures or tables inserted into a document, we can make a table of figures. It can generate a list of captioned objects and their page numbers for quick location. So how do we insert the table of figures? In this document, for example, we have inserted 6 images with captions.Click the location where we need to insert the table of figures, and click the Insert Table of Figures button on the References tab to get a dialog. On the left side of the dialog, we can ....
Quickly filter classified data01:41
Quickly filter classified data
How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....
Set input conditions and drop-down menus01:54
Set input conditions and drop-down menus
The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....
How to view two documents side by side in WPS Writer00:54
How to view two documents side by side in WPS Writer
No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....
SUBTOTAL function: Calculate the data with the hidden value02:33
SUBTOTAL function: Calculate the data with the hidden value
Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....