How to Clear Formatting in WPS on Windows

Use Clear Formatting with 2 how-to topics, including clearing formatting from the menu bar and from the right-click menu; 2 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Clear Formatting from the Menu Bar

Entry: Home → Clear Formatting

1. Select the cell or range where you want to remove formatting. Single, continuous, and non-contiguous selections are supported.
2. Click Clear Formatting on the Home tab.
3. Check the selected area and confirm that the cell style has returned to the default display state.
4. Continue editing or apply a new cell style as needed.

Success Criteria

• Visual result: Font, color, border, fill, and alignment settings are removed from the selected area.
• Next action available: Text, numbers, and formulas remain available for viewing and editing.

Tips While Using

• Common mistake: If the wrong range is selected, the cleanup result may not match your expectation.
• Environment note: In collaboration scenarios, formatting changes are visible to other collaborators.

2. Clear Formatting from the Right-Click Menu

Entry: Right-click menu → Clear → Clear Formatting

1. Select the cell or range where you want to remove formatting.
2. Right-click the selected area.
3. In the Clear menu, select Clear Formatting.
4. Confirm that the formatting is removed while the content remains in place.

Success Criteria

• Visual result: The current selection returns to the default display style.
• Next action available: You can continue typing, calculating, copying, or applying new formatting right away.

Tips While Using

• Common mistake: Choosing Clear All instead of Clear Formatting may affect content, so check the menu item name before you confirm.
• Environment note: If the worksheet is in a collaboration state, the result is synced to other collaborators.