How to clear formatting rules in Excel?

January 5, 2022
76 Views 0

Graphic skills

We can use conditional formatting to mark specific contents quickly. But how can we clear the format when we dont need it? Here are the steps.


1. Select the cells whose format you want to clear.

2. Click Home > Conditional Formatting > Clear Rules.

3. Then we can select Clear Rules from Selected Cells or Clear Rules from Entire Sheet according to actual needs.

How to clear formatting rules in Excel.gif


WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Was this helpful?