To clear contents from a cell or a range of cells in Excel you need to use the “Delete” button on the keyboard. This key works the same even if you have selected one cell, multiple non-continuous cells, or a range of cells.
Apart from that, you can also use the following keys to get the same thing done.
- Backspace: Even though backspace is not used for clearing the content, it works almost the same. When you select a cell and press the backspace it clears the content from the cell and edits it.
- Alt ➜ H ➜ E ➜ A: This keyboard shortcut activates the “Clear Content” option from the Home Tab.
⇠ Back to Excel Shortcuts (PDF Cheat Sheet)