What is the shortcut key to get Autofilter in Excel?
by Nirmala[ Edit ] 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