contador web Skip to content

how to use filtering function

Segmentasi data di Excel: cara menggunakan fungsi pemfilteran

The data segmentation feature in Excel makes it easier to filter rows and columns in tables, but it is not always known to users. The tool works integrated with a dynamic spreadsheet and can be useful for those who need to deal with large amounts of data. It is possible to display only selected columns and all rows are ordered in ascending or alphabetical numerical order. When clicking on an item, the corresponding values ​​in the other columns are displayed instantly.

#FiqueEmCasa: tips and news help you stop the coronavirus

In the following tutorial, check out how to use data segmentation in Excel spreadsheets. The procedure was carried out in the latest version of Office 2016, but the tips also apply to users of previous editions of the Microsoft program.

How to delete all blank lines in Excel at once

How to delete all blank lines in Excel at once

Want to buy cell phones, TV and other discounted products? Discover Compare dnetc

Step 1. Click on any data in the dynamic spreadsheet. Then, access the «Insert» tab and click on «Data segmentation»;

1 of 6 Inserting data segmentation in Excel – Photo: Reproduction / Helito Beggiora

Inserting data segmentation in Excel – Photo: Reproduction / Helito Beggiora

Step 2. Choose the columns you want to use and click «OK»;

2 of 6 Select the desired columns – Photo: Reproduction / Helito Beggiora

Select the desired columns – Photo: Reproduction / Helito Beggiora

Step 3. The selected data will be displayed on the screen. If you want, click on the columns and drag to the desired position;

3 of 6 Data segmentation columns in Excel – Photo: Reproduction / Helito Beggiora

Data segmentation columns in Excel – Photo: Reproduction / Helito Beggiora

Step 4. Now, click on a value in any of the columns to quickly see the equivalent data in the others;

4 of 6 Filtering column data – Photo: Reproduction / Helito Beggiora

Filtering column data – Photo: Reproduction / Helito Beggiora

Step 5. Use the «Ctrl» key to select more than one item at a time;

5 of 6 Selecting multiple items – Photo: Reproduction / Helito Beggiora

Selecting multiple items – Photo: Reproduction / Helito Beggiora

Step 6. To clear the selection, click on the indicated button in the upper right corner of the data segmentation window.

6 of 6 Clearing data selection – Photo: Reproduction / Helito Beggiora

Clearing data selection – Photo: Reproduction / Helito Beggiora

Take advantage of tips on how to use data segmentation in Excel to quickly find values ​​in large spreadsheets.