- All Tutorials
- Video Tutorials
- Quick Tutorials
641 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 insert Page Break in WPS Spreadsheet00:48
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....
How to set slide transitions in WPS Presentation02:00
How to set slide transitions in WPS Presentation
Appropriate transitions make slides more professional and attractive. So how can we set transitions when creating a Presentation document? Click the slide that we want to add transition animations, and click Transitions.WPS Office provides us with multiple slide transitions, such as Morph, Wipe, Push, Cube, Airplane and so on.Having selected the desired transition, click Effect Options to set the orientation and transition mode of the animation.We can apply it with one click. If we th....
Use the Mail Merge function to input tabular data quickly01:49
Use the Mail Merge function to input tabular data quickly
WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....
How to create a scatter chart in WPS Spreadsheet02:53
How to create a scatter chart in WPS Spreadsheet
A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....
How to convert PDF files into pictures01:59
How to convert PDF files into pictures
We use powerful PDF in our daily life nearly every day. WPS pdf converter is easy and free for people to use.When viewing a PDF file, we may want to save the file content as a picture. So how can we do that? Take this file as an example. Click the Tools tab, then click PDF to Picture. Now a dialog box will pop up. Here, we can set the converted picture, such as Watermark, Pages, Quality and so on.We can choose output By Page or output Long picture according to actual needs.As for the u....
Apply Slide Masters Quickly00:55
Apply Slide Masters Quickly
We may sometimes need to apply a pre-set slide master to the current page when editing a slide.Do you know how to make it? Take this slide as an example. Click Design and then click Edit Slide Master, and we can see there are three different slide masters. So how can we apply "a master with the WPS Academy logo" to the current page? First, click Design, and click Involved Template.In the pop-up dialog box, we can select the desired slide master. And we can also select Apply Current or....