Get WPS Office for Windows

When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

Hi there, friends. How did you insert audio or videos into slides?You may be familiar with the following procedures: Click Movie in the Insert tab. Click Local video to switch back and forth between different files. If there are multiple videos, you have to pick each one individually before clicking Open.Let's count how many steps are involved? Good news! It takes only one step in WPS Office's latest version. Select the files to insert, and drag them into your slides. Whoosh! T....

In this lesson we have studied the following key points:1. How to create table borders and insert a diagonal line to the table header.l You can click the "Drow border" button to draw the form lines manually, or you can click the "All borders" button, which provides many border styles.l Select the targeted cell first, press the shortcut key "Ctrl+1", select "Border" >select a diagonal line border. 2. How to merge or unmerge cells.WPS Spreadsheet also provides more ways of merging cells....

1.Introduces several causes of pivot table errors.We should standardize the original table. Blank cells in fields, irregular dates format, merged cells, or numerical texts in numerical values will trigger errors.2.Introduced the basic rules of using pivot charts.PivotChart can show the data trend. The X-axis will show the fields in ROWS, while the Y-axis will present the fields in VALUES.3.Slicer can show your leader what they want to see, including fields that aren't in the PivotT....

In this lesson, we learned about the basic use of line and area charts.1.A line chart and an area chart are essentially identical. Both may effectively display data trends over a specific time period, but an area chart is better for displaying the stacked effect.2.The combo of a line chart and an area chart can diversify the data. The right color scheme can make the chart more advanced.3.In the same chart, a combo of line and column charts can display two sets of data with different di....

We have learned how to use the Validation function to restrict the entered content.1.To achieve this, we need to set different rules to restrict, such as the date format, text length, value range, and repeated value. 2.If the cell entry rules are restricted in advance, it is best to set up the corresponding error alert to help each other to enter in accordance with the specifications. 3.We also learned the method to create the drop-down menu and multi-level menus with the INDIRECT func....

In this lesson, we have learned several ways to set conditional formatting. 1."Highlight Cells Rules" and "Top/Bottom Rules." They can highlight cells quickly and draw people's attention to data that matches the conditions. 2.Data bar, Color Scales and Icon Sets can visualize data and make them clearer to recognize. 3.We also learn how to add multiple formatting to data using the AND function.In the selected area, we can set multiple conditions, delete specific rules or clear all ....