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

WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

After inserting a picture in WPS Presentation, we can use the Crop tool to modify the shape and the scale of the picture and make it look better. Select the picture in the presentation to get into the Picture Tools tab, and click the Crop drop-down button.There are two different crop modes to choose from, Crop by Shape and Crop by Scale. · 1. Crop by ShapeHere, WPS Office provides us with a variety of shapes.If we want to crop the picture to a rounded rectangle, click Rectangle and sel....

PDF is a highly compatible format that occupies little space and is easy to transfer. We often need to convert Word documents into PDF files in daily study and work. Here are the steps. Take this word document as an example.Click the Menu button and select Export to PDF. In the pop-up dialog box, click the small icon on the left of the file name to modify the file's name. We can set the output range as needed in terms of multi-page documents. To add multiple documents to convert at....

To give a fluent presentation, we can insert a video into a slide as supplementary material to avoid switching back and forth. In addition to inserting videos, WPS Presentation also supports trimming media. Take this presentation as an example. 1. Select the video. 2. Then WPS Presentation jumps to Video Tools automatically.3. Here we can click Volume to set its volume. For example, we choose Low. 4. If we need to trim the beginning and end of the video, click Trim Media.5. In the Trim....

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Presentation, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here....

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