Hey, data friends! Today we will learn how to filter data in Excel. Filtering data in excel is relatively easy. First, we will walk through how to filter data in Excel using the Excel ribbon, and afterward, we will learn how to filter data using Excel’s hotkeys/shortcut keys.
Let’s get started!
To filter data in Excel through the ribbon follow the below steps:
1. Select the header column of the data you want to filter,
In the example pictured below, we’re selecting from the Chapter Header to the Final Review Header
2. Click into the Data tab of the Excel ribbon, as pictured below
3. From the Data tab, look for the “Sort & Filter” section and click on the “Filter” option, as pictured below
4. Now we can see little downward pointing arrows in the bottom right corner of each column header
5. To filter the data, we can select the down arrow and then select the criteria that we want to filter for
For example, if we wanted to filter our example data table for the Completed “Copy Editing” Chapters, then we would select only the “Completed” option in the filter drop-down.
That’s all there is to it! We have successfully filtered data in Excel using the Filter option in the Excel Ribbon.
Unfiltering is as easy as reselecting all the items in the filter dropdown or selecting the “Clear filter from” option in the drop-down.
The hotkeys to filter data in Excel are:
CTRL + SHIFT + L
To filter data in Excel using the hotkey shortcuts, follow the below steps:
1. Select the header of the data you want to filter, like pictured below
2. With the header selected, execute the data filter shortcut, CTRL + SHIFT + L. Our data now has the filter drops downs, just like in the steps above where we filtered our data using the Excel ribbon
3. From here, we can use the drop-downs to filter our data accordingly
Unfiltering is as easy is reselecting all the items in the filter dropdown or removing the filters by executing the hotkey, CTRL + SHIFT + L.
That’s all there is to filtering data in Excel. As always, if you have any questions or need anything clarified, you can DM me through Twitter @Cest_Nick; otherwise, I’ll catch you on the next post!