Copilot Tips for Excel: 12 Habits That Make It Guess Less (Not One Is a Prompt)

1Pick the mode on purpose

If you don't choose, you've chosen edit (it's the default, so Excel picked for you). Use Allow editing when the task is small, well understood and easy to undo.

2Plan before it edits

For bigger jobs like reshaping data, merging sheets or building a report, switch to Plan. Copilot writes the plan, you read it, you confirm. A plan you can read beats a result you have to untangle.

3Go chat only on files you didn't build

Chat only mode never changes the workbook. Use it on a colleague's file, or any file that matters. I wrote up 7 questions to ask in chat mode. On mobile you may not have a choice: Microsoft lists only chat mode for Android, and says edit mode is still rolling out on iPhone and iPad.

4Learn F6

F6 takes the keyboard to the Copilot button on every platform. Alt+C on Windows and Cmd+Control+I on Mac do the same, but Microsoft says they're still rolling out across apps and languages. So if one does nothing, fall back to F6. With the pane already open, Alt+C jumps to the message box.

5Move the button

Since spring 2026 it lives in the lower-right corner (not the first place you'd look). Right-click it and choose Move to ribbon (Windows build 16.0.20129.15140 or later, Mac build 16.109.525.2 or later), or Dock to park it beside your content. Move to ribbon is remembered per app on Windows and Mac and lasts for the session on the web. Docking lasts for the working session.

6Save in a format it supports

Microsoft's tutorial names .xlsx, .xlsb and .xlsm as the modern formats Copilot works with. Strict Open XML Spreadsheet gives you "Unsupported file state", and so does a file checked out in SharePoint. Fix it with Save As, Excel Workbook (.xlsx), or check the file back in. Can't? Open it in Excel for the web, which still works on sites that require check-out.

7Leave Calculation on Automatic

Microsoft says Copilot editing is only supported when Calculation Options are set to Automatic. Formulas tab, Calculation Options, Automatic. On an inherited file, check this first, because someone may have set it to Manual years ago and never told you.

8Name the columns, tidy the shape

Microsoft's advice is blunt: name the columns or ranges you want Copilot to work on, especially for formatting and analysis. Its tutorial adds the shape that works best: one header row, one kind of thing per column, no merged cells scattered around (yes, that includes the merged title row). An Excel Table is not a requirement, whatever older guides say.

9Start broad, then refine

If the first result is close, add detail and ask again, or ask a follow-up that builds on it. Microsoft's own tips say the same. Don't start from zero every time, and don't rewrite the whole request.

10Turn repeat jobs into rules and skills

Doing the same job again and again? You can write guidelines for a workbook as rules (the rules worksheet has to be visible, because Copilot ignores a hidden .Rules sheet). Microsoft's tips page also says you can record a skill by demonstrating a task in your workbook.

Here Microsoft's own pages disagree. Its October 2026 post lists the recorder as generally available on the web and in Insiders on Windows and Mac, while its support page says it is still rolling out. So you may not see it yet.

11Choose the model on purpose, or leave it on Auto

Microsoft's tips page puts the model picker in the upper-left corner of the pane (older guides say upper-right). Auto is the default, and your choice applies only to the active session. Switching needs a commercial Copilot licence or Microsoft 365 Premium. At work, your admin must also allow "AI providers for other large language models" before models from other providers appear.

12Verify every edit

Excel highlights the cells Copilot changed and puts a green dot on the tab of each modified sheet. Copilot can also list every cell, range and sheet it modified, and what it changed in each one, if you ask.