This will erase all cell formatting (including conditional formatting, number formats, fonts, colors, borders, etc.) but keep the cell contents. On the Home tab, in the Editing group, click the arrow next to the Clear button.Select the cell or range of cells from which you want to clear formatting.To remove all formatting in Excel, just do the following:
The easiest way to fix this is to remove all current formatting and start embellishing the worksheet from scratch. Excessive or improper formatting, however, may have an opposite effect, which makes your Excel worksheet difficult to read. The most obvious way to make a piece of information more noticeable is to change the way it looks.