The Delete key.
The clear all option in the clear button removes all data and formulas, including number formats, conditional formats, and borders, from the cell. The cleared cells remain as blank or unformatted cells on the worksheet.
active cell
press ESC
active cell
If the cell is selected then it would be called the active cell. In practice, every cell is ready for data entry, so on that basis there is no special name for them. To put data into a cell, it must be selected and it then becomes the active cell.
It is the active cell.
active cell
Active cell
When a cell containing data is active, anything you type will replace the existing data in that cell. If you want to edit the current content instead of replacing it, you can either double-click the cell or press F2 to enter edit mode. This allows you to make changes without losing the original data.
Active cell
Delete can do that. So can Clear All.
It moves to the next cell, to the right. If anything is being typed in when the tab key is pressed it will enter the data in that cell and then move to the next cell.