Microsoft Excel offers a very interesting way to clear formatting. We can cater to this problem statement by using the “clear format” option. We can perform the below mentioned way to clear formatting in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with a column filled with formatting
– Open the desired Excel workbook containing a column with formatting applied
Step 2 – Clear formats option
– Now select the cells which are having the formatting and then under the Home option in the menu bar, go to “Clear”, and then select the “Clear Formats” option.
Step 3 – Formatting cleared
– We can see that the formatting of the cells has been cleared