- All Tutorials
- Video Tutorials
- Quick Tutorials
644 Search results
Hyperlink in WPS Office Spreadsheet02:22
Hyperlink in WPS Office Spreadsheet
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....
Set the page printing area in WPS Office Spreadsheet00:47
Set the page printing area in WPS Office Spreadsheet
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....
How to set the view effect of WPS components01:42
How to set the view effect of WPS components
In the process of using WPS Office, we can set the overall view effect of WPS components for personal use. Take the components in WPS Writer as an example. Click Menu and choose Options. At this time, a dialog box will pop up. In the left tab, the first one is View. In this interface, we can set Show, Print, options, Formatting marks and Ribbon options. +In the Show box, we can set Status bar, Mini Toolbar. +In the Print options box, we can set the content that needs to be displayed. F....
How to insert audio in WPS Presentation01:36
How to insert audio in WPS Presentation
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....
How to set the view effect of WPS Presentation01:51
How to set the view effect of WPS Presentation
When using WPS Presentation, we can set the view effect according to our personal preferences and habits.Click Menu and choose Options.In the popup dialog, click View.In this interface, we can set up Show, Thumbnail and outline position, Slide show and Ribbon options. In the Show area, we can check the elements that need to be displayed, such as Startup task window, Status bar, Vertical ruler and so on. Then, click OK to change the view settings. In addition, we can also check Show Min....
COUNTIFS function: count data of multiple criteria01:57
COUNTIFS function: count data of multiple criteria
We often need to count the number of data in our work, so how can we count them quickly? Here, we need to use a new function, COUNTIFS. The grammatical structure of COUNTIFS is COUNTIFS (range1, criteria1, [range2, criteria2]...) Take this table as an example. Now we want to count how many types of foods are produced in Thailand and also have a sales volume of more than 5,000? There are two criteria that we want to consider. One, the sales volume needs to be greater than 5,000, and the....
Smart use of Hyperlink in WPS Writer01:49
Smart use of Hyperlink in WPS Writer
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....
How to adjust line spacing of the text01:18
How to adjust line spacing of the text
After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....