1.Select the cells containing the content you want to clear.2.Click the Clear button (the one with the eraser) in the Editing group on the Home tab.3.Click one of the following options on the Clear drop-down menu:⇒Clear All gets rid of all formatting, comments, and entries in the cell selection.⇒Clear Formats deletes only the formatting from the cell selection without touching anything else.⇒Clear Contents deletes only the cell entries; just like pressing the Delete key.⇒Clear Comments removes the comments in the cell selection but leaves everything else intact.⇒Clear Hyperlinks removes the active hyperlinks in the cell selection but leaves their descriptive text.
1 1 1