Download WPS Office for your device

How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....

The selection feature in WPS Writer is diversified and can meet a variety of needs.· Select AllTake this document as an example. Click the Select drop-down button in the Home tab, and click Select All to select the whole text, or use the shortcut key Ctrl+A. Now click any area with the mouse to cancel the selection. Here are some other shortcuts for text selection:1. Double-click the mouse quickly. Then WPS Writer will automatically select the byte, that is, a word. 2. First select a c....

A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....

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

We often need to sort the data to organize the table in our work, so how can we sort the data in a table? Take this table as an example. We want to sort the Overall result of this table from largest to smallest.1. Select the cell range in the Overall result column, and click the Home tab, then click the Sort drop-down button.2. Select Descending in the drop-down menu, and then select these two options Expand the selection and Continue with the current selection in the pop-up Sort Warni....

We often insert pictures when editing documents, If we want to crop the picture, what should we do? After clicking the picture in the document, we can click the Crop drop-down button under the Picture Tools tab. We can choose Crop by Shape or Crop by Scale in the selection list.If we want to crop the picture into an oval, click Oval in the Basic Shapes selection list, and an oval will appear in the picture. The shaded part is the part that is cropped. There are four small black lines i....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. When we want to protect a document, we usually want to encrypt it and prevent editing. Today, we will compare the WPS Writer with Microsoft Word regarding the Encryption function. First, let's start with Microsoft Word. There are two ways to encrypt documents in Word.For the first method, we need to head to the Info interface, click Protect D....

When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....