In this article, we will learn about various ways to use excel filter shortcuts. Like how to apply filter, how to open the drop-down menu in excel filter etc. so let’s start…
1. How to apply Filter in Excel?
In the below-given example, we will take data from a list of top billionaires.
Friends when you are working in excel and you want to apply filter in your data, so you will select the data and go to “Home” tab under the editing section > Sort & Filter > Filter, then in your data filter will be applied. Or you can do it via Data tab > Sort & Filter > Filter.
How to Create GST Ledgers in Tally? SGST | CGST | IGST
In the previous post we saw “How to set GST Rate in TallyPrime?”, now we will see “How to create GST Ledgers in Tally?” so let’s start… Create SGST Leder From the Gateway of TallyPrime To create GST ledgers from the Gateway of TallyPrime click on the “Create” option and then select the “Ledger” then…
How to Create a Drop Down List in the Microsoft Excel?
Create a Drop Down List In the previous post, we saw ‘How to Use Excel ABS Function?’, now we will learn about How to Create a Drop Down List in the Microsoft Excel?’. Where to find List [Drop Down] option To find the list option in excel open excel and click on the “Blank” to…
2. Open the Dropdown Menu in Excel Filter
After you applied filter in your data, you can use the dropdown menu in each of column header.
You will see that each header has a drop-down list, Press “ALT + (Down Arrow Key) ↓” from the keyboard.
3. How to Enable Searchbar in Excel Filter Menu?
To do that come to the drop-down icon and press “ALT + (Down Arrow Key) ↓ + E” the cursor will start blinking in the search bar. Start typing the name/value you want to filter.
4. How to Clear Filter in Specific Column?
Go to the column Press “ALT + (Down Arrow Key) ↓ + C” , it will remove/clear filter to only that cell
5. How to clear Filter from multiple Columns or Range?
Go anywhere in the dropdown menu icon and press ” ALT + H + S= C”
6. Custom Filter Dialog Box
To do that, make sure filter is applied to your data. Press ” “ALT + (Down Arrow Key) ↓ + F + E” . See the below step by step details: