The Clear Formats Command will eliminate all of the formatting that has been added to a worksheet, allowing you to start over with your own settings.

Select the range that you want to remove the cell formatting, and click Home > Clear > Clear Formats, see screenshot:

And then all formatting applied to the cells have been cleared. See left screenshot:

Note: If you have applied formatting to only part of cell content in a cell, this Clear Formats feature can't remove the formatting only applied to part of cell content in one cell. See below screenshot:

Sometimes you not only apply the formatting to the cells, but also apply different formatting for the cell content. For removing all kinds of cell formatting no matter applied to entire cell or applied to only part of cell content, Kutools for Excel’s Clear All Cells Formatting utility can finish your work with just one click.

1. Select the range that you want to remove the cell formatting, and click Kutools > Format > Clear All Cells Formatting, see screenshot:

And then the formatting of all cells have been removed completely. See screenshot:

Click Clear All Cells Formatting to know more about this feature.