Data segmentation in Excel: how to use filtering function | Productivity

The data segmentation feature in Excel makes it easier to filter rows and columns in tables, but not always known to users. The tool works integrated with a dynamic spreadsheet and can be useful for those who need to handle large amounts of data. It is possible to display only selected columns and all rows are ordered in ascending or alphabetical numerical order. When you click 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 are also valid for 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? Meet Compare dnetc

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

Inserting data segment in Excel Photo: Reproduo / Helito BeggioraInserting data segment in Excel Photo: Reproduo / Helito Beggiora

Inserting data segment in Excel Photo: Reproduo / Helito Beggiora

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

Select the desired columns Photo: Reproduo / Helito BeggioraSelect the desired columns Photo: Reproduo / Helito Beggiora

Select the desired columns Photo: Reproduo / 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;

Data segmentation columns in Excel Photo: Reproduo / Helito BeggioraData segmentation columns in Excel Photo: Reproduo / Helito Beggiora

Data segmentation columns in Excel Photo: Reproduo / Helito Beggiora

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

Filtering column data Foto: Reproduo / Helito BeggioraFiltering column data Foto: Reproduo / Helito Beggiora

Filtering column data Foto: Reproduo / Helito Beggiora

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

Selecting multiple items Photo: Reproduo / Helito BeggioraSelecting multiple items Photo: Reproduo / Helito Beggiora

Selecting multiple items Photo: Reproduo / Helito Beggiora

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

Clearing data selection Photo: Reproduction / Helito BeggioraClearing data selection Photo: Reproduction / Helito Beggiora

Clearing data selection Photo: Reproduction / Helito Beggiora

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