How to Clear Formatting in WPS on iOS

Use Clear Formatting with 3 how-to topics, including Clear Formatting, Clear Content, and Clear All; you can jump from the index and complete each task step by step.

How-to Index

How-to Guide

1. Clear Formatting

Entry point: Bottom Tools > Home tab > Format Painter area > Clear Formatting

1. Select the cell range where you want to remove formatting.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. In the Format Painter area, tap Clear Formatting.

Success Criteria

• UI state: formatting is removed from the selected range.
• Next actions: the original cell data can still be edited, saved, or copied.
• No side effects: the cell content is not deleted when you clear formatting.

Tips While Using

• Common mistakes: if you do not select the target range first, the result may not match what you expect.
• Environment limits: this action must be performed in an editable spreadsheet file.

2. Clear Content

Entry point: Floating toolbar > Clear Content

1. Tap and select the cell range where you want to remove content to open the floating toolbar.
2. Tap Clear Content on the floating toolbar.
3. Confirm that the content in the selected cells has been removed.

Success Criteria

• UI state: text, numbers, or formulas in the selected cells are removed.
• Next actions: you can enter new content in the same cell range.
• No side effects: the existing formatting remains available.

Tips While Using

• Common mistakes: mixing up Clear Content and Clear All may remove more than intended.
• Environment limits: the floating toolbar must appear before you can use this action.

3. Clear All

Entry point: Floating toolbar > Clear All

1. Tap and select the cell range that you want to reset to open the floating toolbar.
2. Tap Clear All on the floating toolbar.
3. Check whether formatting, content, borders, and related cell settings have all been removed.

Success Criteria

• UI state: the target range returns to a more basic blank-cell state.
• Next actions: you can enter new content and apply new formatting again.
• No side effects: the action applies only to the currently selected range.

Tips While Using

• Common mistakes: if you do not confirm the selected range first, you may clear more cells than intended.
• Environment limits: check whether you need to keep the original data before using this action.