- All Tutorials
- Video Tutorials
- Quick Tutorials
437 Search results
How to extract and replace the page content of a PDF file01:23
How to extract and replace the page content of a PDF file
When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....
Quickly replace the content and font in WPS Presentation01:40
Quickly replace the content and font in WPS Presentation
When using WPS Presentation, we want to make changes to the specified content or font of the text. Take this slide as an example. If we want to quickly replace WPS in the text with WPS Office,Click the Home tab, then click the Replace drop-down button and choose Replace.Or use the shortcut key Ctrl+H.In the pop-up dialog box, enter WPS in the edit box. We can also set the replacement conditions as needed, such as Match case and Find whole words only.In the Find what box, enter WPS. Whi....
How to quickly locate and replace data02:12
How to quickly locate and replace data
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....
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 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 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....
How to delete blank rows of table in batches00:51
How to delete blank rows of table in batches
When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....
How can we add or remove text shading01:20
How can we add or remove text shading
When using WPS Writer to edit documents, we can add shading to highlight some parts of the text content. So how can we add and remove text shading? Take this document as an example. If we want to highlight the students mentioned in the notice, we can select this part of the content and click the Character Shading command button in the Home tab. By this, we can quickly add a gray shading to the selected content. Gray is the default color. If we want to delete the shading, just click the....