Data tab in Sheets

• Data tab in Sheets Windows
• Data tab in Sheets Android
• Data tab in Sheets iOS

Data tab in Sheets Windows

The Data dropdown allows you to easily manage data sets.

Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order.

	Sort A to Z – Sorts cells alphabetically. Numerical data will be sorted in ascending order.
	Sort Z to A – Sorts cells reverse alphabetically. Numerical data will be sorted in descending order.
	Custom Sort... – Opens the sort dialog, allowing you to sort data using custom criteria.

	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.
	Data Validation... – Opens the Data Validation dialog, used to manage and highlight cells that return invalid cell data.
	Circle Invalid Data – Circles invalid data as specified using Data Validation above.
	Group... – Groups a range of rows or columns.
	Ungroup... – Ungroups a range of rows or columns.
	Clear Outlines – Hides the outlines of a grouped range of rows or columns. This does not ungroup them.
	Subtotal... – Shows options for calculating a subtotal of a group of cells.
	Show Detail – Expands a group of previously hidden cells.
	Hide Detail – Collapses a group of cells.

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.

Data tab in Sheets iOS

The Data tab allows you to organize and validate the data in your spreadsheet, as well as to manage the cases of invalid data. Options include:

	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. Reapply Filter – Reapplies the most recent active filter. Comparison Filter – Will filter out results that are less than, greater than, equal, or not equal to a specific value. The And/Or boxes can be used for applying additional comparisons. Multiple Selection – Lets you toggle the display of individual cells. (Show all) can be used to select/deselect all the cells. Above Average – Displays only the cells which are above the average value of the cell range. Below Average – Displays only the cells which are below the average value of the cell range. Top N – Can show the top/bottom N percent/number of items, where N is a specified number that you can adjust using the - and + arrows next to Count.
	Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order:
	My Data Has Headers – Specifies whether you have included headers or title cells as part of your selected cell range. Case Sensitive – Specifies whether your sort options should take into account capitalization.
	Data Validation – A very practical way of managing what type of data can be inserted in specific places in your spreadsheet, based on pre-defined criteria such as data type, length and more. Any data not matching the criteria will return an error message. Options for Data Validation include:
	Criteria – Defines the criteria by which data inserted into the selected file will be validated. Options include Any value, Whole number, Decimal, List, Date, Time and Text Length. Error Alert – Allows you to set what kind of alert message will appear if data inserted into a cell does not meet the aforementioned Criteria. You can choose whether or not to receive an error alert at all using the Show error alert toggle, choose what style the alert will be (Error/Warning/Information), the Title of the alert and lastly, allows you to type in a Message that will display upon triggering the error alert. Input Message – You can set up messages giving further information and instructions on filling out spreadsheets heavily reliant on Data Validation. Options include to set whether a message will be shown at all using the Show input message toggle, give the message a Title and lastly, type out the Message itself.
	Circle Invalid Data – Allows you to quickly see the cases in which data inserted into the sheet does not match the criteria of Data Validation.
	Group – Group a range of rows or columns.
	Ungroup – Ungroup a range of rows or columns.
	Show Detail – Expand a group of previously hidden cells.
	Hide Detail – Collapse a group of cells.