Download WPS Office for your device

When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

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

1.We only need to set the logical value in advance, we can use the IF function to quickly determine whether the data meet the conditions.2. When we want to meet more than one condition at the same time, we can use the AND function; when we want to meet only one of the conditions in the case of multiple conditions, we can use the OR function.3. share how to use the function combination of IF+AND+OR in practical work.

Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....

1. How to set the data format.2. How to enter the correct date and time formats.3. How to make number format and text format convert to each other.4. How to flexibly utilize the custom format.

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

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 our life and study, we often need to copy the text content of different pages to WPS Document in order to save records. Sometimes copying and pasting text into WPS Document can lead to a messy layout of the content, and also the font size may not be uniform. In this case, we can use the Clear Formatting function. It can clear all the formats of the selected text and only keep the unformatted text. Take this document as an example, the text has a messy layout, and also the font size ....