- 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....
How to set Picture Effect in WPS Presentation02:24
How to set Picture Effect in WPS Presentation
You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.Pictures of WPS demonstration can make the slide more professional and appealing. We can also add effects to the pictures to make them cooler. Take this slide as an example, select the inserted pictures, click the Picture Tools tab at the top, then click Picture Effects before clicking More Picture Effects. Next, I will demonstrate different effects one by one. 1.ShadowAdding....
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 use WPSArt in WPS Presentation01:51
How to use WPSArt in WPS Presentation
Are you still struggling to create a hierarchy like this one when you use WPS Presentation to make the company's annual report? Next, let's learn how to quickly create a hierarchy. Click the Insert tab and the WPSArt button to pop up the Insert WPSArt Dialog pane. Here, we can see the different types of Hierarchy. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Click Hierarchy, and select one of the styles, finally c....
How to set bullets in WPS Presentation01:08
How to set bullets in WPS Presentation
Adding bullets to the text content can play a role in highlighting and make our slides look more layered. So, how can we add bullets? Select the text content that needs to be added with bullets, click the Home tab above, and then click the Bullets button. Here, we can see the various preset bullets animations provided by WPS. We can also set the color and size of the bullets as needed.If there is no required bullet, we can click Bullets first and then click More Bullets. In the pop-up ....
How to set Shape Effect in WPS Presentation02:36
How to set Shape Effect in WPS Presentation
Have you ever felt that simply inserting WPS Office's own shape is slightly monotonous? Inserting poorly designed graphics deters us from standing out in work. Learning to use the Shape effect of WPS demonstration can make your slides more professional. Take this slide as an example, select the inserted graphic, click the Drawing Tools tab at the top, then click Shape Effects before clicking More Shape Effects. Next, I will demonstrate different effects one by one. 1. ShadowAdding ....
The Camera in WPS Spreadsheet01:44
The Camera in WPS Spreadsheet
Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....
How to insert and find bookmarks in WPS Writer01:13
How to insert and find bookmarks in WPS Writer
No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....