» Sort Ascending/Descending While Using AutoFilter
CATEGORY - Excel Filter
VERSION - Microsoft Excel 2003
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.
Book Store:
Recommended Books:
- Microsoft Excel Version 2002 Step by Step
- Excel 2002 Power Programming with VBA
- Microsoft Office XP Introductory Concepts and Techniques
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Microsoft Access 2002 for Dummies
No comments have been submitted.
