WPS Clear Formatting on iOS FAQ

Common questions about WPS Clear Formatting on iOS usually involve feature differences, undo options, and entry visibility; this FAQ includes 4 common questions and a 3-term glossary.

FAQ

Will my data stay in the cell after I clear formatting?

1. Yes. Clear Formatting removes only the formatting settings from the selected cells.
2. After the action, check whether the text, numbers, or formulas are still present.
3. If you want to remove the content itself, use Clear Content or Clear All instead.

What is the difference between Clear Content and Clear All?

1. Clear Content removes only the entered content in the selected cells.
2. Clear All removes content, formatting, borders, and related cell display information together.
3. If you want to keep the existing style, choose Clear Content.

Can I undo the action if I clear the wrong range?

1. If the action was just completed, use Undo first.
2. Undoing earlier is more likely to restore the previous state before more edits are made.
3. For important spreadsheets, back up the file before clearing a large range.

Why can’t I find the Clear Formatting option?

1. Make sure you opened a spreadsheet file and selected a cell range first.
2. Check whether you are in the bottom Tools area under the Home tab, or whether the floating toolbar has appeared.
3. If the option still does not appear, update to the latest version of WPS Office for iOS and try again.

Glossary