ExcelBanter - Sort by dropdown list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort by dropdown list (https://www.excelbanter.com/excel-discussion-misc-queries/202145-sort-dropdown-list.html)

Wanna Learn

Sort by dropdown list

Hello this is the Scenario - to sort by I ususaly do altDS then the
sort window appears. is there a way to select the dropdown arrow and what I
want to sort by without using the mouse thanks

SU123

Sort by dropdown list

try 'alt'+D then S

"Wanna Learn" wrote:

Hello this is the Scenario - to sort by I ususaly do altDS then the
sort window appears. is there a way to select the dropdown arrow and what I
want to sort by without using the mouse thanks

Gord Dibben

Sort by dropdown list

Alt + D + S + downarrow + A or D(for ascending or descending)

Let go Alt key then downarrow to selection then hit ENTER

Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 07:25:01 -0700, Wanna Learn
wrote:

Hello this is the Scenario - to sort by I ususaly do altDS then the
sort window appears. is there a way to select the dropdown arrow and what I
want to sort by without using the mouse thanks

All times are GMT +1. The time now is 10:27 PM.