Computer Aptitude - Keyboard Shortcuts
Which Excel shortcut is used to apply or remove filters on selected data?
Which Excel shortcut is used to apply or remove filters on selected data?
medium Q14 of 15
Step-by-Step Solution
Step 1: Understand required command
You need to toggle the filter option in Excel.Step 2: Identify Excel filter shortcut
Ctrl + Shift + L applies or removes filters from the selected data range.Final Answer:
Ctrl + Shift + L → Option BQuick Check:
Press Ctrl + Shift + L → filter icons appear/disappear. ✅
Quick Trick: L = List filter toggle.
Common Mistakes:
MISTAKES- Using Ctrl + L (creates table) instead of toggling filters.
Master "Keyboard Shortcuts" in Computer Aptitude
Start learning the concept with an interactive lesson.
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Computer Aptitude Quizzes