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

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 highlight the content of a PDF file

When reading the PDF file, we sometimes may encounter some critical text content. To facilitate our reading, we can highlight the needed text. Today, we will show you how to use the highlighting feature of the PDF. Take this PDF file as an example. Click the Comment tab, then click the Highlight drop-down menu. Here, select the color we like, then the selected text will be highlighted.If we want to highlight an area, we can use the area highlighting feature. Click the Highlight Area dr....

Instruction of page setup in worksheet

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....

COUNTIFS function: count data of multiple criteria

We often need to count the number of data in our work, so how can we count them quickly? Here, we need to use a new function, COUNTIFS. The grammatical structure of COUNTIFS is COUNTIFS (range1, criteria1, [range2, criteria2]...) Take this table as an example. Now we want to count how many types of foods are produced in Thailand and also have a sales volume of more than 5,000? There are two criteria that we want to consider. One, the sales volume needs to be greater than 5,000, and the....

How can we set the margins of the table

When printing, in order to make the table meet the expected layout, we need to adjust the margins of the table.Margins are the white space between the contents of the spreadsheet and the edge of the printed page.Get into the Page Layout tab, and click Margins. Then we can see WPS has provided three default styles.Meanwhile, we can also choose Custom margins to adjust the margins more accurately.Click on the text box. Then the sample image in the middle will also provides a correspondin....

How to set the paper size of the table

When printing tables in WPS Spreadsheet, to preview, we need to set the paper size first. So how can we set the paper size?First, click the Page Layout tab above, and then click Size. WPS Spreadsheet has already provided us with a variety of paper sizes. We can click to preview.If we need to adjust more settings for the paper size, we can click More Page Sizes. In the popup Page Setup dialog box, we can set Page Size and Print Quality according to different printers. In general, the hi....

Use the DATEDIF function to calculate the intervals of dates

The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....