- All Tutorials
- Video Tutorials
- Quick Tutorials
434 Search results
Clear and avoid duplicates entries in WPS Spreadsheet01:56
Clear and avoid duplicates entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....
How to find the specified text content in WPS Presentation01:06
How to find the specified text content in WPS Presentation
When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....
Use data check method to quickly find difference items01:40
Use data check method to quickly find difference items
Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....
How to use the Excel MID function01:54
How to use the Excel MID function
When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....
How to find, replace, and locate content02:27
How to find, replace, and locate content
When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....
How to highlight duplicates in a worksheet
1. Open the spreadsheet with WPS Spreadsheet. 2. Select a range of cells for operation. 3. Click the Data tab → Highlight Duplicates → Set…4. Click OK in the popup “Highlight Duplicates” dialog. WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and support for video, images, audio, and even Flash.
Clear and Avoid Duplicates Entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some two options to delete duplicates. · Option 1: 1. Select a range of cells. 2. Get into the Data tab → click the Highlight Duplicates dropdown button3. Pick the Set option from the drop-down list. Then, duplicated cells within the selected range will be highlighted.4. Right-click to select the fifth row → choose Delete in the popup menu· Option 2: 1. Se....
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....