Remove Conditional Formatting from the Entire Worksheet
Master this Excel shortcut with our comprehensive guide
Conditional Formatting Shortcuts
Alt, H, L, C, E
⌘ + Option + Command + E
How to Use This Shortcut
Keyboard Shortcut
Alt, H, L, C, E
Instructions
1. Press Alt, then H, then L, then C, then E
2. Removes all conditional formatting across the worksheet
2. Removes all conditional formatting across the worksheet
Keyboard Shortcut
⌘ + Option + Command + E
Instructions
1. Press Command + Option + Command + E
2. Removes every conditional formatting rule from the sheet
2. Removes every conditional formatting rule from the sheet
💡 Pro Tip: Use this when starting fresh on a messy worksheet with too many rules.
Quick Actions
More Conditional Formatting Shortcuts
Alt, O, D
Alt, H, L, C, S