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.