Shortcut keys
WindowsAlt → H → E → A
MacNo direct shortcut
Ribbon path
Home → Clear → Clear All
What it does
Removes both content and formatting from the selected cells. Use with caution — this cannot be undone in one step.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for clear all (content + formatting)?
On Windows, use Alt → H → E → A. On Mac, use No direct shortcut.
Where is clear all (content + formatting) in the Excel Ribbon?
The Ribbon path is Home → Clear → Clear All.
What does clear all (content + formatting) do in Excel?
Removes both content and formatting from the selected cells. Use with caution — this cannot be undone in one step.