How to Clear Formatting in WPS on Windows

This how-to guide includes 2 topics: clearing formatting from the top menu bar and clearing formatting from the right-click menu; choose a topic from the index and follow the steps to finish the task.

How-to Index

How-to Guide

1. Clear formatting from the top menu bar

Entry: Home → Clear Formatting

1. Select the cell or range that you want to reset.
2. Click the Home tab at the top of the window.
3. Click Clear Formatting.
4. Check the result and confirm that the cell appearance returns to the default style while the content stays in place.

Success Criteria

• Visual result: Fonts, colors, borders, fills, or alignment settings are removed from the selected area.
• You can continue working: Text, numbers, and formulas remain editable.

Tips While Using

• Common mistake: If the target range is not selected first, the command may not affect the intended cells.
• Environment note: If the worksheet is protected, some editing actions may be limited.

2. Clear formatting from the right-click menu

Entry: Right-click menu → Clear → Clear Formatting

1. Select the cell or range that you want to reset.
2. Right-click inside the selected area.
3. Find Clear in the context menu.
4. Select Clear Formatting.
5. Confirm that the formatting is removed and the content remains.

Success Criteria

• Visual result: The selected area returns to a cleaner default display.
• You can continue working: You can keep typing, calculating, copying, or applying a new format.

Tips While Using

• Common mistake: Choosing Clear All instead of Clear Formatting can affect content as well, so check the menu item before you confirm.
• Environment note: The exact layout of the right-click menu can vary, but the clear-format logic stays the same.