Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hotkey / Shortcut Keys in Filters
Greetings. I am using MS VISTA and Excel 2007.
When I am using a filter, I have to right mouse click to get "Filter" and then "Filter by Selected Cell's Value." Then is somewhat time consuming. Is there any way to reduce these three mouse clicks, say by using a hotkey or shotcut key? I searched the help file but I couldn't find any mention of such keys for filters. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hotkey / Shortcut Keys in Filters
You could create a simple macro and assign a shortcut key to it.
For example, Sub Filter() ActiveSheet.Range("$A:$B").AutoFilter Field:=1, Criteria1:=ActiveCell.Value End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys ? | Excel Discussion (Misc queries) | |||
shortcut keys | Excel Discussion (Misc queries) | |||
Shortcut keys not working | Excel Worksheet Functions | |||
Creating shortcut keys | Excel Discussion (Misc queries) | |||
Macro Shortcut Keys | Excel Discussion (Misc queries) |