To remove all formatting from cells, in the Editing group within the Home tab, click the Clear button, and select Clear Formats from the drop-down menu.
