Data tab in Sheets

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.