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, 2022 in Database by Edureka
• 13,630 points
2,663 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, 2022 by Edureka
• 13,630 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, 2022 in Database by Edureka
• 13,630 points
102 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
562 views
0 votes
1 answer
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,630 points
124 views
0 votes
1 answer

Converting HTML to Excel? [closed]

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

answered Feb 23, 2022 in Database by gaurav
• 22,970 points
119 views
0 votes
0 answers

how to Convert HTML to Excel?

I need to convert the HTML template ...READ MORE

Jul 4, 2022 in HTML by Tejashwini
• 3,770 points
105 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 59,740 points
140 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, 2022 in Database by Edureka
• 13,630 points
1,479 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, 2022 in Database by Edureka
• 13,630 points
2,068 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP