Let’s take a look that how we can do this by following simple steps: To illustrate this method of excel filter shortcut we have the following dataset of sales amount categorized by the last name of salespersons and their working cities. In this example, we will use the Data tab to filter data in an excel worksheet.

Use Filter Shortcut Option Under Data Tab to Filter Data

We will demonstrate 3 methods of using the excel filter shortcut since the filtering process is very necessary while working with a big dataset.ġ. In the case of text data, you’ll see the ‘ sort Z to A‘ function.3 Examples with Keyboard Shortcut to Filter Excel Data In column E, the data type is number, so you’ll see the ‘ sort largest to smallest‘ command. Tip: In the example, we use the Profit columns for sorting purposes. There are two options available, and it depends on the type of data you want to sort.

Press Alt + down arrow, then ‘O’ to sort your data in descending order.

Press Alt + down arrow, then ‘S’ to sort your data in ascending order.

However, the fastest way is using the following shortcuts: In Excel, there are various methods for sorting. This option is available only if your range contains color(s).

E – Enter a filter value manually (search bar)įor example, type the letter “I” to filter data by color.

F – Number / Text Filters (it depend on cell value).

T – Sort by Color using the Custom Sort option.

To use filter shortcuts in the drop-down menu, press the Alt + down arrow key. Drop-down menu shortcuts using underlined lettersĮxcel provides built-in shortcut keys (underlined letters) to apply various filter commands in the Filter menu.

The Filter menu appears for the selected columnĦ.

Steps to clear the filter in a single column:

Excel shortcut keys filter