How to clear content format and comments for cells

Uploaded time: August 27, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

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.


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.