How to add a filter to the interface in Excel The dropdown and search filters are good for you, but they’re not great for others who might be viewing the information in your pivot table.

Pivot tables let you parse raw spreadsheet data to display specific information in a concise, easy-to-digest format. Here’s how to use them in Google Sheets.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.