How to Clear Formatting in WPS on macOS

This how-to guide includes 2 operation topics for Clear Formatting in WPS on macOS; all 2 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. You can use a single cell, a continuous range, or multiple non-adjacent selections.
2. Click the Home tab at the top of the window.
3. Click Clear Formatting.
4. Check the result. The selected cells return to a default appearance while the content stays in place.

Success Criteria

• Visual result: Font, color, border, fill, alignment, and other formatting in the selected area are removed.
• Next step available: Text, numbers, and formulas can still be edited, saved, and calculated.

Tips While Using

• Common mistake: If you do not select the target range first, the action may not affect the cells you intended.
• Tip: Confirm that you want to clear formatting only, not cell contents, before you apply the command.

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 inside the selected area.
3. In the Clear menu, select Clear Formatting.
4. Confirm that the formatting is removed and the content remains.

Success Criteria

• Visual result: The current selection returns to a default appearance.
• Next step available: You can continue typing, copying, pasting, or saving the spreadsheet right away.

Tips While Using

• Common mistake: If you right-click outside the intended selection, the action may apply to a different target.
• Tip: This path is useful when you want to clear formatting in a local area more quickly.