Data tab in Sheets

Data tab in Sheets Android

The Data tab houses options like SortFilter 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.

Was this article helpful?

0 out of 3 found this helpful