How to remove formatting in excel


Staff member
Remove All Cell Formatting from the Entire worksheet
  1. Open the worksheet from which you want to remove the formatting.
  2. Click on the top left corner of the worksheet (one with a gray triangle icon). ...
  3. Click the Home tab.
  4. In the Editing group, click on the Clear option drop-down.