Data tab in Sheets

Data tab in Sheets Android

The Data tab houses options like Sort, Filter and others, especially useful when working with large quantities of data.

	Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order.
	Filter – A great way for managing large amounts of data, Filter manipulates entire cell ranges to display specific entries. Once you apply a filter to a cell range, press the  Down arrow that appears in the cell range to display the Filter dialog:
	Clear Filter – Removes any active filter. Smallest to Largest – Lists values in ascending order. Largest to Smallest – Lists values in descending order. Custom Filter – Provides a wide range of comparison filters that display values that meet particular criteria, such as greater than or equal to. Multiple Choice – Lets you toggle the display of individual cell values. All blanks – Displays all cells with no data. All non-blanks – Displays all cells which contain data.
	Data Validation – Limit the data that can be entered into a cell using custom values.
	Circle Invalid Cells – Circles any invalid data within the sheet for better visibility.