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: