How to Clear Formatting in WPS on iOS

Use Clear Formatting in WPS on iOS through 3 how-to topics: Clear Formatting, Clear Content, and Clear All; 3 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Clear Formatting

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

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

Success Criteria

• UI state: Fonts, colors, fills, or other formatting in the selected range are removed.
• Next actions: The original cell content is still visible and editable.
• No side effects: Unselected cells are not changed.

Tips While Using

• Common mistakes: If you do not select the target range first, the result may not match what you expect.
• Environment limits: The spreadsheet must be in an editable state.

2. Clear Content

Entry point: Floating toolbar → Clear Content

1. Tap and select the cell range whose content you want to remove to bring up the floating toolbar.
2. Tap Clear Content on the floating toolbar.
3. Check whether the text, numbers, or formulas in the selected cells have been removed.

Success Criteria

• UI state: The content in the selected cells is cleared.
• Next actions: The original cell formatting can remain in place for new input.
• No side effects: Nearby unselected areas are not affected.

Tips While Using

• Common mistakes: If you want to keep the content and remove only the style, use Clear Formatting instead of Clear Content.
• Environment limits: You need to bring up the floating toolbar before using the command.

3. Clear All

Entry point: Floating toolbar → Clear All

1. Select the cell range that you want to reset completely.
2. Tap Clear All on the floating toolbar.
3. Confirm that formatting, content, borders, and related cell information have been removed.

Success Criteria

• UI state: The selected range returns to a more blank-cell state.
• Next actions: You can enter new content or apply new formatting again.
• No side effects: Other unselected areas stay unchanged.

Tips While Using

• Common mistakes: If you only want to remove entered values, do not use Clear All by mistake.
• Environment limits: Check the selected range before you continue so important data is not removed accidentally.