How to clear content format and comments for cells

Uploaded time: 2021-08-27 Difficulty: Primary

How to clear content format and comments for cells

How to clear content format and comments for cells

Graphic skills

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 contents within the table, select the area that needs to be cleared.

2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and right-click to call out the shortcut menu.  ) GIF.gif


In the following example, 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 button in the Home tab.

3. Then we can choose from the providede Formats.

GIF_1.gif 

If we only need to clear the contents entered into the table, while keeping the format of the cells, we just select the cell range, click the Clear drop-down button, and then choose the Contents option.

GIF_2.gif 

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.

GIF_3.gif