How to Clear Formatting in WPS on macOS

Use Clear Formatting with 2 how-to topics covering the Home tab method and the right-click menu method; choose a topic from the index and follow the steps to finish the task, with 2 free items and 0 membership-related items.

How-to Index

How-to Guide

1. Clear formatting from the Home tab

Entry: Home → Clear → Clear Formatting

1. Select the cell or range where you want to remove formatting.
2. Click Clear Formatting on the Home tab.
3. Check whether the selected cells return to the default style.
4. Confirm that text, numbers, and formulas are still kept in the cells.

Success Criteria

• Interface result: Fonts, colors, borders, fills, and alignment are removed from the selected area.
• What you can do next: You can continue typing, editing, saving, or applying new formatting.
• No side effect: Existing cell content is not deleted.

Tips While Using

• Common mistake: Confirm the selected range before running the action so you do not clear formatting in the wrong area.
• Environment note: In collaboration mode, formatting changes may sync 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. Check that the formatting is removed immediately while the content stays in place.

Success Criteria

• Interface result: The selected area returns to the default display style.
• What you can do next: You can continue copying, filling, reformatting, or saving the file.
• No side effect: Text, numbers, and formulas remain unchanged.

Tips While Using

• Common mistake: In the right-click menu, make sure you choose Clear Formatting instead of Clear All.
• Environment note: You can also use this action after selecting multiple non-contiguous ranges.