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

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

Split the screen for data comparison

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....

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 draw a column chart in WPS Spreadsheet

A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

How to use Select feature in WPS Presentation

A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....

SUBTOTAL function: Calculate the data with the hidden value

Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

How to set page borders in WPS Writer

When adjusting the page layout of a word document, we can add page borders and change their styles. In this example, if we want to insert page borders of the palm tree style, how can we realize it? First, click the Page Layout tab, and choose Page Borders to pop up the Borders and Shading window. Here we can access the settings of the page borders, including style, color, and width. We can see the page border of palm trees in the category of Art. In the Preview interface, we can choose....