Excel Shortcut Key

%3CLINGO-SUB%20id%3D%22lingo-sub-1593912%22%20slang%3D%22en-US%22%3EExcel%20Shortcut%20Key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593912%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20Have%20Issue%20In%20Excel%20In%20Data%20Filter%20Shortcut%20Key%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20Is%20Alt%2BD%2BF%2BF%20Is%20Work%20As%20A%20Short%20Key%20In%20Data%20Filter%20But%20CTRL%2BSHIFT%2BL%20is%20not%20working%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help%20Me%20To%20Solve%20This%20Issue%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%3C%2FP%3E%3CP%3EDeepak%20A%20Mobarsa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1593912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1595321%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Shortcut%20Key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595321%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20to%20see%20if%20any%20of%20your%20open%20workbooks%20is%20macro-enabled%20was%20assigned%20the%20same%20shortcut.%20If%20you%20have%20customised%20shortcuts%20check%20them%20also%3B%20you%20probably%20have%20this%20shortcut%20already%20assigned%20to%20perform%20other%20function%20besides%20the%20default%20for%20data%20filtering%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762260%22%20target%3D%22_blank%22%3E%40Deeapk_A_Mobarsa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598260%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Shortcut%20Key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598260%22%20slang%3D%22en-US%22%3EI%20Was%20Check%20In%20Marcos%20There%20No%20Any%20Other%20Marcos%20To%20This%20Shortcut%20What%20Can%20I%20Do%20After%20This%20Have%20Any%20Solution%20About%20This%20Problem%3CBR%20%2F%3EThank%20You%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598381%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Shortcut%20Key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598381%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762260%22%20target%3D%22_blank%22%3E%40Deeapk_A_Mobarsa%3C%2FA%3E%26nbsp%3BA%20solution%20was%20proposed%20at%20Microsoft%20answers%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fkeyboard-shortcut-ctrlshiftl-doesnt-work-in-excel%2F25b87547-19ed-4efc-8d11-7324bb65a897%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fkeyboard-shortcut-ctrlshiftl-doesnt-work-in-excel%2F25b87547-19ed-4efc-8d11-7324bb65a897%3C%2FA%3E%26nbsp%3BCheck%20and%20see%20if%20your%20problem%20is%20resolved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi 

I Have Issue In Excel In Data Filter Shortcut Key 

There Is Alt+D+F+F Is Work As A Short Key In Data Filter But CTRL+SHIFT+L is not working .

 

Please Help Me To Solve This Issue 

 

Thank You

Deepak A Mobarsa

3 Replies

Check to see if any of your open workbooks is macro-enabled was assigned the same shortcut. If you have customised shortcuts check them also; you probably have this shortcut already assigned to perform other function besides the default for data filtering @Deeapk_A_Mobarsa 

I Was Check In Marcos There No Any Other Marcos To This Shortcut What Can I Do After This Have Any Solution About This Problem
Thank You

@Deeapk_A_Mobarsa A solution was proposed at Microsoft answers here https://answers.microsoft.com/en-us/msoffice/forum/all/keyboard-shortcut-ctrlshiftl-doesnt-work-in-e... Check and see if your problem is resolved.