More features in Split and Merge

In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

How to create a table with one click

Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....

How to make conference table cards in batches

Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

Content layout basics

After we have entered the data, we need to make some basic content layout adjustments to make our table look clearer and more beautiful.How should we do it? Next, I'm going to do this in five steps. · 1. Add serial numberThe first column of a table usually adds a serial number to make the contents of the table easier to see. Take this table as an example. Select column A, right-click, choose the Insert option to insert a new column in front of the selected column and enter Serial n....

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

How to set up multilevel numbering in WPS Writer

When editing a long article, we can insert bullets and numbering to present the article structure clearly. In the following example, you will see a demonstration to create multilevel lists. Here are the steps. 1. Select the text to be numbered. Next, go to the Home tab, click the Numbering drop-down button, and choose More Numbering. The series of operations will pop up the Bullets and Numbering dialog. 2. Click the Outline Numbered tab inside. After that, we can see several numbering ....

How to link WPS Writer and Spreadsheet together

In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

Learn PivotTable from scratch

PivotTable enables us to create various tables by changing its fields on each area as a kind of interactive table. With PivotTable, we can analyze and process complex data tables quickly. Take this raw data sheet as an example, which displays the sales of each branch of a brand. Now we can start to analyze its data. For example, we can analyze the total sales of each branch, the total sales of each item sold in each branch, the total sales of each item sold in each branch in each sales....