Analyze data in a spreadsheet
Get insights from Zia
Insights by Zia provides you with recommended charts, pivot tables, and insights about your data. You can also ask data-related questions and get instant answers. To get insights: Select the desired data to analyze. Go to ... > Insights Scroll the ...
Set as document filter
Setting a filter as the document filter means the specified filter will be applied to all the users who are opening the spreadsheet for the first time until the filter is either removed or replaced with another. The published version of the file will ...
Save and use a named filter view
To save or name a filter view: Apply a filter on the desired range with the desired criteria. Go to icon Under the Data menu, choose Filter. Tap on Name this Filter, enter a name, and tap Done. Note: To apply a saved filter, select Named Filters and ...
Filter a data range
To apply a filter on a cell range: Select the desired cell range to filter. Go to icon Under the Data menu, choose Filter. Switch on the toggle button to see the filter icons appear on the table header. Tap on the to view the list of criteria (cell ...
Sort a data range
To sort a cell range: Select the cell range to sort, keeping the column to sort by as the first column. Go to icon Under the Data menu, choose Sort. Tap on Ascending or Descending based on how you wish to sort the data.