Select the cell or range
Click the Home tab.
Click the Clear button.
Then click Clear All to clear contents and formatting.

Or click Clear Formats to clear formatting and leaves contents.
Or click Clear Contents to clears contents and leaves formatting.
Or click Clear Comments to clear comments; removes purple triangle indicator.
