All keyboard shortcuts for AI in spreadsheets
Shortcut keys for AI in spreadsheets
With keyboard shortcuts for Copilot in Excel and Gemini in Google Sheets, you can send commands, request formula help, and process AI results faster. This reference guide contains 100 numbered entries for Windows , and Mac, clearly distinguishing between AI controls and standard spreadsheet functions for verification and processing.
What keyboard shortcuts do you use for AI in spreadsheets?
The most important keyboard shortcuts for AI in spreadsheets help with three tasks: controlling the assistant, checking calculations, and processing results. These include sending a prompt, accepting suggested changes, adjusting a formula, or copying a calculated result as a constant value.
Copilot and Gemini each have their own set of controls. It also makes a difference whether the cursor is in the AI panel, the worksheet, or a formula. As a result, the same combination of keys can perform different offers.
This overview contains one hundred keyboard shortcut entries, not one hundred unique built-in AI commands. Windows and Mac versions are counted separately. Standard spreadsheet functions are listed separately: they help you with the data and results but do not issue commands to the AI themselves.
The Excel tables follow the desktop interface of Excel for Microsoft 365. The Google section applies to Google Sheets on a computer. Differences may occur in web versions, other update channels, and custom keyboard layouts.
| Main Topic | Related keywords | Application |
|---|---|---|
| Copilot in Excel | Copilot keyboard shortcuts, AI analysis, Excel assistant | Submit orders and review changes |
| Gemini in Google Sheets | Gemini shortcuts, AI formulas, summarize spreadsheet | Request help with formulas and explanations of data |
| Check Plans | Cell references, relative references, formula editing | Understanding what a proposed calculation does |
| Processing results | Pasting values, filling ranges, number formatting | Making AI outputs usable in the spreadsheet |
Here’s how to read the keys
- Ctrl: the Control key on Windows.
- Cmd: the Command key on a Mac, identified by ⌘.
- Control on Mac: a separate key, next to Command.
- Option: the Mac key with the ⌥ symbol, sometimes referred to as Alt.
- Return: the key that is usually called “Enter” on Windows .
- A plus sign: Hold down the listed keys simultaneously.
For Ctrl+Shift+M, hold down Ctrl and Shift while briefly pressing M. Some entries use only one key. The function of that key depends heavily on the active component.
Before performing any action, check what the focus is on. Sending a prompt, confirming a cell entry, and accepting AI changes are all different offers.
1–18. Using Copilot in Excel
These combinations are specific to Copilot. The features must be available in your Excel installation and for your account. In the case of a phased rollout, a command may behave differently or may not yet be available.
| No. | Windows | No. | Mac | Role at Copilot |
|---|---|---|---|---|
| 1 | Alt+C | 2 | Cmd+Control+I | Access Copilot or the task pane. |
| 3 | Enter | 4 | Return | Submits the prompt from the input field. |
| 5 | Esc | 6 | Esc | Stop or cancel the request. |
| 7 | Ctrl+Enter | 8 | Cmd+Return | Accepts proposed Copilot changes. |
| 9 | Ctrl+Shift+M | 10 | Cmd+Shift+M | Switch between edit, chat, and planning modes. |
| 11 | Alt+C | 12 | Option+C | Navigates between answers in the task pane. |
| 13 | Ctrl+J | 14 | Cmd+J | Confirms the use of selected files. |
| 15 | Alt+Shift+H | 16 | Option+Shift+H | Start dictating with Copilot. |
| 17 | F6 | 18 | Shift+F6 | Shifts the focus between the grid and Copilot. |
The newer Copilot interface uses a dynamic action button. Depending on the interface and whether the panel is already open, the launch shortcut key may first shift the focus. Pay attention to the on-screen prompt before continuing to type.
Place an order that you can track
Describe what data you want to use and what the result should look like. “Analyze my revenue” is too broad. A more specific question is: “Compare revenue by product group for January through March and show the difference between February and March.”
Add details on how exceptions should be handled. Should canceled orders be excluded from the calculation? Are returns included as negative amounts? Such agreements often have a greater impact than the chosen formula.
Review any proposed changes before accepting them. Check which cells are being modified and whether existing calculations will be preserved. A convincing explanation does not replace that verification.
19–30. Viewing and Applying Excel Formulas
Standard Excel functions: These keys do not trigger an AI command. You use them to review a suggested formula and apply it to the correct cells.
| No. | Windows | No. | Mac | Function in the worksheet |
|---|---|---|---|---|
| 19 | F2 | 20 | F2 | Edits the active cell. |
| 21 | F4 | 22 | Cmd+T | Changes the selected reference type during formula editing. |
| 23 | Ctrl+` | 24 | Control+` | Toggles between values and formula view. |
| 25 | Ctrl+D | 26 | Cmd+D | Copies the selected top cell down. |
| 27 | Ctrl+R | 28 | Cmd+R | Copies the selected cell on the left to the right. |
| 29 | Ctrl+X | 30 | Cmd+X | Cuts the selected cells. |
For F4 or Cmd+T, you must select the intended cell reference within the formula. Outside of that context, the key combination may have a different function. On a laptop, you may sometimes need to press the Fn key to use a function key.
Check fixed and floating references
Suppose column B contains amounts and cell F1 contains a single discount percentage. When copying a formula, the amount usually needs to change for each row, while the reference to the percentage remains fixed to the same cell.
A relative reference such as B2 moves along when you copy a range. An absolute reference such as $F$1 remains fixed. Therefore, check not only the first result but also a few results further down the list.
Filling in a range is efficient when the top or leftmost cell is correct. Otherwise, an error in that source cell will be copied just as efficiently. Test a small range first before filling an entire column.
31–50. Incorporating Copilot results into Excel
Basic Excel functions: These combinations support copying, restoring, and verifying data. They operate on the active selection in the worksheet.
| No. | Windows | No. | Mac | Feature |
|---|---|---|---|---|
| 31 | Ctrl+C | 32 | Cmd+C | Copies selected cells. |
| 33 | Ctrl+V | 34 | Cmd+V | Paste the clipboard contents. |
| 35 | Ctrl+Alt+V | 36 | Cmd+Control+V | Opens Paste Special. |
| 37 | Ctrl+Z | 38 | Cmd+Z | Undoes a recent action. |
| 39 | Ctrl+Y | 40 | Cmd+Y | Undoes a previously undone action, if possible. |
| 41 | Ctrl+Spatie | 42 | Control+Spatie | Selects the column. |
| 43 | Shift+Spatie | 44 | Shift+Spatie | Selects the row. |
| 45 | Ctrl+1 | 46 | Cmd+1 | Opens the cell formatting settings. |
| 47 | Ctrl+F | 48 | Cmd+F | Search the database. |
| 49 | Alt+= | 50 | Cmd+Shift+T | Insert AutoSom. |
A formula and a constant are different
A formula continues to respond to the data it references. A pasted value is a fixed result. Choose carefully what you want to keep.
If you’re working on a spreadsheet that will need to be recalculated later, the formula is usually part of your working file. If you also want to capture a snapshot, use a separate output with fixed values and a clear date.
A number format determines how a value is displayed. As a result, a percentage, an amount, and a regular number can look very different. Always check what the value actually means.
51–56. Using Gemini in Google Sheets
These keys are specifically for Gemini in Google Sheets. The feature must be available for your account. Use the combinations in the context described; the controls for the standalone Gemini app do not apply here.
| No. | Windows | No. | Mac | Role at Gemini |
|---|---|---|---|---|
| 51 | Ctrl+Alt+N | 52 | Cmd+Control+N | Requests a summary of the spreadsheet. |
| 53 | Ctrl+Alt+G | 54 | Cmd+Control+G | Opens the Gemini formula help after you enter an equals sign in a cell. |
| 55 | Enter | 56 | Return | Sends the prompt from the Gemini input field. |
To create a formula, start in an appropriate cell with = and then use the combination from number 53 or 54. Describe what input the formula uses and what result you expect.
A summary serves as a starting point for further questions. Ask for clarification if it remains unclear which period, column, or group is being referred to. Ultimately, you want to be able to pinpoint the source of a conclusion.
Give columns a clear purpose
Compare these two tasks: “Calculate the difference” and “For each row, calculate the difference between the budgeted amount in column C and the actual amount in column D. An overrun must be displayed as a positive value.”
The second instruction determines the direction of the calculation. Without that explanation, both C minus D and D minus C might seem defensible at first glance.
For larger files, it helps to also specify the relevant worksheet and column names. Use the same terms as in your data to minimize the chance of misunderstandings.
57–68. Copying and Restoring Gemini Outputs
Standard Google Sheets functions: the keys listed below operate on the selected cells. They do not execute a brand new Gemini command.
| No. | Windows | No. | Mac | Feature |
|---|---|---|---|---|
| 57 | Ctrl+C | 58 | Cmd+C | Copies the selection. |
| 59 | Ctrl+X | 60 | Cmd+X | Cuts the selection. |
| 61 | Ctrl+V | 62 | Cmd+V | Paste the clipboard contents. |
| 63 | Ctrl+Shift+V | 64 | Cmd+Shift+V | Pasts values only. |
| 65 | Ctrl+Z | 66 | Cmd+Z | Undoes a recent action. |
| 67 | Ctrl+Shift+Z | 68 | Cmd+Shift+Z | Undoes a previous action. |
Pasting values removes the dependency on the genuine formula when copying. The result will no longer update when the source data changes.
Therefore, check in advance whether you want to copy a working calculation or just the result. If in doubt, keep the formula in your worksheet and enter the fixed output elsewhere.
69–82. Selecting, Entering, and Retrieving Data
Common Google Sheets functions: use these combinations when preparing data and processing verified results.
| No. | Windows | No. | Mac | Feature |
|---|---|---|---|---|
| 69 | Ctrl+Spatie | 70 | Control+Spatie | Selects the column. |
| 71 | Shift+Spatie | 72 | Shift+Spatie | Selects the row. |
| 73 | Ctrl+D | 74 | Cmd+D | Fill in the selected range below. |
| 75 | Ctrl+R | 76 | Cmd+R | Fills the selected range to the right. |
| 77 | Ctrl+Enter | 78 | Cmd+Return | Fill in the selection with your entry. |
| 79 | Ctrl+F | 80 | Cmd+F | Searching for content. |
| 81 | Ctrl+H | 82 | Cmd+Shift+H | Opens Search and Replace. |
Note the difference with Copilot: in a spreadsheet selection, Ctrl+Enter can fill a range, while in the Copilot context, that combination accepts changes.
Always check your selection before filling it in. A range that is one column too wide may overwrite existing data. When using Find and Replace, it’s a good idea to review a few matches individually first.
Also, don’t just replace commas, periods, or abbreviations throughout the entire file. The same character can have a different function in an amount, product code, or description.
83–100. Checking Numbers and Formulas in Google Sheets
Common Google Sheets functions: these keys help with formatting, formula checking, and documenting results.
| No. | Windows | No. | Mac | Feature |
|---|---|---|---|---|
| 83 | Ctrl+Shift+1 | 84 | Control+Shift+1 | Uses decimal notation. |
| 85 | Ctrl+Shift+4 | 86 | Control+Shift+4 | Applies currency notation. |
| 87 | Ctrl+Shift+5 | 88 | Control+Shift+5 | Applies percentage notation. |
| 89 | Ctrl+Shift+3 | 90 | Control+Shift+3 | Applies date format. |
| 91 | F4 | 92 | Fn+F4 | Changes reference types during formula entry. |
| 93 | F9 | 94 | Fn+F9 | Toggles the result preview during formula entry. |
| 95 | Ctrl+Alt+M | 96 | Cmd+Option+M | Add or edit a comment. |
| 97 | Ctrl+Alt+T | 98 | Cmd+Option+T | Convert a range into a table. |
| 99 | Ctrl+/ | 100 | Cmd+/ | Displays the list of keyboard shortcuts. |
In the Mac column, the key labels intentionally use “Control.” This is not “Command” here. For function keys, “Fn” may depend on your keyboard settings.
A different notation does not automatically change the meaning
Suppose a cell contains the value 0.15. As a percentage, this is displayed as 15%. If the value is 15, the same percentage notation results in 1,500%.
That’s a good reason to first check the underlying value when you encounter unexpected results. Simply changing the formatting won’t fix an incorrect entry.
A comment can document an explanation that would otherwise only appear in your AI conversation. For example, note which rows are excluded or why a fixed reference is used. This ensures the calculation remains understandable later on.
Here’s how to go from an AI task to a verified result
Step 1: Clarify what each row means
First, determine what your data represents. Does a row represent one order, one product line, or one customer? This distinction is important when calculating quantities.
A customer with three orders can appear three times in a file. If you ask for “the number of customers,” it must be clear whether you mean unique customers or all records.
Use clear column names and explain any abbreviations in your order. Also specify the relevant time period and which parts of the file are relevant.
Step 2: Request a detailed quote
Work with one verifiable question at a time. For example, first ask for the monthly total. Only then should you examine the differences between months or product groups.
When stating percentages, specify what the base is. “The return rate” could refer to the number of orders, the number of items, or amounts. These are different calculations.
Clear instructions make it easier to verify afterward whether the correct result was delivered.
Step 3: Check a few examples yourself
Select a regular row, a row with a blank value, and a relevant exception. Compare the result with what you would expect based on the data.
Check the “Totals” section to ensure the entire intended range is included. Also pay attention to any subtotals: if you add them together with the line items, you’ll be counting the same items twice.
When using a copied formula, you should also check the references in a few cells further down. This way, you can see if the pattern has been applied correctly.
Step 4: Process and document the results
Give the result a clear name and include the unit. “Difference in euros” is more informative than just “Difference.” If using a percentage, specify the base used if necessary.
Keep a record of the calculation method in case someone needs to verify the result later. A table showing only the final numbers doesn’t reveal the choices that led to them.
Conclude with a brief review of the presentation. Are amounts, dates, and percentages clearly displayed? Can a colleague understand the overview without reading your AI conversation?
Why does a keyboard shortcut sometimes not work?
The issue often lies with the focus, keyboard layout, or available version. Check the points below before trying a combination again.
- Active element: Is the cursor in a cell, formula, or AI input field?
- Available feature: Is Copilot or Gemini visible and accessible?
- Platform: Do you use Windows, macos, or a web version?
- Keyboard: Does a function key act as an F-key or as a device control?
- Assignment: Does a platform function or extension take over the combination?
Combinations of numbers and punctuation marks may differ on AZERTY keyboards compared to QWERTY layouts. In that case, check the shortcut key list or your application’s menu.
Frequently Asked Questions About AI Shortcuts for Spreadsheets
Are these a hundred different AI features?
No. The list contains 100 entries, including Windows and Mac versions. The AI functionality is separate from the standard spreadsheet functions you use to process data and results.
Which keyboard shortcut opens Copilot in Excel?
To access the documentation, use Alt+C on Windows and Cmd+Control+I on a Mac. The exact focus depends on the interface and whether the panel is already open.
How do you ask Gemini for help with a formula?
Start in a suitable cell with an equals sign. Then use Ctrl+Alt+G on a Windows , or Cmd+Control+G on a Mac, and describe the calculation you want to perform.
Can you copy an AI formula directly across an entire column?
That may be technically possible, but first check a few results and the cell references. Otherwise, an error in the formula will be propagated across the entire range.
What’s the difference between “Paste” and “Paste Values”?
Simply pasting can include formulas, among other things. Pasting values only copies the results. Those results do not change afterward if the genuine input changes.
Which keys should you learn first?
Start by opening AI, sending a prompt, canceling, and reviewing results. Then add cell editing, copying, undoing, and redoing. That alone covers many everyday tasks.
Key Insights
- Distinguish between AI commands and spreadsheet commands: not every combination results in an AI command.
- Check the active context: the same keys can send a prompt, fill cells, or accept changes.
- Describe the data accurately: specify columns, time period, exceptions, and the basis for percentages.
- Test formulas before applying them: check the results and verify absolute or relative references.
- Document the calculation method: a useful result must also be understandable later on.