How to Clear Formatting in WPS on Android

Use Clear Formatting on Android through 5 how-to topics, all available without membership; start from the How-to Index and follow the matching steps for the task you need.

How-to Index

How-to Guide

1. Clear Format

Entry path: Bottom Tools option → Home tab → Clear → Format

1. Select the cell range whose formatting you want to remove.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Clear.
5. Tap Format to remove formatting from the selected cells.

Success Criteria

• On-screen result: the original cell formatting is removed.
• What you can do next: the cell content can still be edited, copied, or styled again.

Tips While Using

• Common mistake: confirm the selected range before you clear it.

2. Clear Content

Entry path: Bottom Tools option → Home tab → Clear → Content

1. Select the cell range whose content you want to remove.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Clear.
5. Tap Content to remove the content from the selected cells.

Success Criteria

• On-screen result: the content in the selected cells is removed.
• What you can do next: you can enter new content or paste data into the cells.

Tips While Using

• Common mistake: confirm whether the original data still needs to be kept before clearing content.

3. Clear Comments

Entry path: Bottom Tools option → Home tab → Clear → Comments

1. Select the cell range whose comments you want to remove.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Clear.
5. Tap Comments to remove comments from the selected cells.

Success Criteria

• On-screen result: the comment marker or comment content is removed.
• What you can do next: the cells can still keep their data and remain editable.

Tips While Using

• Common mistake: if the comment still needs to be kept for reference, confirm before removing it.

4. Clear Hyperlinks

Entry path: Bottom Tools option → Home tab → Clear → Hyperlinks

1. Select the cell range whose hyperlinks you want to remove.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Clear.
5. Tap Hyperlinks to remove link information from the selected cells.

Success Criteria

• On-screen result: the cells no longer keep hyperlink jump attributes.
• What you can do next: the text or data can still remain and be edited.

Tips While Using

• Common mistake: if you still need the link, copy it first before clearing it.

5. Clear All

Entry path: Bottom Tools option → Home tab → Clear → All

1. Select the cell range that you want to clear completely.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Clear.
5. Tap All to clear related content and settings in the selected cells at once.

Success Criteria

• On-screen result: related content and settings in the selected range are cleared together.
• What you can do next: you can enter new data or apply formatting again right away.

Tips While Using

• Common mistake: this action affects a wider scope, so confirm the selected range again before you proceed.