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
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»;
Inserting data segmentation in Excel – Photo: Reproduction / Helito Beggiora
Step 2. Choose the columns you want to use and click «OK»;
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;
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;
Filtering column data – Photo: Reproduction / Helito Beggiora
Step 5. Use the «Ctrl» key to select more than one item at a time;
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.
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.