Data tab in Sheets

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.

Was this article helpful?

0 out of 5 found this helpful