Filtering Data In Excel. Check the excel essentials course. To open the advanced filter dialog box click data advanced.
Once you open your datasheet on the excel ribbon click data. Arrows in the column headers appear. Filter data in a table select the column header arrow for the column you want to filter.
Click on select all to clear all the check boxes and click the check box next to usa.
Uncheck select all and select the boxes you want to show. The column header arrow changes to a filter icon. To open the advanced filter dialog box click data advanced. Uncheck select all and select the boxes you want to show.
