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.
Notes:
To learn more about screen readers, go to How screen readers work with Microsoft 365.
As with any AI-generated content, it's important to review, edit, and verify anything Copilot creates for you.
In this topic
Generate formulas using Copilot
Generate formulas using Copilot
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.
Press Enter to engage with the generated response.
Press Tab to navigate through the generated response.
Note: a chart is generated, press Tab to navigate to the Insert Chart button, then press Enter to explore the chart.
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.
Apply color and formatting
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.
Notes:
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?" For more sample prompts, go to Copilot Prompts.
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
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.
Notes:
To learn more about screen readers, go to How screen readers work with Microsoft 365.
As with any AI-generated content, it's important to review, edit, and verify anything Copilot creates for you.
In this topic
Generate formulas using Copilot
Navigate the prompt guide
Generate formulas using Copilot
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 tostart 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
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.
Notes:
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?" For more sample prompts, go to Copilot Prompts.
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
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
Generate formulas using Copilot
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 tostart 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.
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 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.
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
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.
Notes:
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
Generate formulas using Copilot
Generate formulas using Copilot
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.
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.
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?" For more sample prompts, go to Copilot Prompts.
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
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.
