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

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

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

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

When giving a speech, we often need background music to set off the atmosphere. So how do we insert audio when making slides? Take this slide as an example, click the Insert tab above, and then click Audio. Here we can see Insert Audio, Link to Sound, Background Music and Link Background Music these four options. The difference between Audio and Background Music is that when we choose the Audio option, we can only hear the music when we play the slideshow where the music is inserted. B....

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

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to insert objects into the document by embedding or linking. 1. Embedding ObjectsTaking this document as an example, I want to insert an existing spreadsheet into the document to elaborate on the contents.Place your cursor to where you want to embed an object, then head to the Insert tab, select Object. A dialogue box will....