WPS Clear Formatting on Windows FAQ

This FAQ covers 3 common questions about keeping content, clearing both content and formatting, and checking how formatting reset affects worksheet rules, plus a short glossary.

FAQ

Does Clear Formatting delete cell content?

1. No. Clear Formatting removes appearance settings such as font, color, border, fill, and alignment.
2. Text, numbers, and formulas in the cell remain in place.
3. After that, you can keep editing the content or apply a new format.

How do I clear both content and formatting?

1. Select the target cell or range.
2. Open the related Clear menu.
3. Choose Clear All instead of Clear Formatting to remove both content and formatting together.

Can Clear Formatting remove conditional formatting?

1. This feature removes formatting already applied to the selected cells.
2. If the worksheet uses more complex rules, test the result on a smaller range first.
3. After the action is complete, review the display and decide whether any conditional formatting rules need to be set again.

Glossary