|  

» Sort Ascending/Descending While Using AutoFilter

CATEGORY - Excel Filter VERSION - Microsoft Excel 2003
New in Excel 2003 – Sort Ascending/Descending with AutoFilter.

This new option allows you to sort straight from the AutoFilter dropdown list (identical to the Sort Ascending/Descending technique from the Sort Ascending/Sort Descending icons).

Using keyboard shortcuts

To display the Auto Filter dropdown list (in all Excel versions):

In the cell that contains the Filter dropdown arrow, (Blue arrow) press Alt+Down Arrow.
To display the Auto Filter dropdown list (in all Excel versions):
In the cell that contains the Filter dropdown arrow (Blue arrow), press Alt+Up Arrow.
Screenshot // Sort Ascending/Descending While Using AutoFilter
Sort Ascending/Descending While Using AutoFilter


Rate This Tip
12 34 5
Rating: 2.53     Views: 54252
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments