Excel 2010 CTRL SHIFT L Not working

0 votes
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.
Mar 31 in Database by Edureka
• 9,320 points
28 views

1 answer to this question.

0 votes
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.
answered Apr 4 by Edureka
• 9,320 points

Related Questions In Database

0 votes
1 answer
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

Mar 31 in Database by Edureka
• 9,320 points
13 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
312 views
0 votes
1 answer
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

answered Dec 14, 2018 in Database by Sahiti
• 6,360 points
339 views
0 votes
3 answers

MySQL "Could not create connection to database serve" error

Pls check that you have MySQL server ...READ MORE

answered Jul 3, 2020 in Database by anonymous
25,186 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 9,320 points
21 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer

Excel Middle mouse button click not scrolling

Workbook and Protected Sheet If the sheets are ...READ MORE

answered Apr 4 in Database by Edureka
• 9,320 points
20 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25 in Database by Edureka
• 9,320 points
54 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP