Free Support Forum -

Quickly clear a range's cells' contents and styles


is there a quick way to

- Clear the contents (foruma / value) of a range of cells?
- Reset the range of cells’ styles to default?

If there isn’t at the moment, would it be possible to add method(s) like:


or such? Maybe you will come up with a simpler/better solution.

Another thing: When I set a cell’s style to null it is not being reset to defaults. Isn’t there such a thing as a default cell style?


Hi Kai,

Please check for reference.

You can try Cells.ClearContents method and Cells.ClearFormats method.

Hi Laurence,

thanks very much for the hint. I simply didn’t find it Smile