- All Tutorials
- Video Tutorials
- Quick Tutorials
650 Search results
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....
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 customize the font in WPS Writer02:06
How to customize the font in WPS Writer
When using WPS Writer, how can we customize the font for a document? In the toolbar of Home, users can simply set the Font, the Size, etc. For advanced settings for font, click the drop-down button next to Menu, choose Format and Font, then you can see the interface for Font setting. You can also press the shortcut Ctrl+D to pop up the dialog. In this interface, we can change the settings for Latin text font and Asian text font, which include fonts, Font style and Size. You can also c....
How to set the text direction in WPS Writer01:45
How to set the text direction in WPS Writer
Usually, when editing a document, the text is input horizontally from left to right by default. In the following video, we will teach you how to change the direction of the text. First, select the text that needs to be changed, and click the Text Direction drop-down button in the Page Layout tab. Here, we can see six styles in the list. 1.Horizontal Text Box: This is the default text direction in WPS Writer. 2.Vertical from right to left: At this time, the text is vertical and aligned ....
How to change my default PDF file to WPS Office
1. Right-click the file on our computer and select Open With → Select Choose another app.2. Check Always use this app to open .pdf files.To be office specialists, you could learn how to use WPS Office online in WPS Academy.
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
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....
Adjust shape fill in WPS Presentation01:33
Adjust shape fill in WPS Presentation
When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. How can we change the design of shape fill and outline? Left-click the inserted shape, and get into the Drawing Tools tab. Then click the Shape Fill button. There are two options. One is to choose the default style provided by WPS Office,....
Adjust shape outline in WPS Presentation01:41
Adjust shape outline in WPS Presentation
When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. How can we adjust the outline for an inserted shape? Left-click the shape, and get into the Drawing Tools tab. Then, click the Shape Outline dropdown button to change the settings of the shape outline, including colors, thickness, and outline style. To change the outline color, we can either choose one from the default styles provided by WPS ....