How to Clear Formatting in WPS on Android

Use Clear Formatting with 5 how-to topics, including Clear Formatting, Clear Content, Clear Comments, Clear Hyperlinks, and Clear All; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Clear Formatting

Entry path: bottom Tools option → Home tab → Clear → Formatting

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

Success Criteria

• On-screen result: formatting is removed from the selected range.
• What you can do next: cell content remains available for viewing, editing, or applying new formatting.

Tips While Using

• Common mistake: make sure the correct cell range is selected 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 clear.
2. Tap the Tools option at the bottom.
3. Select the Home tab.
4. Tap the Clear button.
5. Tap Content to remove the content from the selected cells.

Success Criteria

• On-screen result: content in the selected range is removed.
• What you can do next: the cells remain available for new input.

Tips While Using

• Common mistake: clearing content removes the data in the selected cells, so confirm the range before you continue.

3. Clear Comments

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

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

Success Criteria

• On-screen result: comment markers in the selected range disappear.
• What you can do next: cell content and formatting can still be kept or edited.

Tips While Using

• Common mistake: if there are no comments in the selected range, the screen may not show an obvious change after the action.

4. Clear Hyperlinks

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

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

Success Criteria

• On-screen result: the link property is removed from the selected cells.
• What you can do next: text content can remain and continue to be edited.

Tips While Using

• Common mistake: do not confuse Clear Hyperlinks with Clear Content, or you may remove text you wanted to keep.

5. Clear All

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

1. Select the cell range you want to clear completely.
2. Tap the Tools option at the bottom.
3. Select the Home tab.
4. Tap the Clear button.
5. Tap All to clear all related items in the selected range.

Success Criteria

• On-screen result: the selected range is cleaned up in one action.
• What you can do next: you can enter new content or apply new formatting again.

Tips While Using

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