2088 results for how do you use drop box
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2088 results for how do you use drop box
How much do you know about data format 2
10:25How much do you know about data format 2
In this lesson we have studied the following key points:1. How to make number format and text format convert to each other?In WPS Spreadsheets, when the number entered exceeds 11 digits, it will be automatically converted into text.Text format has the following 3 features: it is aligned to the left by default; it is unable to participate in calculation; a green corner prompt will appear in the upper left corner of the cell will. The way to convert text format into number format is as ....
How to insert calculated fields in PivotTable
01:06How to insert calculated fields in PivotTable
Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....
How can we create a drop-down list
01:33How 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 document comparison function
01:40How to use the document comparison function
After modifying the document, we can compare it with the original document and generate the revised document if we want to view the modification trace. Next, I will show you how to use the comparison function through a case. Take "Document 2" as an example. Click the Review tab and the Compare drop-down button, and choose Compare. Then, a dialog box will pop up. In the Original document box, select "Document 1". In the Revised document box, select "Document 2". In the Label changes wit....
Edit text contents in PDF
01:54Edit text contents in PDF
Do you know how to edit a PDF? What if we need to correct something wrong in a PDF?Go to WPS Premium, and you will be able to use the editing feature. For example, if you want to edit the title, get into the "Edit" tab, and click the "Edit Content" drop-down menu. By checking the "Show Text Boundary" option, you will see the text contents in the PDF presenting in text boxes.Click the text box, then you can edit the text content in the PDF. Right-click to copy, paste, cut, or delete the....
How to insert a text box in Spreadsheet
03:13How to insert a text box in Spreadsheet
The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....
Split Books by Sheet
01:09Split Books by Sheet
Do you know how to split your worksheet?Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet. In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down m....