Follow the steps below on how to use a macro to clear a cell in Excel:
On the Developer tab, click Macros.
A Macro dialog box will open.
Type a name in the name box, then click Create.
Read more here.