In Excel terminology, the word Clear is defined as: “To remove contents from within a cell.”
The word Delete is defined as: “To remove cell(s) from the worksheet.”
It is important to understand the difference.
To remove the contents within a cell:
- Select the cell(s) that you want to clear.
- Select Clear (Home Tab/Editing Group/Clear Drop Down Arrow.
- Choose Clear Contents.

If you want to delete cells, click here or here.

