Hello...can somebody please tell me keyboard shortcut for opening filter dropdown in excel.Also how to select deselct iteams from the list with shortcut key
Hello...can somebody please tell me keyboard shortcut for opening filter dropdown in excel.Also how to select deselct iteams from the list with shortcut key
To apply filters
- Select range
- Alt + D + F + F
Once filter is applied to select from dropdown
- Alt + down arrow key
- Scroll using up and down arrow keys
- Space to select/deselect
Does this help?
Life's a spreadsheet, Excel!
Say thanks, Click *
other shortcut is ctrl + shift + L
Thanks Amy_d2 & Ace_XL
I was looking for eaxctly the same information
Thanks once again
Hey guys...do u know the Keyboard shortcut to unhide columns in Excel-2007
I tried using ctrl+shift+) but its not working
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks