Forum Discussion
Inerface for viewing specific data from a table
I have a very big table that gets added to, and changed regularly. I want to know if there is a way to do an interface similar to a pivot table, where I can filter one or more specific rows and c...
If your data are in a table, the headers (field names) should already have filter drop down arrows.
If not, click in any of the headers of your data and select Sort & Filter > Filter on the home tab of the ribbon.
You can easily use the filter arrows to sort and filter the data. When you're done, select Sort & filter > Clear to show all data again.