How to Clear Cell Formatting in Microsoft Excel

Quick summary

Clearing cell formatting in Microsoft Excel removes styles like colors, fonts, and borders from selected cells without deleting data. You can do this in just a few clicks using the Clear Formats option under the Home tab.

Steps

1. Select the cells in your Microsoft Excel worksheet that contain the formatting you want to remove.
2. Navigate to the top menu bar and click the Clear option under the Home tab.
3. Choose Clear Formats from the dropdown list of options.
4. The formatting of your selected cells will be cleared and reverted to default.