Using Filter

  • Thread starter Thread starter vikesh
  • Start date Start date
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
 
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
 
Select the cell that contains the AutoFilter dropdown list
Hold the Alt key, then press the up arrow key or the down arrow key
 
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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
alt down arrow shortcut not working 0
Filter question 4
VBA: How can I use a string variable as autofilter criteria? 4
Another Filter Question 1
Data validation list using filtered range 3
Using Filter more than once 2
Auto-filter not grabbing all the data 2

Back
Top