Sorting and Filtering Spreadsheets

You can organize your data for easier viewing and deeper analysis using sorting and filtering.

Sorting a Spreadsheet

To sort your data:

1
Select the content to sort. To select an entire spreadsheet, click in the top left corner.
2
Go to the Data tab and click Sort.
3
Choose your sorting criteria from the dialog box, as well as whether you want to sort in ascending or descending order. If there is a header row, you can also choose to sort by headers instead of columns by clicking the option.

The sort menu

4
Click Sort to finish and see the results.

Filtering a Spreadsheet

1
Go to the Data tab and click Filter to enable filters.
2
Click the Filter icon at the top of the column you would like to filter by.
3
Select the items you would like to see and hide from the list. You can also choose to display filtered results in ascending or descending order. The current filter is shown above the search bar. You can change the filter parameter by clicking Change then selecting terms to use as filters.

The filter menu

4
Click Apply to filter the spreadsheet.