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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

When processing data in a Spreadsheet, we somtimes quickly need to locate the data among various data, or modify incorrect data in bulk. It would be convenient to use the Find and replace fucntion in WPS Spreadsheet. This video could be used in Microsoft Office Excel and Openoffice. Take the following table as an example, which records students’ grades on various subjects. Supposed that we want to find the E grade from the sheet. 1. Select all those ranges of cells that we want to find....

After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....