How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Long-time staring at the screen when using office software can cause eye irritation. At this point, we can relieve tired eyes by adjusting the theme or colour of the document. Eye Protection Mode is not available in Microsoft Office yet. But we can adjust the theme colour to relieve eye strain.Click File, then get into the Options inter....

WPS Office fulfils our needs to mark on a PDF. It provides various kinds of comment or marking functions. Today, you will learn practical methods of using the Note function in WPS PDF. If you want to make notes for certain content on a PDF, you can insert a comment into the corresponding place. To realize it, get into the Comment tab and click the Note button. You can also find the Note button in the Insert tab. Choose a color for your note and click on any place on the page to insert ....

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

Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear. 1. Select the needed cell range, click the Insert tab and click the Radar drop-dow....

Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....

When we need to highlight the changes of an article, we can apply this feature: Track Changes. · Track ChangesClick the Track Changes drop-down button in the Review tab, and select Track Changes to enter the Track Changes mode. Its shortcut key is Ctrl+Shift+E. Then when we add text to the paragraphs, the text automatically appears in red. When we delete text or change its style, there are corresponding records on the right.In simple terms, WPS Office automatically records and displays....

We often need to paint various Flowcharts in the office routine. In WPS Writer, we can make flowcharts easily with the Insert Shapes function.There are many kinds of flowcharts. Today, we will give an example to illustrate better. Step one, insert a drawing canvas.Click Insert, then click Shapes and select New Drawing Canvas to add one.A great benefit is that we can drag the canvas directly to move the flowchart.You can drag the position of the canvas only if the canvas is set to a te....