Search
Clear search
Close search
Google apps
Main menu

We've gotten reports about some users being signed out of their accounts unexpectedly. We're investigating, but not to worry: there is no indication that this is connected to any phishing or account security threats. Please try to sign-in again at accounts.google.com and if you cannot remember your password, please use this link to recover your password. If you use 2-Step Verification, there may have been a delay in receiving your SMS code. Please try again or use backup codes.

See and use suggested charts and analysis in a spreadsheet

Ask questions about the data in your spreadsheet in Google Sheets. You can also see suggestions based on your data. You’ll see suggested:

  • Formatting
  • Charts and analysis

See answers to questions about your data

This feature is only available in English.

  1. Open a spreadsheet in Google Sheets.
  2. In the bottom right, click Explore Explore.
  3. Under "Answers," type your question in the box and press Enter.
  4. To see example answers, click the suggested questions under the text box.

See examples

Example questions:

  • "Which person has the top score?" (where "person" and "score" are in your spreadsheet)
  • "Total sales in September 2016" (where "sales" and a "date" column are in your spreadsheet)

Examples of questions that don’t work:

  • Help questions like, "How do I bold this cell?"
  • Web search questions like, "What’s the weather?"

Add suggested formatting to your spreadsheet

Google Sheets suggests alternating color background formatting, for your spreadsheet.

  1. Open a spreadsheet in Google Sheets.
  2. In the bottom right, click Explore Explore.
  3. To add the suggested formatting to your spreadsheet, click it.
  4. To change the suggestion before you add it, click Edit.

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

See automatic charts & analysis

  1. Open a spreadsheet in Google Sheets.
  2. If you want to see information for a specific portion of your data, select a range of cells. Otherwise, you will get insights based on where your cursor is.
  3. In the bottom right, click Explore Explore.
  4. Charts and analysis will appear, showing trends and patterns from the data in your spreadsheet. Hover over a chart to see which data in the spreadsheet is being used in the chart.
  5. You can see more recommendations by selecting different parts of your data.

Add a chart or formula to your spreadsheet

  1. Open a spreadsheet in Google Sheets.
  2. In the bottom right, click Explore Explore.
  3. To add a chart or formula to your spreadsheet, you can drag the chart or formula into your spreadsheet. You can also add a chart by clicking Insert chart Insert chart.

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

Not seeing any suggestions

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

  • The spreadsheet or selected cell range isn't empty
  • You have 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

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?