资讯

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.
You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.