Download WPS Office for your device

Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

Do you know how to edit a PDF? What if we need to correct something wrong in a PDF?Go to WPS Premium, and you will be able to use the editing feature. For example, if you want to edit the title, get into the "Edit" tab, and click the "Edit Content" drop-down menu. By checking the "Show Text Boundary" option, you will see the text contents in the PDF presenting in text boxes.Click the text box, then you can edit the text content in the PDF. Right-click to copy, paste, cut, or delete the....

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

We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office？ First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....

The main knowledge points of this lesson are the following 3 points1. Smart Split Columns can identify the contents and split them. There are four techniques for splitting columns based on text features: Delimiter, Text Type, Keyword, and Fixed Width. 2. Data formats can be standardized in addition to splitting columns. For example, numerical dates can be standardized dates, and numerical formats can be turned into text formats. 3. Ampersand operator and smart filling(Ctrl+E) can merg....

When editing chemistry and mathematics data, we often use superscript or subscript to represent special symbols. Take this document as an example, m2 represents the square in the unit area. How can we set the number 2 as a superscript? Select the number 2. In the Home tab, click the Superscript button. Or we can use the shortcut key Ctrl+Shift+= to set the number as a superscript.Numbers in some chemical symbols need to be set as subscripts, such as O2, N2. Select the number 2 in O2. I....

When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....