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
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.
Press the Del key.