When we use WPS Office to print documents, we often encounter a variety of printing glitches. So in this video, we are going to briefly explain the effects of each small function in the print panel. Let's take this thesis as an example. First, we need to make sure that the hardware device of the printer is normal and on-state. Meanwhile, we also need to determine whether the computer used can find your printing device in LAN. 1. Click Menu and Print. The Print dialog box also can b....

Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

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,....

We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

When using WPS Office to print Spreadsheets, Documents, Presentations, and PDF files, we will often encounter various printing problems. So in this video, we are going to briefly explain the functions of each small feature in the print panel. Take this table as an example. 1. First of all, we need to make sure that the printer is in good condition and also ready to print. 2. In addition, we need to make sure the computer we are using can find the printing device in the local area netwo....

PivotTable enables us to create various tables by changing its fields on each area as a kind of interactive table. With PivotTable, we can analyze and process complex data tables quickly. Take this raw data sheet as an example, which displays the sales of each branch of a brand. Now we can start to analyze its data. For example, we can analyze the total sales of each branch, the total sales of each item sold in each branch, the total sales of each item sold in each branch in each sales....

Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....

If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....