Ask about your data & get suggested content

Want to get more out of Google Docs for work or school? Sign up for a Google Workspace trial at no charge.

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 .
  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 .
  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?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
false
true
true
35
false
false