Using filters in Excel gives you a chance to improve productivity in almost any task you are working on. Turning on filters for Excel is not something that you cannot do if you are not familiar with Excel tricks. However, you still need to learn some basics of Excel features so that you can easily perform a function. In the header, you will notice arrows along with a drop-down menu when the filters are activated.
You can use both mouse as well as a keyboard to activate and disable the filter option. To use shortcuts for filter applications, you must have Excel 2010 and updated versions.
Let’s see how you can use the filter shortcut in Excel. Choose your favorite Shortcut for filter in Excel given below:
Turn Filter On or OFF
First, you need to select a cell range to turn the filter on or off. For this, Press CTRL + SHIFT + L.
You will see the down arrows appear along field names given in the header row:
You will have to select all cells if the data includes blank columns or rows. Furthermore, you will see the Filter menu by default if the table is converted from a list.
Finding something from larger datasets could be entirely tricky. You can sort down data using the filters option. Below are some shortcuts you can apply to activate the filters feature easily.
CTRL + SHIFT + L
Using this shortcut let you apply a filter to the data based on selected criteria. To apply this, select the data that needed to be filtered. Now, press CTRL + SHIFT + L and you will see a dialog box appears. Click OK when the criteria are selected.
CTRL + SHIFT + F
Using this shortcut will open the Filter dialog box where the criteria for the filter are selected. To apply this shortcut, select the data that needed to be filtered. Press CTRL + SHIFT + F and a dialog box will appear to select the criteria. Click OK once the criteria are selected.
CTRL + SHIFT + I
Using this shortcut will reverse the filter for the data. To apply this shortcut, select the data that needed to be filtered. Press CTRL + SHIFT + I and the filter will reverse. Now, you will see the data that does not match with criteria.
CTRL + SHIFT + U
Using this shortcut for filter in Excel, you can remove the filter applied to your data. To apply this, select the data that you need to filter. Press CTRL + SHIFT + U and it will delete the filter.
CTRL + SHIFT + K
Using this shortcut can filter the data based on selected criteria. To apply this shortcut, select the data you need to filter. Press CTRL + SHIFT + K and a dialog box will appear to select the criteria for filter. Click OK when the criteria are selected.
CTRL + SHIFT + J
Using this shortcut can open the Filter dialog box and you can select the criteria to apply the filter. To apply this shortcut, select the data that needed to be filtered. Press CTRL + SHIFT + J and a dialog box will appear to select the criteria for the filter application. Click OK when the criteria are selected and the filter will be applied.
CTRL + SHIFT + H
Using this shortcut can reverse the filter that has already been applied to your data. To apply this shortcut, select the data that needed to be filtered. Press CTRL + SHIFT + H and it will reverse the filter so that the data does not match the criteria.
CTRL + SHIFT + N
Using this shortcut can remove the filter from your data. To apply this shortcut for filter in Excel, select the data that needed to be filtered. Press CTRL + SHIFT + N and it will disable the applied filter and you will be able to see the data.
CTRL + SHIFT + M
Using this shortcut will add a filter to your data based on the criteria. To apply this shortcut for filter in Excel, select the data that needed to be filtered. Press CTRL + SHIFT + M and a dialog box will appear to select the criteria for the filtering. Once the criteria are selected click OK and the filter will be applied.
CTRL + SHIFT + O
Using this filter will open the Filter dialog box where you can select the criteria for the filter. To apply this shortcut filter in Excel, select the data that needed to be filtered. Press CTRL + SHIFT + O and a dialog box will appear to select the criteria. Click OK when the criteria are selected and the filter will be applied.
So, that’s it!
Final Thoughts
The above-mentioned shortcuts for filter in Excel are one of the best shortcuts that you can use to filter data. Try these shortcuts and you will learn new tricks in Excel. A little practice can make you an expert in Excel. Keep trying and one day you will be an old hand.
