O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filter Lists

Press

To

Alt+Down Arrow

In the cell that contains the drop-down arrow, display the Auto-Filter list for the current column.

Down Arrow

Select the next item in the AutoFilter list.

Up Arrow

Select the previous item in the AutoFilter list.

Alt+Up Arrow

Close the AutoFilter list for the current column.

Home

Select the first item (Sort Ascending) in the AutoFilter list.

End

Select the last item in the AutoFilter list.

Enter

Filter the list based on the item selected from the AutoFilter list.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required