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. A quick way to clear formatting with Format Painter.Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet, and I will show you all these techniques in a moment. Manually changing cell color, font, borders, alignment and other formats would be tiresome and time-consuming. In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first. When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. This short tutorial shows a couple of quick ways to remove formatting in Excel worksheets.

How to clear formatting in word table