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

Insert comments in PDF files

WPS Office fulfils our needs to mark on a PDF. It provides various kinds of comment or marking functions. Today, you will learn practical methods of using the Note function in WPS PDF. If you want to make notes for certain content on a PDF, you can insert a comment into the corresponding place. To realize it, get into the Comment tab and click the Note button. You can also find the Note button in the Insert tab. Choose a color for your note and click on any place on the page to insert ....

How to insert pictures in Document

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

How to insert attachments in WPS presentation

When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....

How to insert video in WPS Presentation

When making slides, we can make the presentation look more professional by inserting video adequately in slides. So how can we insert videos?Take these slides as an example. Click the Insert tab above, and then click Movie. Here, we can choose Local Video or Link Localvideo. The main difference between them is the way of saving the video files.Please note that: if we choose Link Localvideo to insert a video, once we send the slides to other devices, WPS Presentation may not be able to ....

How to insert shapes in WPS Presentation

Shapes inserted in slides could make a presentation more attractive. How can we insert shapes in a presentation document? First, click the Insert tab, and click the Shapes button. In the selection list, we can see that there are different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, Callouts, and an Action button. Here we take the shape of Heart, which could be found in the Basic Shapes drop-down list. Insert it by....

How to insert and set pictures in WPS Spreadsheet

When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....

How to insert Page Break in WPS Spreadsheet

When we want to print a table but do not want to print all the contents on one page, we can Insert a Page Break to break the table into different pages. First, click the Page Layout tab. Click the Page Break Preview button to enter the Page Break Preview mode, where we can see only one page.Select a cell in the page break preview state and click Insert Page Break to generate split lines on the top and left of the selected cell. Now the table is split into four pages. If we select one r....