You might have formatted many cells in your work sheet either through preset cell styles, changing formatting manually or through conditional formats. If you delete the cell contents, the formatting remains intact unless you delete the cell completely. If you would rather get rid of the formatting while keeping your data intact, you can try the steps mentioned below on the basis of the formatting applied.

To delete formatting applied manually, carry out the following steps:

Select the cells for which you want to delete the formatting.

Go to the 'Home' tab.

Click the 'Clear' button appearing under the 'Editing' group and click the 'Clear Formats' option from the drop-down menu.

To delete conditional formatting from cells, carry out the following steps as mentioned:

Select the cells for which you want to delete the conditional formatting.

Go to the 'Home' tab.

Click the 'Conditional Formatting' button that can be seen under the 'Styles' group.

Select the 'Clear Rules' option from the drop-down menu that appears. Select 'Clear Rules from Selected Cells' option from the extension menu.

To specifically delete selected conditional formatting, carry out the following steps:

Select the cells for which you want to delete the conditional formatting.

Go to the 'Home' tab.

Click the 'Conditional Formatting' button appearing under the 'Styles' group.

Select the 'Manage Rules' option from the drop-down menu.

Select the rule you want to delete from the 'Conditional Formatting Rules Manager' dialog box and select the 'Delete' option.