How to screen out high-frequency words by excel screening repetition

1. First, select the data cells to be filtered and counted in the excel table.

2. Then click the PivotTable Options icon on the Insert tab.

3. Then drag the word item into the value window of rows and count items.

4. The counting results can be displayed according to all phrases, and the number of all words can be clearly seen.