- All Tutorials
- Video Tutorials
- Quick Tutorials
656 Search results
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....
Arrange tools in WPS Presentation01:32
Arrange tools in WPS Presentation
Arrange tools in WPS Presentation allow users to adjust the object layout, group objects, and rotate objects. The Arrange tools make it easier to manipulate images, shapes, and other elements. Usually, the latest created object is placed at the front of a slide.If we want to change the object layouts, here are the steps.1. Choose an object.2. Go to Home and click Arrange. 3. Choose Bring to Front in the drop-down menu. Another option to realize it is shown below.1. Select the object.2.....
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 ....
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....
How to crop pictures in WPS Presentation01:19
How to crop pictures in WPS Presentation
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....
Edit settings in WPS Spreadsheet03:47
Edit settings in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....
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....