Get suggestions for charts & analysis in a spreadsheet

You can get suggestions for the data in your spreadsheet. You’ll find suggestions for formatting, charts, and analysis.

Add alternating color backgrounds automatically

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Tap More More.
  3. Tap Explore.
  4. Under "Formatting," choose an option.
  5. To remove the formatting, tap the option again.

Note: You can only add formatting to a spreadsheet if you have permission to edit the file.

Get charts & analysis automatically

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Tap More More.
  3. Tap Explore.
  4. If formatting and charts are shown, to find more charts, tap More.
  5. To add a chart, tap Insert chart Insert chart.

Can't find suggestions

If you open the Explore panel and don’t find any suggestions, make sure that:

  • The spreadsheet or selected cell range isn’t empty.
  • You’ve selected a range of data that contains numbers, repeated text, or another type of pattern. For example, a range of data with "Yes" / "No" form responses.

Related articles

Was this helpful?
How can we improve it?