We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....

Now we have already set up a custom numbering style. Where can we find and modify it? Take this document as an example. We have already added the multilevel numbering to the file. At this time, we want to quickly switch to the customized numbering style. Click the Numbering drop-down button in the Home tab, and then click More Numbering to pop up a dialog box.In the Custom List tab, we can see all the custom numbering styles we set on the left. If you want to delete a custom numbering ....

Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....

When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....

How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....

We learned how to share and edit files with our co-workers.There are two methods to share files. One is the traditional method that can be set in the Review tab and shared the file through the local area network. Thus, multiple people can work on the file at the same time. You can trace the revision in the records. Another method is to co-edit online. All you have to do is share the link. The receivers do not need to download WPS Office to participate in the cooperation. The editing re....

You have learned two types of charts in today's lesson: pie charts and sparkline charts.1.Pie charts are suitable for showing data proportions, and data labels play an important part. The right-hand menu allows us to format data labels. 2.The combo of pie charts and doughnut charts can display complex data. A chart with too many colors should be avoided. We can choose the tone on tone color and adjust the saturation to improve the color matching. 3.Sparkline is a handy chart type. ....

This lesson focuses on sharing common methods of merging and splitting files1. WPS Spreadsheet has 6 different merging methods, you can merge different worksheets into the same workbook, or merge different workbooks into the same workbook, and support the merging of worksheets with the same name. 2. “Merge range data” can select two regions and use the same value between them to find, just like a function, but more simple than a function. 3.WPS Spreadsheet has 3 different split methods....