What do the Clear All option in the Clear button removes from the active cell?
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.