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