1. Data Selection
Begin by selecting the data you wish to filter. You can achieve this by clicking on the upper-left cell of the data and dragging your mouse to the lower-right corner. Alternatively, click the upper-left cell, then press Shift and the down arrow key to select the entire column.
2. Adding the Filter
After selecting the data, navigate to the Data tab in the ribbon and click on the Filter button. This action will introduce filter drop-down menus to the column headers.
3. Choosing Filter Criteria
With the filter drop-down menus in place, opt for the criteria you want to filter by. For instance, select a specific month from the drop-down menu in the column header to view data only for that month. You can also choose multiple criteria from the same drop-down menu, such as a specific month and year.
4. Applying the Filter
Once you've selected the desired criteria, click the Filter button in the ribbon to apply the filter. This action ensures that only the data meeting your chosen criteria is displayed.
5. Removing the Filter
To eliminate the filter, go to the Data tab in the ribbon and click on the Clear button. This will remove the filters, displaying all the data in its entirety.