WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to clear content format and comments for cells

Uploaded time: August 27, 2021 Difficulty Beginner

How to clear content format and comments for cells

How to clear content format and comments for cells

When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it?

This video could help to solve this problem. Take this transcript as an example.

1. To clear all contentswithin the table, select the area that needs to be cleared.

2. Click the Clear dropdown buttonin the Hometab, and choosetheAlloption to clear the table as needed. (Notes: We can also use theClearfunction in this step.To realize it, select the area, and right-click to call out the shortcut menu. )

In the followingexample, some of the cells within the transcript are filled with color. How can we clear the color of the cell without clearing the content?

1. Use marquee to select the area needed to be cleared.

2. Click the Clear drop-down buttonin the Hometab.

3. Then we can choose from the providede Formats.

If we only need to clear the contentsentered into the table, while keeping the formatof the cells, we just select the cell range, click the Clear drop-down button, and then choose the Contentsoption.

Now we need to clear all of the three comments in this transcript. Can we clear them only with one click? It's quite simple.

1. We just need to select the entire form.

2. Click the Clear drop-down button.

3. Select Comments to clear all comments.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.