Quick Data Filtering

PivotTable allows quick item search by filtering.

Click the arrow next to the header (row, column, or filter) and you can select the data you would like to view:

pivot table
And what if you have dozens of data items on the list and are interested in displaying the ones that begin with “New”?
The simplest way is to type the first letters in the search string in the labels, and the list will be automatically reduced!

pivot table excel

(Works from the 2010 version onwards)

Do you think it was helpful? Share it with your friends