WPS Clear Formatting on macOS FAQ

This FAQ covers 3 common questions about keeping content, clearing both content and formatting, and handling conditional formatting, plus a short glossary.

FAQ

Does Clear Formatting delete cell content?

1. No. Clear Formatting removes visual formatting such as font, color, border, fill, and alignment.
2. Text, numbers, and formulas in the cell remain.
3. If you want to remove both content and formatting, use a different clear option instead of Clear Formatting alone.

How do I clear both content and formatting?

1. Select the target cell or range first.
2. Open the related Clear menu and choose the option that removes both content and formatting.
3. Check whether you still need formulas or text before you apply the action so that data is not removed by mistake.

Can Clear Formatting remove conditional formatting?

1. In this feature guide, the result is described as being able to remove conditional formatting.
2. If your sheet uses more complex rules, review the result right after clearing.
3. If you need to preserve some visual rules, copy the worksheet first and then make the change.

Glossary