Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 106
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut Keys ? Jakobshavn Isbrae Excel Discussion (Misc queries) 1 March 20th 07 06:44 PM
shortcut keys tomruffner Excel Discussion (Misc queries) 2 February 28th 07 02:20 PM
Shortcut keys not working Manju Excel Worksheet Functions 2 August 26th 06 03:35 AM
Creating shortcut keys Magnus Ramfelt via OfficeKB.com Excel Discussion (Misc queries) 1 January 21st 05 01:06 PM
Macro Shortcut Keys Nicolle K. Excel Discussion (Misc queries) 1 January 6th 05 04:55 PM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"