How to filter blanks or non-blanks with one click

Multiple blank cells in a table are inconvenient for us to look up data. How can we hide them with just one click?Place your cursor at any cell. Click the Filter button at Home or you can use shortcut Ctrl+Shift+L. Then a green corner marker will show in the header line, indicating you are in the filter mode.2. Select the column you'd like to filter. Click the green icon and the data list to filter will pop up. Here, you can choose what to filter. Hover the cursor at Blanks and two....

How to draw price elasticity of demand curve in WPS Office Excel

In this article, you will know how to draw price elasticity of demand curve in excel with simple steps as following: The demand curve shows the relationship between price and the number of units demanded.· Step 1: Insert a chart in WPS Spreadsheet.1. Select the cell range, head to the Insert tab, and click Chart to pop up a dialog.2. Click Line and then choose a preferred style by clicking Use. WPS Office provides one template for common users, and you can subscribe for Template Premiu....

How to analyze data using pivot tables in WPS Office Excel

Welcome to WPS Official Academy, and this tutorial helps you master how to use pivot tables to analyze data in WPS Spreadsheet. Steps to create a pivot table and analyze data with it. lCreate a pivot table in WPS Spreadsheet1. Prepare your pivot table data and open it in WPS Office; for example, the following table illustrates the sales of a coffee brand in different countries and months in 2021. Select the range of data you want to analyze in a pivot table. Go to the Insert tab and cl....

How to create an impressive dashboard in WPS Office Excel

Welcome to WPS Official Academy! After reading this free tutorial, you will be able to master how to create an impressive excel dashboard in WPS Office. lWhat is a dashboard in Excel?A dashboard is a visual presentation of key metrics, which is usually composed of various elements including charts, gauges, tables, and figures. It simplifies the complex data and presents the current status at a glance, helping you make decisions easily and quickly. Dashboards are widely used in work rep....

How to use Slicers to filter pivot tables in Excel

Pivot Tables is a powerful feature used to design dynamic charts and extract significant information from a complex data set. And we can use Slicers to filter pivot tables to create awesome worksheets.Suppose we have a set of data illustrating the sales of a coffee brand in different countries in 2021. Here are the steps.1. Go to the Insert tab and click the Slicers button. In the pop-up dialogue box, select the check boxes for the fields you want to display and click OK. 2. You can ....

How to remove duplicates in Excel

· Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....

Collapse or expand rows or columns in a sheet

We can group the rows or columns to collapse or expand parts of the details. The following screenshots compare a worksheet before and after grouping data.Before grouping data Group data to collapse or expand columns Here are the steps to group the data.1. Select the rows or columns to be grouped.2. Go to the Data tab → click Group.Steps to group data You can also further group the data following the previous steps. Here is an example to further group the data. Further group the data T....

How to sort data in a worksheet

1. Select the cell range filled with data to be sorted.2. Click Data → Sort → choose a sorting method (Ascending or Descending) When choosing Descending, the data would be sorted from the maximum to the minimum values (or Z to A for text). When choosing Ascending, the from the minimum to the maximum values (or A to Z for text). Note:When you see the Sort Warning pop-up dialog, you can choose one of the two options for array to be sorted.lIf you choose 'Continue with the current ....