Explain Formulas with Copilot—Now on the Grid
Understanding complex formulas in Excel just got a lot easier. The new Explain Formula feature turns Copilot into your inline assistant, delivering clear, step-by-step breakdowns directly on the grid, right next to your data, no need to switch context or open the chat pane. What makes this especially powerful is that the explanations are contextual, grounded in your actual data and workbook, not generic descriptions. By bringing the explanation to where you’re working, Copilot helps you stay in flow. It’s a seamless, in-the-moment experience that makes it easy to scan, understand, and act on formulas right where you need it most. How It Works Here’s how to get an explanation in just a few clicks: Select a cell with a valid formula A Copilot icon appears next to the cell Click “Explain this formula” from the dropdown Copilot shows a step-by-step explanation directly on the grid Need to dive deeper? Click “Chat with Copilot” to continue the conversation in the side pane Note: If the Copilot chat pane is already open, the explanation will be displayed there instead of on the grid. What It Does: Contextual Formula Explanations When you select a formula cell, Copilot can now explain what that formula does using a dedicated card shown in the grid. Helping you quickly understand what the formula does based on your actual data and context, not just a generic description. This makes it easy to: ✅ Understand the formula’s goal in your workbook ✅ Learn how it works, function by function ✅ Build confidence without ever leaving your sheet For example, given this formula: =I4 * XLOOKUP(H4, $L$4:$L$7, $M$4:$M$7) With just a click, Copilot will explain that: Because the explanation is tailored to your actual data and scenario, it’s faster to grasp, easier to verify, and more relevant to your work. Copilot provides the clarity you need right where you need it. Copilot Can Explain Any Excel formula No matter how simple or complex, Copilot can explain any Excel formula. Whether you're working with math, logic, references, arrays, or text manipulation, Copilot helps you understand what’s going on and why. Availability This feature is gradually rolling out to Excel for Windows and Excel for the web. Feedback We’d love to hear how this new experience is working for you. Let us know: ✔️ Was the explanation clear and easy to understand? ✔️ Was it easy to access the explanation when you needed it? ✔️ Did the overall experience feel intuitive and helpful? Just click the 👍 or 👎 at the bottom of the Copilot response to share your thoughts. Your feedback helps us refine the experience and prioritize what’s next.
Part 2: Vertical Sidebar for Personal Copilot Navigation
In Part 1, I proposed a simple model to unify Copilot: General tasks → Copilot Pages Specialized use → Toggle Save and recall → Loop This helped simplify the fragmented Copilot landscape. In Part 2, I focus on personal daily use. When working in Word, Excel, or Outlook, many users lose track of what they have opened and where to switch. My idea: add a static vertical sidebar in Copilot Pages that lists the files or apps you are working with: Self-organized list - Word docs, Excel sheets, Outlook mails and calendar items shown vertically in one place. No confusion - Instantly switch between targets without hunting around. Clear and simple - Prevents getting lost during solo work. The key is that Copilot Pages must remain visible as the entry point during daily work — a persistent sidebar that never disappears. And importantly, the number of items displayed can be set by the user. Hidden apps remain accessible by scrolling, keeping the UI clean and flexible. Benefits Daily work feels more organized and stress-free. Matches patterns users already know (Outlook folders, Teams channels). A realistic, easy-to-implement step toward better Copilot UX. In short: "Vertical Sidebar = No more confusion for individuals." If you agree, please give it a like. Stay tuned for Part 3! 第2弾：個人作業の迷子防止 ― 縦スクロールUIの提案 第1弾では、Copilot乱立を整理するシンプルなモデル（Pages／トグル／Loop）を提案しました。 多くの方から「すっきりした」と共感をいただきました。 今回の第2弾では、個人で作業するときのUX改善に注目します。 WordやExcel、Outlookを開いているとき、「どこで何を開いたのか」迷子になる経験はありませんか？ そこで、Copilot Pagesに静的な縦スクロール型サイドバーを導入するアイデアです: 自分専用の一覧 - Word文書やExcelシート、Outlookメールや予定を右サイドに縦並びで整理。 迷子防止 - 読みたい対象にすぐ切り替え可能。 シンプル設計 - 日常業務でのストレスを軽減。 さらに重要なのは、Copilot Pagesが常に入口として存在し続けることです。 仕事中に消えず、右サイドに固定されているからこそ「迷子ゼロ」の体験が実現します。 加えて、表示数はユーザーが任意に設定可能です。 隠れているアプリもスクロールで選べるので、UIは常にすっきり保てます。 効果 日常業務がスッキリし、シンプルに整理できる。 OutlookやTeamsと同じ縦並び習慣に合う直感的なUI。 現実的かつ早期に導入できる改善案。 一言で言えば: 「縦スクロールUI＝個人作業の迷子ゼロ」 共感いただける方はぜひ「いいね」をお願いします。 次回、第3弾にご期待ください！🚀 A Proposal to Eliminate Copilot Fragmentation and Unify the UX
🚀 A Proposal to Eliminate Copilot Fragmentation and Unify the UX Body (English first) Currently in Microsoft 365, there are multiple entry points for Copilot — Copilot Pages, app-specific Copilots, and Copilot in Loop. This fragmentation often confuses users about which Copilot to use and where the outputs are saved. I propose a simple unification: ol {margin-bottom:0in;margin-top:0in;}ul {margin-bottom:0in;margin-top:0in;}li {margin-top:.0in;margin-bottom:8pt;}ol.scriptor-listCounterResetlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a540 {counter-reset: section;}ol.scriptor-listCounterlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a540 {list-style-type:numbered;}li.listItemlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a540::before {counter-increment: section;content: counters(section, ".") ". "; display: inline-block;} General-purpose Copilot → Copilot Pages only Even when opening Word/Excel/Outlook/Loop via the sidebar, all interactions are handled by the Copilot in Copilot Pages. Specialized Copilot → Toggle switch Add a toggle at the top of Copilot Pages (“General ↔ Specialized”) to switch into app-specific Copilot functions only when needed. Save format → Standardize to Loop files All generated content is saved as .loop files in OneDrive/SharePoint and can be directly opened in the Loop app. Benefits ol {margin-bottom:0in;margin-top:0in;}ul {margin-bottom:0in;margin-top:0in;}li {margin-top:.0in;margin-bottom:8pt;}ol.scriptor-listCounterResetlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a541 {counter-reset: section;}ol.scriptor-listCounterlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a541 {list-style-type:bullet;}li.listItemlist!list-758aeff6-9418-422e-b90e-e34b3c8e9a541::before {counter-increment: section;content: none; display: inline-block;} Eliminates confusion caused by Copilot fragmentation → more intuitive UX. Users only decide “general or specialized” → very simple flow. Future apps can be added via the sidebar → high scalability. 👉 In short: “General = Pages, Specialized = Toggle, Save = Loop” This would greatly simplify and improve the Copilot experience. If you agree, please give it a like 👍 日本語版（for Japanese users） Copilot乱立を解消し、UXを一元化する提案 現在のMicrosoft 365では、Copilot Pages、各アプリ専用のCopilot、Loop＋Copilotなど複数の入口が存在し、ユーザーが「どのCopilotを使えばよいのか」で混乱しています。 以下のように統一することを提案します： 汎用CopilotはCopilot Pagesに一本化 特化型Copilotは切替トグルで呼び分け 保存形式はLoopファイルに統一 効果 乱立による混乱がなくなり、UXが直感的に。 導線が「汎用か特化か」の選択だけに。 将来アプリが増えてもサイドバーに追加するだけで拡張可能。 👉 一言で言えば： 「汎用＝Pages、特化＝トグル、保存＝Loop」 これでCopilot体験は大きく整理されます。 ご賛同いただける方はぜひ「いいね」をお願いします！ 👍🚀 A Proposal to Eliminate Copilot Fragmentation and Unify the UX Body (English first)
Currently in Microsoft 365, there are multiple entry points for Copilot — Copilot Pages, app-specific Copilots, and Copilot in Loop. This fragmentation often confuses users about which Copilot to use and where the outputs are saved. I propose a simple unification: １．General-purpose Copilot → Copilot Pages only Even when opening Word/Excel/Outlook/Loop via the sidebar, all interactions are handled by the Copilot in Copilot Pages. ２．Specialized Copilot → Toggle switch Add a toggle at the top of Copilot Pages ("General <-> Specialized") to switch into app-specific Copilot functions only when needed. ３．Save format → Standardize to Loop files All generated content is saved as .loop files in OneDrive/SharePoint and can be directly opened in the Loop app. Benefits Eliminates confusion caused by Copilot fragmentation → more intuitive UX. Users only decide "general or specialized" → very simple flow. Future apps can be added via the sidebar → high scalability. 👉 In short: “General = Pages, Specialized = Toggle, Save = Loop” This would greatly simplify and improve the Copilot experience. If you agree, please give it a like 👍 日本語版（for Japanese users） Copilot乱立を解消し、UXを一元化する提案 現在のMicrosoft 365では、Copilot Pages、各アプリ専用のCopilot、Loop＋Copilotなど複数の入口が存在し、ユーザーが「どのCopilotを使えばよいのか」で混乱しています。 以下のように統一することを提案します。 汎用CopilotはCopilot Pagesに一本化 特化型Copilotは切替トグルで呼び分け 保存形式はLoopファイルに統一 効果 乱立による混乱がなくなり、UXが直感的に。 導線が「汎用か特化か」の選択だけに。 将来アプリが増えてもサイドバーに追加するだけで拡張可能。 👉 一言で言えば： 「汎用＝Pages、特化＝トグル、保存＝Loop」 これでCopilot体験は大きく整理されます。 ご賛同いただける方はぜひ「いいね」をお願いします！ 👍
