How to clear formatting rules in Excel?

January 5, 2022

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.

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