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

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

It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

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

In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

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

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