Excel 2010 CTRL SHIFT L Not working

Question

I apologize if asked/answered - but I truly did search....

In excel CTRL+Shift+L is not working; when I press the key sequence and the cursor spins and comes back without having accomplished turning on the filters or anything visible to me. This is the only shortcut that is not working so I did not know if I redefined it - but could not tell what it was currently defined as, I had the IT guys repair the install - All with no luck...

I would love to debug what CTRL+Shift+L does when I hit it - but could not figure out if that was possible...

Totally at wits end - - any help would be greatly appreciated.

Answer 1

The Macro-containing workbook was always open in the background, preventing any non-Macro-containing workbooks from using the Filter shortcut. If the problem persists, see if any of your open workbooks have macros, and if so, see if ctrl+shift+L is assigned to any of them.

Please try Alt+A+T. Hope it solves your problem.