What is the shortcut key to get Autofilter in Excel?

by Nirmala 2014-01-07 12:15:49

Autofilter in Excel

Alt + D + F + F

That will open the Data>filter>autofilter

Display the AutoFilter list for the current column Select the cell that contains the column label, and then press

ALT + DOWN ARROW

Close the AutoFilter list for the current column

ALT + UP ARROW

Select the next item in the AutoFilter list

DOWN ARROW

Select the previous item in the AutoFilter list

UP ARROW

Select the first item (All) in the AutoFilter list

HOME

Select the last item in the AutoFilter list

END

Filter the list by using the selected item in the AutoFilter list

ENTER

Tagged in:

520
like
0
dislike
0
mail
flag

You must LOGIN to add comments