How to clear format in Excel

You can watch a video tutorial here.

Excel has several options for formatting cells. Cells can be formatted for their appearance and for how the data in the cell is treated or displayed. Having applied many formats to a set of data, you may want to clear all the formats so that just the data is displayed.

Step 1 – Select the cells

– Select the cells for which the formats are to be removed

Step 2 – Choose the option from the ribbon

– Go to Home > Editing > Clear
– Select Clear Formats

Step 3 – Check the result

– All the formatting has been removed:
>Cell color
>Date format
>Conditional formatting
>Decimal places
>Comma style