Google Sheets / Google Sheets Power User
Sort and filter data
If your spreadsheet contains a list of data, it can be sorted in order of a specific column of the sheet, and filtered to only show the rows that match specific criteria.
Sorting data
To sort a list of data:
Click in the column you wish to sort
Click on the Data menu, then choose the relevant Sort option
You can view additional sort options if you select the range you wish to sort, then click on the Data menu and choose Sort Range.
Filtering data
The Filter command allows you to display only the rows in a list or table which contain a certain value or meet certain criteria.
To filter a list of data:
Click in the column you wish to filter
Click on the Filter button on the toolbar
The table will be selected and filter arrows will appear next to each heading in the table.
To filter a column:
Click on the arrow next to the column you wish to filter
Click on each value you wish to hide from the list
Click on OK
If the column you are filtering has a long list of items and you only wish to display a few of them, click on the filter arrow, then click on the Clear link. You can now enter each value you wish to show in the Search box, then click on the value when it’s found.
