This article is for people who use a screen reader program such as Windows Narrator, JAWS, or NVDA with Windows tools or features and Microsoft 365 products. This article is part of the Accessibility help & learning content set where you can find more accessibility information on our apps. For general help, visit Microsoft Support.
Copilot in Excel helps you to manage your data by suggesting formulas for complex calculations, allowing you to conditionally format tables, and providing insights and analysis for your data into your data. It is designed to enhance productivity and simplify complex tasks. For more great ideas on using Copilot in Excel, go to the Excel Blog.
In this topic
Navigate Copilot in Excel
Generate formulas using Copilot
Understand and explain data
Apply color and formatting
Copilot for Advanced analysis
Ask copilot
Navigate the prompt guide
Generate a prompt using voice commands
Enhance your experience with dynamic prompts
Navigate Copilot in Excel
Copilot in Excel streamlines data management and enhances your productivity.
Follow these instructions to automate tasks, analyze data, and generate insights more efficiently using Copilot in Excel.
To navigate Copilot in Excel, open the Excel app and create a new workbook or open an existing one.
Use the Tab key to navigate through the ribbon until you hear "Copilot," then press Enter to open the Copilot chat pane. Alternatively, press Alt+H, followed by F, X to open the Copilot chat pane.
Type your prompt in the prompt edit box, use the Tab key to select the Send button, and then press Enter to generate a response.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Here are some sample prompts to get you started:
- "Suggest a formula to calculate the average sales per region."
- "Bold the top 3 values in Annual Sales."
- "Filter the data to display only products with a rating above 5 stars."
Once the response has been generated, move the focus to the generated content by pressing Tab or Shift+Tab, then navigate into the generated response by pressing Enter.
Press Esc to navigate out of the generated response.
Copilot streamlines the creation of complex formulas with step-by-step guidance. Users can quickly construct accurate calculations, reducing the need for manual input and minimizing errors.
Open the Copilot chat pane using Alt+H, followed by F, X.
To generate a formula based on your workbook data, type "Suggest a formula column" in the prompt edit box, provide a description of the columns or rows to address, press the Tab key to select the Send button, and then press Enter.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Navigate using Tab and select the generated response, then press Enter to interact with it.
Note
: To display the formula explanation, navigate and select the Show explanation button.
Use the Tab key to select the Insert column button, and press Enter to apply the formula. Or do one of the following:
- To refresh the existing prompts in the suggested prompts group, select the Refresh button.
- For a new column suggestion, select the Give me another column suggestion button.
Understand and explain data
Copilot provides detailed summaries of key insights, explains trends, and identifies outliers in your data, helping users analyze patterns and draw meaningful conclusions from it.
Open the Copilot chat pane using Alt+H, followed by F, X.
To explore the data in the table using Copilot, type "Show data insights" in the prompt edit box and press Enter.
Navigate using the Tab key and select the generated response.
To explore additional prompts in the Copilot chat pane, press Tab to select a prompt, then press Enter to generate a response based on the prompt chosen.
Copilot can customize your data presentation by color-coding cells, and assisting you in highlighting, filtering, and sorting information effectively.
Open the Copilot chat pane using Alt+H, followed by F, X.
To format the data in the table, type "Highlight all cells with" in the prompt edit box, provide the necessary details, and press Tab to select the Send button, then press Enter to generate a response based on your prompt.
Note
If you want to stop the generation process, navigate, and select the Stop generating button.
Navigate using the Tab key and select the generated response.
- Press Enter to engage with the generated response.
- Press Tab to navigate through the generated response.
To apply the changes to the workbook, press the Tab key to select the Apply button, then press Enter.
Copilot for Advanced analysis
Copilot can handle advanced data analysis tasks such as creating pivot tables, running statistical analysis, and generating projections or forecasts.
Open the Copilot chat pane using Alt+H, followed by F, X.
To begin advanced analysis, type either "Analyze this data using Python" or "Run advanced analysis using Python" in the prompt edit box and press Enter.
Press the Tab key until you hear "Chat messages list." Then, press Enter to engage with the chat.
Use the Tab key to select the Start advanced analysis button, and press Enter to initiate the advanced analysis mode.
Note
- If you want to stop the generation process, navigate, and select the Stop generating button.
- Once the advanced analysis starts, Copilot creates a new sheet for your analysis and inserts any necessary Python code.
- To ask any follow-up questions, you can either select one of the prompts from the suggested prompts group or manually type instructions in the prompt edit box.
To request an explanation about the analysis, press the Tab key to select the Show explanation button, and then press Enter.
To exit advanced analysis mode, press the Tab key to select the Stop advanced analysis button and press Enter.
Ask copilot
Ask Copilot allows users to effortlessly interact with their data within Excel. This feature helps users to work with the data without needing to have advanced formulas or Excel knowledge, as Copilot handles complex questions and provides direct guidance.
Open the Copilot chat pane using Alt+H, followed by F, X.
To ask Copilot a question, type it into the prompt box, such as "How do I sum values in a column?" and press Enter.
Navigate through the generated responses using Tab or Shift+Tab.
- Press Enter to engage with the generated response.
- Use the Tab key to navigate through the generated response, and press Esc to return to the list.
To learn more of what Copilot can help with, type more questions in the edit field, like "How can Copilot help?"
Navigate the prompt guide
The prompt guide in the Copilot chat pane provides access to a wide range of prompts for various contexts and purposes. To navigate the prompt guide, follow these steps:
Press Alt+H, followed by F, X to open the Copilot chat pane.
- If the Copilot chat pane is already open, use Fn+F6 until the focus shifts to the Copilot pane.
Navigate using the Tab key until you hear "Open View Prompts button.” Then press Enter to open the context menu.
Use the Up or Down arrow keys to navigate through the categories of prompts; once selected, press Enter. Focus will shift to the prompts list within that category.
Use the Up or Down arrow keys to review the available prompts, and press Enter to select. With some prompts, you will be automatically directed to the prompt edit to make customizations before Copilot can generate information.
Note
If you want to stop the generation process, navigate, and select the Stop generating button
Once customized, press the Tab key until you hear “Send button,” then press Enter.
Tip
Select View more prompts to explore a broader range of prompts in the Copilot Prompt Gallery. For more information on navigating the Copilot Prompt Gallery, go to Use Copilot Lab with a screen reader.
Generate a prompt using voice commands
The voice command feature enables you to interact with the application hands-free. This feature makes workflows smoother and helps you navigate and enter data more easily.
- In the prompt edit, press Tab until you hear “Microphone paused switch,” then press Enter.
- The system will announce "microphone listening" once it activates the microphone.
- Start entering commands using your voice, press Tab to select the Send button and press Enter.
- Navigate using Tab and select the generated response. Press Enter to engage with the generated response, and press Esc to navigate out of the message and back to the list.
Enhance your experience with dynamic prompts
The new dynamic bubbles in the Getting Started experience within the Copilot chat pane offer an interactive and engaging way to guide users through their journey. These bubbles dynamically adapt based on the context, providing helpful tips, suggestions, and quick actions to enhance the user experience. This feature makes it easier for users to explore and get familiar with Copilot's capabilities, ensuring a smoother onboarding process.
See also
Identify insights with Copilot in Excel
Highlight, sort, and filter your data with Copilot in Excel
Microsoft Copilot help & learning
Get started with Copilot in Excel
Technical support for customers with disabilities
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
Copilot in Excel helps you to manage your data by suggesting formulas for complex calculations, allowing you to edit data within columns, and providing insights into your data. It is designed to enhance productivity and simplify complex tasks. For more great ideas on using Copilot in Excel, go to the Excel Blog.
In this topic
Navigate Copilot in Excel
Generate formulas using Copilot
Understand and explain data
Apply color and formatting
Copilot for Advanced analysis
Ask copilot
Navigate the prompt guide
Generate a prompt using voice commands
Enhance your experience with dynamic prompts
Navigate Copilot in Excel
Excel in Copilot streamlines data management and enhances your productivity.
Follow these instructions to automate tasks, analyze data, and generate insights more efficiently using Copilot in Excel.
To navigate Copilot in Excel, open the Excel app and create a new workbook or open an existing one.
Press F6 and use the Tab key to navigate through the ribbon until you hear "Copilot," then press Enter to open the Copilot chat pane. Alternatively, press Alt+H, followed by F, X to open the Copilot chat pane.
Type your prompt in the prompt edit box, use the Tab key to select the Send button, and then press Return to generate a response.
Here are some sample prompts to get you started:
"Suggest a formula to calculate the average sales per region."
"Bold the top 3 values in Annual Sales."
"Filter the data to display only products with a rating above 5 stars."
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Once the response has been generated, move the focus to the generated content by pressing Tab or Shift+Tab, then navigate into the generated response by pressing Enter.
Press Esc to navigate out of the generated response.
Copilot streamlines the creation of complex formulas with step-by-step guidance. Users can quickly construct accurate calculations, reducing the need for manual input and minimizing errors.
Open the Copilot chat pane using Alt+H, followed by F, X.
Use the Tab key to select Create formulas, and then press Return to generate a formula based on the data in your current workbook. You can specify which columns or rows to address by typing a description in the prompt edit box.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Navigate using Tab and select the generated response, then press Enter to interact with it.
Note
To display the formula explanation, navigate and select the Show explanation button.
Use the Tab key to select the Insert column button, and press Return to apply the formula. Or do one of the following:
- To refresh the existing prompts in the suggested prompts group, select the Refresh button.
- For a new column suggestion, select the Give me another column suggestion button.
Understand and explain data
Copilot provides detailed summaries of key insights, explains trends, and identifies outliers in your data, helping users analyze patterns and draw meaningful conclusions from it.
Open the Copilot chat pane using Alt+H, followed by F, X.
If chat history is available, press Tab until you hear "chat message list," then use the Up or Down arrow keys to select Understand.
If chat history is not available, press Tab until you hear Create formulas, then press the Down arrow to select Understand, and then press Return to start summarizing the data using pivot tables or charts.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Navigate using the Tab key and select the generated response.
- Press Enter to engage with the generated response.
- Press Tab to navigate through the generated response.
To explore additional prompts in the Copilot chat pane, press Tab to select a prompt, then press Return to generate a response based on the prompt chosen. Apply color and formatting
Copilot can customize your data presentation by color-coding cells, adding borders, changing fonts, and assisting you in highlighting, filtering, and sorting information effectively.
Open the Copilot chat pane using Alt+H, followed by F, X.
If chat history is available, press Tab until you hear "chat message list," then use the Up or Down arrow keys to select Apply color and formatting.
- If chat history is not available, press Tab until you hear “Create formulas,” then press the Down arrow key to select Apply color and formatting, and then press Return to insert the beginning of the prompt "Highlight all cells with" in the prompt edit box.
Customize the prompt and press Tab to select Send, then press Return to generate a response based on your prompt.
Note
If you want to stop the generation process, navigate, and select the Stop generating button.
Navigate using the Tab key and select the generated response.
- Press Return to engage with the generated response.
- Press Tab to navigate through the generated response.
To apply the changes to the workbook, press the Tab key to select the Apply button, then press Return.
Copilot for Advanced analysis
Copilot can handle advanced data analysis tasks such as creating pivot tables, running statistical analysis, and generating projections or forecasts.
Open the Copilot chat pane using Alt+H, followed by F, X.
- If chat history is available, press Tab until you hear "chat messages list," then use the Up or Down arrow keys to select Advanced analysis.
- If chat history is not available, press Tab until you hear “Create Formulas,” then press the Down arrow key to select Advanced analysis, and then press Return.
- Alternatively, use the Tab key until you hear “prompt edit” and type the prompt like:
- "Analyze this data using Python"
- "Run advanced analysis using Python"
Press the Tab key until you hear "Chat messages list." Then, press Return to engage with the chat.
Use the Tab key to select the Start advanced analysis button, and press Return to initiate the advanced analysis mode.
Note
- If you want to stop the generation process, navigate, and select the Stop generating button.
- Once the advanced analysis starts, Copilot creates a new sheet for your analysis and inserts any necessary Python code.
- To ask any follow-up questions, you can either select one of the prompts from the suggested prompts group or manually type instructions in the prompt edit box.
To request an explanation about the analysis, press the Tab key to select the Show explanation button, and then press Return.
To exit advanced analysis mode, press the Tab key to select the Stop advanced analysis button and press Return.
Ask copilot
Ask Copilot allows users to effortlessly interact with their data within Excel. This feature helps users to work with the data without needing to have advanced formulas or Excel knowledge, as Copilot handles complex tasks and provides direct guidance.
Open the Copilot chat pane using Alt+H, followed by F, X.
Navigate through the Copilot chat pane and select Ask Copilot. Once selected, prompt edit box displays the text, “How do I sum values based on” that you can customize or type a new question.
Use the Tab key to navigate and select the Send button, then press Return to generate a response based on your prompt.
Navigate through the generated responses using Tab or Shift+Tab.
- Press Return to engage with the generated response.
- Use the Tab key to navigate through the generated response, and press Esc to return to the list.
To learn more of what Copilot can help with, type more questions in the edit field, like "How can Copilot help?"
Navigate the prompt guide
The prompt guide in the Copilot chat pane provides access to a wide range of prompts for various contexts and purposes. To navigate the prompt guide, follow these steps:
Press Alt+H, followed by F, X to open the Copilot chat pane.
- If the Copilot chat pane is already open, use F6 until the focus shifts to the Copilot pane.
Navigate using the Tab key until you hear "Open View Prompts button.” Then press Return to open the context menu.
Use the Up or Down arrow keys to navigate through the categories of prompts; once selected, press Return. Focus will shift to the prompts list within that category.
Use the Up or Down arrow keys to review the available prompts, and press Return to select. With some prompts, you will be automatically directed to the prompt edit to make customizations before Copilot can generate information.
Note
If you want to stop the generation process, navigate, and select the Stop generating button.
Once customized, press the Tab key until you hear “Send button,” then press Return.
Tip
Select View more prompts to explore a broader range of prompts in the Copilot Prompt Gallery. For more information on navigating the Copilot Prompt Gallery, go to Use Copilot Lab with a screen reader.
Generate a prompt using voice commands
The voice command feature enables you to interact with the application hands-free. This feature makes workflows smoother and helps you navigate and enter data more easily.
- In the prompt edit, press Tab until you hear “Microphone paused switch,” then press Return.
- The system will announce "microphone listening" once it activates the microphone.
- Start entering commands using your voice, press Tab to select the Send button and press Return.
- Navigate using Tab and select the generated response. Press Return to engage with the generated response, and press Esc to navigate out of the message and back to the list.
Enhance your experience with dynamic prompts
The new dynamic bubbles in the Getting Started experience within the Copilot chat pane offer an interactive and engaging way to guide users through their journey. These bubbles dynamically adapt based on the context, providing helpful tips, suggestions, and quick actions to enhance the user experience. This feature makes it easier for users to explore and get familiar with Copilot's capabilities, ensuring a smoother onboarding process.
See also
Identify insights with Copilot in Excel
Highlight, sort, and filter your data with Copilot in Excel
Microsoft Copilot help & learning
Get started with Copilot in Excel
Technical support for customers with disabilities
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
Copilot in Excel for iPad helps you to manage your data by suggesting formulas for complex calculations, allowing you to edit data within columns, and providing insights into your data. It is designed to enhance productivity and simplify complex tasks. For more great ideas on using Copilot in Excel, go to the Excel Blog.
Note
This topic assumes that you are using the built-in iPad screen reader, VoiceOver. To learn more about using Voice Over, visit Apple accessibility.
In this topic
Navigate Copilot in Excel
Generate formulas using Copilot
Understand and explain data
Apply color and formatting
Ask copilot
Navigate the prompt guide
Enhance your experience with dynamic prompts
Navigate Copilot in Excel
Excel in Copilot streamlines data management and enhances your productivity. To cycle through the elements on screen, swipe right (forward) or left (backward).
Follow these instructions to automate tasks and generate insights more efficiently using Copilot in Excel.
To navigate Copilot in Excel, open the Excel app and create a new workbook or open an existing one.
Flick right or left until you hear the “Copilot button," then double-tap the screen to open the Copilot pane.
Type your prompt in the text field and flick right to select the Send button, then double-tap to generate a response. Here are some sample prompts to get you started:
"Suggest a formula to calculate the average sales per region."
"Bold the top 3 values in Annual Sales."
"Filter the data to display only products with a rating above 5 stars."
Note
If you want to stop the generation process, flick right to select the Stop generating button and double-tap the screen.
Once the response has been generated, flick right or left to move the focus to the generated content, then double-tap the screen to navigate the response.
Copilot streamlines the creation of complex formulas with step-by-step guidance. Users can quickly construct accurate calculations, reducing the need for manual input and minimizing errors.
Open the Copilot pane, then flick right to select Create formulas menu item, and double-tap to generate a formula based on the data in your current workbook. You can specify which columns or rows to address by typing a description in the prompt text field.
Note
If you want to stop the generation process, flick right to select the Stop generating button, then double-tap the screen.
Flick right or left to select the generated response, then double-tap the screen to interact with it.
Note
To display the formula explanation, flick to the Show explanation button, and double-tap the screen.
Flick right or left to select the Insert column button, and double-tap the screen to apply the formula. Or do one of the following:
- To refresh the existing prompts in the suggested prompts group, flick to the Refresh button and double-tap the screen.
- For a new column suggestion, flick right to select the Give me another column suggestion button and double-tap the screen.
Understand and explain data
Copilot provides detailed summaries of key insights, explains trends, and identifies outliers in your data, helping users analyze patterns and draw meaningful conclusions from it.
Open the Copilot pane, then flick right until you hear “Understand menu item,” and double-tap the screen to start summarizing the data using pivot tables or charts.
Note
If you want to stop the generation process, flick right or left to select the Stop generating button, then double-tap the screen.
Flick right or left to navigate and select the generated response and double-tap the screen to engage with the generated response.
To explore additional prompts in the Copilot pane, flick right to select a prompt, then press double-tap to generate a response.
Copilot can customize your data presentation by color-coding cells, adding borders, changing fonts, and assisting you in highlighting, filtering, and sorting information effectively.
Open the Copilot pane, then flick right until you hear "Apply color and formatting menu item,” and double-tap the screen to insert the beginning of the prompt "Highlight all cells with" in the prompt text field.
Customize the prompt and flick right to select Send button, then double-tap the screen to generate a response based on your prompt.
Note
If you want to stop the generation process, flick right or left to select the Stop generating button, then double-tap the screen.
Flick right or left to navigate and select the generated response and double-tap the screen to engage with the generated response.
To apply the changes to the workbook, flick right to select the Apply button, then double-tap the screen.
Ask copilot
Ask Copilot allows users to effortlessly interact with their data within Excel. This feature helps users to work with the data without needing to have advanced formulas or Excel knowledge, as Copilot handles complex tasks and provides direct guidance.
Ask Copilot allows users to effortlessly interact with their data within Excel. This feature helps users to work with the data without needing to have advanced formulas or Excel knowledge, as Copilot handles complex tasks and provides direct guidance.
Open the Copilot pane, then flick right until you hear "Ask Copilot menu item,” and double-tap the screen.
- Once selected, prompt text field displays the text, “How do I sum values based on” that you can customize or type a new question.
Flick right to select the Send button, then double-tap the screen to generate a response based on your prompt.
Flick right or left to navigate through the generated responses.
- Flick right or left to navigate through the generated response and double tap the screen to engage with the generated response.
To learn more of what Copilot can help with, type more questions in the text field, like "How can Copilot help?"
For more sample prompts, go to Copilot Prompts.
Navigate the prompt guide
The prompt guide in the Copilot pane provides access to a wide range of prompts for various contexts and purposes. To navigate the prompt guide, follow these steps:
Open the Copilot pane, then flick right until you hear "Open View Prompts button,” and double-tap to open the context menu.
Flick right or left to navigate through the categories of prompts; once selected, double-tap the screen. Focus will shift to the prompts list within that category.
Flick right to review the available prompts, and double-tap to select. With some prompts, you will be automatically directed to the prompt edit to make customizations before Copilot can generate information.
Note
If you want to stop the generation process, flick right to select Stop generating button and double-tap the screen.
Once customized, flick right until you hear “Send button,” then double-tap the screen.
Tip
Select View more prompts to explore a broader range of prompts in the Copilot Prompt Gallery. For more information on navigating the Copilot Prompt Gallery, go to Use Copilot Lab with a screen reader.
Enhance your experience with dynamic prompts
The new dynamic bubbles in the Getting Started experience within the Copilot chat pane offer an interactive and engaging way to guide users through their journey. These bubbles dynamically adapt based on the context, providing helpful tips, suggestions, and quick actions to enhance the user experience. This feature makes it easier for users to explore and get familiar with Copilot's capabilities, ensuring a smoother onboarding process.
See also
Identify insights with Copilot in Excel
Highlight, sort, and filter your data with Copilot in Excel
Microsoft 365 Copilot help & learning
Get started with Copilot in Excel
Technical support for customers with disabilities
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
Copilot in Excel helps you to manage your data by suggesting formulas for complex calculations, allowing you to edit data within columns, and providing insights into your data. It is designed to enhance productivity and simplify complex tasks. For more great ideas on using Copilot in Excel, go to the Excel Blog.
Note
- To learn more about screen readers, go to How screen readers work with Microsoft 365.
- When you use Excel for the web with a screen reader, switch to the full screen mode. Press F11 to toggle the full screen on and off.
In this topic
Navigate Copilot in Excel
Generate formulas using Copilot
Understand and explain data
Apply color and formatting
Ask copilot
Navigate the prompt guide
Generate a prompt using voice commands
Enhance your experience with dynamic prompts
Navigate Copilot in Excel
Copilot in Excel is an advanced feature designed to streamline data management and boost your productivity. Follow these instructions to automate tasks, analyze data, and generate insights more efficiently using Copilot in Excel.
Open Microsoft Excel on your web browser.
Use the Tab key to navigate to the desired workbook and press Enter to open it.
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Type your prompt in the prompt edit box and then use the Tab key to select the Send button. The Copilot will start generating the response according to your prompt.
Here are some sample prompts to get you started:
"Suggest a formula to calculate the average sales per region."
"Bold the top 3 values in Annual Sales."
"Filter the data to display only products with a rating above 5 stars."
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Once the response is generated, press Tab or Shift+Tab to move the focus to the generated content, and press Enter to navigate into the generated response.
Press Esc to navigate out of the generated response and back to the list.
Copilot streamlines the creation of complex formulas with step-by-step guidance. Users can quickly construct accurate calculations, reducing the need for manual input and minimizing errors.
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Use the Tab key to select Create formulas, and then press Enter. Copilot will start generating a formula based on the data in your current document. You can describe which columns or rows to address by typing in the prompt edit.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Select the generated response, then press Enter to interact with it.
Use the Tab key to select the Insert column button, and press Enter to apply the formula. Or do one of the following:
- To refresh the existing prompts in the suggested prompts group, select the Refresh button.
- For a new column suggestion, select the Give me another column suggestion button.
Understand and explain data
Copilot provides detailed summaries of key insights, explains trends, and identifies outliers in your data, helping users analyze patterns and draw meaningful conclusions from it.
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Navigate using Tab and select Create formulas; then use the Down arrow key to select Understand and press Enter. Copilot will start summarizing the data using pivot tables or charts.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Navigate using Tab and select the generated response.
- Press Tab or Shift+Tab to move the focus to the generated content, and press Enter to navigate into the generated response.
- Press Esc to navigate out of the generated response and back to the list.
To explore additional prompts in the chat pane, press Tab to select a prompt, then press Enter. Copilot will generate a response based on the prompt chosen.
Copilot can customize your data presentation by color-coding cells, adding borders, changing fonts, and assisting you in highlighting, filtering, and sorting information effectively.
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Navigate using Tab and select Create formulas; then use the Down arrow key to select Apply color and formatting and press Enter. Copilot will insert the beginning of the prompt "Highlight all cells with" in the prompt edit box.
Customize the prompt and press Tab to select Send, then press Enter. Copilot will generate a response based on your prompt.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Navigate using Tab and select the generated response.
- press Enter to navigate into the generated response.
- Press Esc to navigate out of the generated response and back to the list.
To apply the changes to the workbook, press the Tab key to select the Apply button, then press Enter.
Ask Copilot
Ask Copilot allows users to effortlessly interact with their data within Excel. This feature helps users to work with the data without needing to have advanced formulas or Excel knowledge, as Copilot handles complex tasks and provides direct guidance.
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Navigate using Tab and select Create formulas; then use the Down arrow key to select Ask Copilot and press Enter. The Copilot prompt edit box will display the text, “How do I sum values based on” that you can customize or type a new question.
Navigate using the Tab key and select the Send button. Copilot will generate a response based on your prompt
Navigate through the generated responses using Tab or Shift+Tab.
- Press Enter to engage with the generated response.
- Use the Tab key to navigate through the generated response, and press Esc to return to the chat messages list.
To learn more of what Copilot can help with, type more questions in the edit field, like "How can Copilot help?"
Navigate the prompt guide
The prompt guide in the Copilot chat pane provides access to a wide range of prompts for various contexts and purposes. To navigate the prompt guide, follow these steps:
Press Alt+Q to open the Search text field, and type “Chat with copilot” to open the Copilot chat pane.
Navigate using the Tab key until you hear "Open View Prompts button.” Then press Enter to open the context menu.
Use the Up or Down arrow key to navigate through the categories of prompts; once selected, press Enter. Focus will shift to the prompts list within that category.
Use the Up or Down arrow keys to review the available prompts, and press Enter to select it. With some prompts, you will be automatically directed to the prompt edit to make customizations before Copilot can generate information.
Note
If you want to stop the generation process, navigate, using Tab or Shift+Tab and select the Stop generating button.
Once customized, press the Tab key until you hear “Send button,” then press Enter.
Generate a prompt using voice commands
The voice command feature enables you to interact with the application hands-free. This feature makes workflows smoother and helps you navigate and enter data more easily.
- In the prompt edit, press Tab until you hear “Microphone paused switch,” then press Enter.
- Once the microphone is activated, the system will announce "microphone listening." Start entering commands using your voice, press Tab to select the Send button and press Enter. Copilot will generate a response based on your prompt.
- Navigate using Tab and select the generated response. Press Enter to engage with the generated response, and press Esc to navigate out of the message and back to the list.
Enhance your experience with dynamic prompts
The new dynamic bubbles in the Getting Started experience within the Copilot chat pane offer an interactive and engaging way to guide users through their journey. These bubbles dynamically adapt based on the context, providing helpful tips, suggestions, and quick actions to enhance the user experience. This feature makes it easier for users to explore and get familiar with Copilot's capabilities, ensuring a smoother onboarding process.
See also
Identify insights with Copilot in Excel
Highlight, sort, and filter your data with Copilot in Excel
Microsoft 365 Copilot help & learning
Get started with Copilot in Excel
Technical support for customers with disabilities
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
