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 use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

Look up data quickly with LOOKUP function

Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

Use the ROUND function to round decimals quickly 

In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

How to add a watermark

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

How to use the read mode of PDF files.

With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process&edit pdf documents on both windows, mac pc and android mobiles.Today, We will learn how to use PDF read mode.Click the Home tab before clicking the read mode, then the page will automatically hide other irrelevant function buttons, enabling users' immersive reading. · BookmarksWhen the e-book is too lengthy to read all at once, we can add a Bookmark and name it.1. Right-click the b....

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....

Use text tools to format paragraphs layout quickly

When you use WPS Document, have you ever encountered the situation that you need to reformat after copying text into a document? The Text Tools in WPS Document can help us to format paragraph layout more efficiently. Now we are going to show you how we can use text tools to quickly format paragraphs. Take this press release as an example. We can see that the layout of the text is really messy. So how can we use Text Tools to quickly format the paragraphs? When encountering this kind of....