To remove all the formatting from an Excel worksheet, click the indicator between the rows and columns in the top left corner of the worksheet to select the entire worksheet. From the Home tab on the Ribbon, locate the Editing group and choose Clear > Clear Formats. This removes all formatting except custom column widths and row heights.
