'Filtering' Feature Added Into Google Spreadsheets

Google spreadsheets gets "filtering" that make it easier to analyze and view your data. Adding a filter onto a set of data can help you quickly narrow down the data set to find the data you need. By selecting a data set, you can filter and sort amongst many rows at once.To filter your data […]

Google spreadsheets gets "filtering" that make it easier to analyze and view your data. Adding a filter onto a set of data can help you quickly narrow down the data set to find the data you need. By selecting a data set, you can filter and sort amongst many rows at once.

example Google spreadsheet

To filter your data set, first select the information you want to filter. If you click on one cell within a large set of data, it'll expand to select other cells in that range.

Google spreadsheets: filter option

Ranges that're part of the filtered data set will have both the column and row labels colored green.

Google spreasheets: labeled green

Once you've selected your data set, clicking on the drop down icon in the header rows will give a set of filter options. Here, you can change sorting, select specific filters, search and perform bulk actions.

Google Spreadsheets: sorting fileters

Search speeds up filtering for large data sets. For e.g., typing P will shorten the list to just the names that start with P. You can also Select all or Clear to perform bulk actions on the visible items. For e.g. clicking clear below would de-select Peter and Phil.

Google Spreadsheets: Select all or Clear

The icon in the header row will change to a filter to denote the columns that've a filter applied to them. The filter toolbar icon will also change to green if a filter has been applied to any column. Finding all the wines from 2006 that Peter and Phil liked now takes seconds.

Note that filtering and sorting are both applied immediately for all collaborators and per person filtering isn't available at this time. To turn off filtering, just click on the filter icon.

[Source]