Clear formatting rules

Clearing is performed for all rules applied to the range selected for removal: selected cells, the current sheet, or the entire document.

To clear rules for selected cells, follow these steps:

1.Select the range of cells.

2.Clear it in one of the following ways:

•On the Home tab, in the Data group or on the Data tab, click the arrow to the right of the  Create formatting rule button and select Clear rules > From selected cells from the drop-down menu.

•Right-click the selected range and run the Clear rules > From selected cells command from the context menu.

You can clear the rules for the current sheet or the entire document in one of the following ways:

•On the Home tab, in the Data group or on the Data tab, click the arrow to the right of the  Create formatting rule button and select Clear rules > From this sheet / From entire document from the drop-down menu.

•Right-click the selected range and run the Clear rules > From this sheet / From entire document command from the context menu.