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
- On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
- Tap More
.
- Tap Explore.
- Under "Formatting," choose an option.
- 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
- On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
- Tap More
.
- Tap Explore.
- If formatting and charts are shown, to find more charts, tap More.
- To add a chart, tap 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.