How to clear format in Excel
By
SpreadCheaters
Page last updated:
17/11/2022 |
Next review date:
17/11/2024
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
