- All Tutorials
- Video Tutorials
- Quick Tutorials
322 Search results
How can we freeze the pane in WPS Spreadsheet02:28
How can we freeze the pane in WPS Spreadsheet
When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....
Use the ROW function in WPS Spreadsheets for row numbering03:03
Use the ROW function in WPS Spreadsheets for row numbering
When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....
Use conditional formatting to make data more intuitive04:46
Use conditional formatting to make data more intuitive
We often need to compare and mark the table setting conditions at work. But how can we see the trend of the data more intuitively? Take this table as an example. Suppose now we want to find out the names of milk tea with a quantity larger than 100 and mark the color.1. Select the quantity area, and click the Conditional Formatting drop-down button in the Home tab.2. Choose the Highlight Cells Rules option in it. Then, you can a popup window, where you can select Greater Than, Less than....
Quickly adjust the row height and column width01:36
Quickly adjust the row height and column width
Adjusting the row height and column width is a necessary skill for the layout of the table content. So, how can we adjust the row height and column width? The easiest way to adjust the row height and column width is to position the mouse on the dividing line of the row number and column label and drag the dividing line to adjust the row height and column width. We will find that using this method is difficult to completely unify the row height and column width in the table, and the ope....
How to create a table with one click01:35
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....
Use format painter to adjust the styles in batches01:28
Use format painter to adjust the styles in batches
Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....
COUNTIFS function: count data of multiple criteria01:57
COUNTIFS function: count data of multiple criteria
We often need to count the number of data in our work, so how can we count them quickly? Here, we need to use a new function, COUNTIFS. The grammatical structure of COUNTIFS is COUNTIFS (range1, criteria1, [range2, criteria2]...) Take this table as an example. Now we want to count how many types of foods are produced in Thailand and also have a sales volume of more than 5,000? There are two criteria that we want to consider. One, the sales volume needs to be greater than 5,000, and the....
Quickly locate the name of the row and column where the cell is located01:22
Quickly locate the name of the row and column where the cell is located
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....