Select the cell or range
Click the Home tab.
Click the Clear button.
Then click Clear All to clear contents and formatting.
![Click the Home tab. Click the Clear button](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Clear_Cell_Contents_Formatting_And_Comments___Click_Home_Tab_Click_Clear_Button.PNG)
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.
![Or click Clear Comments to clear comments; removes purple triangle indicator.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Clear_Cell_Contents_Formatting_And_Comments___Or_Click_Clear_Comments_To_Clear_Co.PNG)