Using Filter

V

vikesh

I use filters very frequently and want to know some keyboard shortcu
whereby the drop down list of filtered line comes automatically instea
of using the mouse
 
C

Chip Pearson

If you are in the filter drop down cell, use ALT+DownArrow.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

Debra Dalgleish

Select the cell that contains the AutoFilter dropdown list
Hold the Alt key, then press the up arrow key or the down arrow key
 
A

Andy Brown

You have 3 replies ; since you "use filters very frequently", you might find
it useful to keep a macro in personal.xls, e.g.

Sub ShowAllData()
On Error Resume Next
ActiveSheet.ShowAllData
End Sub

, and assign a shortcut key of e.g. CTRL+Shift+S.

HTH,
Andy
 
D

Dave Peterson

or just drag a builtin icon to your favorite toolbar:

Tools|Customize|commands tab|data category
look for Show All

(in fact, I've dragged the autofilter icon to my toolbar, too.)
 
Top