- By Katherine Murray
- Using conditional formatting to showcase data trends
- Adding sparklines
- Understanding Excel formulas and functions
- Performing common calculations
- Subtotaling data values
- Entering formulas
- Troubleshooting formulas
- Working with functions
- Creating and modifying data tables
- Sorting data
- Filtering worksheet data
- Creating PivotTables
- Viewing data instantly with Quick Analysis
Filtering worksheet data
When you want to look at a subset of your data or display only data values related to a specific category of information, you can apply filters to that data. You use the Filter tool on the Data tab to instruct Excel 2013 as to how you want to filter the information on the worksheet. When you filter your data, the data items that don’t meet the filter criteria are hidden temporarily so that you can view only the data you need.
You can also use slicers to filter your data in real time in a table format. Slicers are simple, graphical tables with which you can display your data in different ways without changing selections on the worksheet. Slicers are easy to add and can be an effective tool for showing how your data looks when filtered in different ways.
Filter selected data
Click any cell in the range that you want to filter.
Click the Data tab.
Click the filter arrow for the column that contains the data you want to filter.
Select the check boxes adjacent to the values by which you want to filter the list.
Use a slicer to filter a table
Click any cell in the Excel table that you want to filter.
Click the Insert tab.
The Insert Slicers dialog box opens.
Select the check boxes adjacent to the fields for which you want to create a slicer.
Do any of the following steps:
Click an item to display just that item’s values in the table.
Ctrl+click a second item to add it to the list of displayed values.
Click an item and then Shift+click another item to display every item between those two items.
Click the Clear Filter button to remove all filters applied by the slicer.
Right-click and hold the slicer and click the Remove menu item to delete the slicer.