Clear only the cell formatting
Master this Excel shortcut with our comprehensive guide
Clear Shortcuts in Excel
Alt, H, E, F
⌘ + Option + E, F
How to Use This Shortcut
Keyboard Shortcut
Alt, H, E, F
Instructions
1. Select the target cells
2. Press Alt, then H, then E, then F
3. Only the formatting (like font, color, borders) is cleared, content remains
2. Press Alt, then H, then E, then F
3. Only the formatting (like font, color, borders) is cleared, content remains
Keyboard Shortcut
⌘ + Option + E, F
Instructions
1. Select the cells
2. Press Command + Option + E, then F
3. Formatting is removed but the data stays intact
2. Press Command + Option + E, then F
3. Formatting is removed but the data stays intact
💡 Pro Tip: Useful when you want to keep data but remove styles or formatting inconsistencies.
Quick Actions
More Clear Shortcuts in Excel
Alt, H, E, A
Alt, H, E, C
Alt, H, E, L