ClearFormats Method From Microsoft Office Web Components Object Model previous page next page ClearFormats Method Deletes all formatting from the specified range. expression.ClearFormats expression An expression that returns a Range object. Example This example clears the formatting from all cells on the active worksheet. Spreadsheet1.ActiveSheet.Cells.ClearFormats