More features in Reading Layout

Faced with huge amounts of data, we find it difficult to locate the selected cell or cells range. At this point, Reading the Layout can help a lot. Microsoft Excel doesn't support reading mode without plug-ins, while WPS Spreadsheets has the function of Reading Layout. Take this table as an example. 1. Click the View tab, and click the Reading Layout button to select a preferred color.2. When you click a cell, the row and column it lies in are highlighted. You can easily find the s....

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

Use Date function to convert date format

We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

More features in Screenshot

Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....

How to merge and split PDF files

WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....

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 convert Excel to PDF

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....