Search notes:

Excel: Home -> Editing -> Clear

Remove a cell's or range's content, its formatting, comments, hyperlinks or simply everything.
Functionality offered in the Clear drop down of the Editing section of the Home tab:
Equivalent command in immediate window
Clear All selection.clear
Clear Formats selection.clearFormats
Clear Contents selection.clearContents
Clear Comments and Notes selection.clearComments
Clear Hyperlinks selection.clearHyperlinks
Remove Hyperlinks

See also

The clear* methods of the range object.
The Popup Menu *Format Cells*

Index