Clear the contents in cells in Excel 2010

For explaining the concept of clearing contents in cells, we will have 4 cells (B2, B3, B4, and B5). Note the font of the cells B2, B3, B4, and B5. Now, set the font of B2, B3, B4, B5 to Arial, set the size of the font to 18 and make it appear bold.

In cell B2, enter Arial 18 B + C and then press the Enter key. Right-click cell B2, click Insert Comment and then enter Comment and Arial font of size 18 will not be deleted but the data in the cell is cleared.
In cell B3, enter C and then press the Enter key. Right-click cell B3 and click Insert Comment and then enter Content in the cell and the comment will not be deleted.
In cell B4, enter Arial 18 B and then press the Enter key. Right click cell B4 and click Insert Comment and then enter Comment will be deleted but the contents and the formatting is present.
In cell B4, enter XYZ and then press the Enter key. Right click cell B5 and click Insert Comment and then enter Data in the cell plus formatting and comments will be deleted.

Now for the explanation, there are five types of clearing information. They are Clear All, Clear Formats, Clear Contents, Clear Comments, and Clear Hyperlinks. To clear information, click on the cell that you have to clear the information and then click the Home tab, in the Editing section, click Clear and then click on any of the types.
Clear All – When you click this option, all the data, formatting applied to the cells, and comments in the cell(s) will be deleted.
Clear Contents – This is the normal way people clear the contents in the cell. Excel users just press the delete key from the keyboard. Doing so will clear the information but the formatting and the comments (if any) still remain in the cell(s).
Clear Formats – When you click on this option, the content in the cell and the comments in the cell will still be present but the formatting will be cleared.
Clear Comments – When you click on this option, the comments will be cleared.
Clear Hyperlinks – When you click on the Clear Hyperlinks, the hyperlink will turn to a non-hyperlink but the formatting still remains. You have to click the Clear Formats.