Pinterest Pixel

Copilot in Excel Keyboard Shortcuts: Top 7 Useful Shortcuts

John Michaloudis
Copilot can help you analyse data, write formulas, highlight data, and spot trends in Excel.
Using keyboard shortcuts in Copilot can make your work faster.

Instead of using Copilot with the mouse, you can use keyboard shortcuts to enter prompts, switch modes, review responses, accept changes, etc.

In this article, you will learn how to use Copilot in Excel Keyboard Shortcuts.

Copilot can help you analyse data, write formulas, highlight data, and spot trends in Excel. Using keyboard shortcuts in Copilot can make your work faster. Instead of using Copilot with the mouse, you can use keyboard shortcuts to enter prompts, switch modes, review responses, accept changes, etc. In this article, you will learn how to use Copilot in Excel Keyboard Shortcuts.

Key Takeaways:

  • Copilot helps you analyse data and write formulas in Excel.
  • You can use Alt + C to open Copilot on Windows.
  • Press Enter to send a prompt to Copilot.
  • Use Ctrl + Shift + M to switch between Copilot modes.
  • Keyboard shortcuts help you work faster in Excel.

 

What is Copilot in Excel?

Copilot in Excel is built into Excel to help you work with your workbook using natural-language prompts. You can ask Copilot to generate formulas, update worksheets, create charts and PivotTables, summarize data, and spot trends or outliers.

For example, you could ask:

“Analyze this sales data and show the main trends.”

Copilot in Excel Keyboard Shortcuts

Keyboard shortcuts make it easier to move through these features without constantly reaching for the mouse.

 

Copilot in Excel Keyboard Shortcuts for Windows

1. Open Copilot in Excel

You can select the data and press Alt + C to open Copilot instead of searching for the Copilot button.

Copilot in Excel Keyboard Shortcuts

It allows you to quickly open Copilot with options for analyzing data, improving formatting, or adding formulas.

2. Send a Prompt in Copilot

You can use the Enter key to send a prompt to Copilot in Excel on Windows.

  • Open the Copilot pane.
  • Enter your prompt in the text box.
  • Press Enter to submit the request.

Copilot in Excel Keyboard Shortcuts

3. Stop a Copilot Request

You can press Esc to cancel a Copilot request that is no longer needed.

Copilot in Excel Keyboard Shortcuts

4. Accept Changes Made by Copilot

When Copilot provides suggestions, you can press Ctrl + Enter to directly make the changes in the spreadsheet.

Copilot in Excel Keyboard Shortcuts

This shortcut is useful when you have reviewed the suggested changes and want to proceed.

5. Switch Between Copilot Modes

There are three modes in Excel:

  • Edit Mode: Make changes to your workbook.
  • Chat Mode: Ask questions about your data.
  • Plan Mode: Plan complex Excel tasks.

You can use the Ctrl + Shift + M keyboard shortcut to quickly switch between these three modes in Copilot.

6. Switch Between Excel and Copilot

If you need to switch between Excel and Copilot continuously, using a mouse can be time-consuming. You can press F6 to move focus between the Excel grid and Copilot task pane.

7. Start Dictation

If you prefer speaking the prompt instead of typing it in the Copilot pane, you can use:

Alt + Shift + H

Copilot in Excel Keyboard Shortcuts

This will start dictation in the Copilot pane.

 

Copilot in Excel Keyboard Shortcuts for Mac

If you use Excel on a Mac, you can use the following keyboard shortcuts to interact with Copilot.

Action Keyboard Shortcut
Open the Copilot task pane Cmd + Ctrl + I
Send a prompt to Copilot Return
Stop or cancel a Copilot request Esc
Accept changes made by Copilot Cmd + Return
Switch between Edit, Chat, and Plan modes Cmd + Shift + M
Navigate between chat responses Option + C
Confirm the use of selected files Cmd + J
Start dictation in Copilot Option + Shift + H
Move focus between Excel and Copilot Shift + F6

 

FAQs

1. What is the shortcut to open Copilot in Excel?

Press Alt + C on Windows to open Copilot.

2. How do I send a prompt to Copilot?

Enter your prompt and press Enter to submit it.

3. How do I stop a Copilot request?

Press Esc to cancel a Copilot request.

4. How do I switch between Copilot modes?

Press Ctrl + Shift + M to switch between Edit, Chat, and Plan modes.

5. Can I use Copilot keyboard shortcuts on Mac?

Yes. Excel on Mac supports shortcuts such as Cmd + Ctrl + I to open Copilot and Cmd + Return to accept changes.

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Is Copilot in Excel Worth It? Pros, Cons, and Key Benefits

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...