Search this site
Embedded Files
  • Home
  • Gmail
    • Getting started with Gmail
    • Gmail Power User
    • What's new in Gmail?
    • Gmail FAQs
  • Calendar
    • Getting started with Calendar
    • Calendar Power User
    • What's new in Calendar?
    • Calendar FAQs
  • Meet
    • Getting started with Meet
    • Meet Power User
    • What's new in Meet?
    • Meet FAQs
  • Chat
    • Getting started with Google Chat
    • Google Chat Power User
    • What's new in Chat?
    • Chat FAQs
  • Drive
    • Getting started with Drive
    • Drive Power User
    • What's new in Drive?
    • Drive FAQs
  • Docs
    • Getting started with Google Docs
    • Google Docs Power User
    • What's new in Docs?
    • Docs FAQs
  • Sheets
    • Getting started with Google Sheets
    • Google Sheets Power User
    • What's new in Sheets?
    • Sheets FAQs
  • Slides
    • Getting started with Google Slides
    • Google Slides Power User
    • What's new in Slides?
    • Slides FAQs
  • Forms
    • Getting started with Forms
    • Forms Power User
    • What's new in Forms?
    • Forms FAQs
  • Sites
    • Getting started with Sites
    • Sites Power User
    • What's new in Sites?
    • Sites FAQs
  • Groups
    • Getting started with Collaborative Inboxes
    • Collaborative Inboxes Power User
    • What's new in Collaborative Inboxes?
    • Collaborative Inboxes FAQs
 
  • Home
  • Gmail
    • Getting started with Gmail
    • Gmail Power User
    • What's new in Gmail?
    • Gmail FAQs
  • Calendar
    • Getting started with Calendar
    • Calendar Power User
    • What's new in Calendar?
    • Calendar FAQs
  • Meet
    • Getting started with Meet
    • Meet Power User
    • What's new in Meet?
    • Meet FAQs
  • Chat
    • Getting started with Google Chat
    • Google Chat Power User
    • What's new in Chat?
    • Chat FAQs
  • Drive
    • Getting started with Drive
    • Drive Power User
    • What's new in Drive?
    • Drive FAQs
  • Docs
    • Getting started with Google Docs
    • Google Docs Power User
    • What's new in Docs?
    • Docs FAQs
  • Sheets
    • Getting started with Google Sheets
    • Google Sheets Power User
    • What's new in Sheets?
    • Sheets FAQs
  • Slides
    • Getting started with Google Slides
    • Google Slides Power User
    • What's new in Slides?
    • Slides FAQs
  • Forms
    • Getting started with Forms
    • Forms Power User
    • What's new in Forms?
    • Forms FAQs
  • Sites
    • Getting started with Sites
    • Sites Power User
    • What's new in Sites?
    • Sites FAQs
  • Groups
    • Getting started with Collaborative Inboxes
    • Collaborative Inboxes Power User
    • What's new in Collaborative Inboxes?
    • Collaborative Inboxes FAQs
  • More
    • Home
    • Gmail
      • Getting started with Gmail
      • Gmail Power User
      • What's new in Gmail?
      • Gmail FAQs
    • Calendar
      • Getting started with Calendar
      • Calendar Power User
      • What's new in Calendar?
      • Calendar FAQs
    • Meet
      • Getting started with Meet
      • Meet Power User
      • What's new in Meet?
      • Meet FAQs
    • Chat
      • Getting started with Google Chat
      • Google Chat Power User
      • What's new in Chat?
      • Chat FAQs
    • Drive
      • Getting started with Drive
      • Drive Power User
      • What's new in Drive?
      • Drive FAQs
    • Docs
      • Getting started with Google Docs
      • Google Docs Power User
      • What's new in Docs?
      • Docs FAQs
    • Sheets
      • Getting started with Google Sheets
      • Google Sheets Power User
      • What's new in Sheets?
      • Sheets FAQs
    • Slides
      • Getting started with Google Slides
      • Google Slides Power User
      • What's new in Slides?
      • Slides FAQs
    • Forms
      • Getting started with Forms
      • Forms Power User
      • What's new in Forms?
      • Forms FAQs
    • Sites
      • Getting started with Sites
      • Sites Power User
      • What's new in Sites?
      • Sites FAQs
    • Groups
      • Getting started with Collaborative Inboxes
      • Collaborative Inboxes Power User
      • What's new in Collaborative Inboxes?
      • Collaborative Inboxes FAQs

Google Sheets / Google Sheets Power User

Explore in sheets

TRY IT OUT

The Explore command in Google Docs, Sheets and Slides allows you to research information without leaving your file. You will receive instant suggestions based on the content of your sheet, and can view related topics at any time. 

As well as a feature that allows you to ask plain English questions about your data, the Explorer option in Google Sheets now includes formatting suggestions, to help you present your data in the best way for your audience. In addition, you can ask the Explorer option to create charts based on your data. 

To explore the data in a sheet:

  • Click on the Explore button near in the bottom-right corner of the screen

  • Suggested questions about your data will be listed at the top of the Explorer pane - click on a question to view the answer, or type your own question in the Ask a question about your data box

  • Under the Answers area, click on a Formatting option to format your data

  • Scroll down the Explore pane to view pivot tables and charts for your data

  • Click on a chart or pivot table to show options to add the chart or table to your sheet

If the Explore button shows in grey, this means that Google has no insights to offer on your data. Try selecting specific data in the sheet to view insights on that data.

TRY IT OUT

Learn More about Google Workspace:

Gmail

Google Calendar

Google Meet

Google Chat

Google Drive

Google Docs

Google Sheets

Google Slides

Google Forms

Google Sites

Collaborative Inboxes

Report abuse
Report abuse