Download WPS Office for your device

We learned how to share and edit files with our co-workers.There are two methods to share files. One is the traditional method that can be set in the Review tab and shared the file through the local area network. Thus, multiple people can work on the file at the same time. You can trace the revision in the records. Another method is to co-edit online. All you have to do is share the link. The receivers do not need to download WPS Office to participate in the cooperation. The editing re....

In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

Excel worksheets are frequently used for teamwork. We want to record and track the modifications made by each member. Today, we will learn how to use the "Track Changes" function.Take this table as an example, we want to get the revision history of the data.First, go to the "Review" tab, and click "Highlight changes" at "Track Changes."Then, check "Track Changes While Editing" to track the changes in your sheet. By doing so, you can highlight the changes including time, reviser, and r....

When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Hyperlinks in the text can jump to the webpage or the specified position in the document. Today, we will learn how to add hyperlinks. · 1. Jump to to a location on the webFirst, place your cursor on where the hyperlink needs to be added, and enter the Insert tab, click Hyperlink to generate a dialogue box. Head to Existing File or Web Page on the....

When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

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

When we use WPS Document to edit documents, we sometimes may want to highlight the key contents in the document. In order to do this, we can add shading colors to the text. So how can we set the shading colors? Take this text as an example. Select the sentences that need to be highlighted, click the drop-down button on the right side of Shading in the upper taskbar, select color, then you can highlight the text you want. If you don't want to select any of the colors above, click Mo....