Important: Explore in Google Docs, Sheets and Slides will no longer be available by 30 January 2024. You can use the tool finder in Docs, Sheets and Slides to quickly get to actions like 'conditional formatting' in Sheets, 'pageless' in Docs and 'open templates' in Slides. You can also enter '@' and select from a series of items to create content like:
- Drop-downs, emojis and people chips
- Meeting notes and email drafts in Docs
- Finance chips in Sheets
You can get suggestions for the data in your spreadsheet. You’ll find suggestions for formatting, charts and analysis.
Add alternating colour backgrounds automatically
- On your Android phone or tablet, 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 and analysis automatically
- On your Android phone or tablet, 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.