Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Tastenkombinationen in Windows - Microsoft-Support
Erfahren Sie, wie Sie Windows mithilfe von Tastenkombinationen navigieren. Hier finden Sie eine vollständige Liste der Taskleisten-, Eingabeaufforderungs- und allgemeinen Windows-Tastenkombinationen.
行から列、または列から行にデータを入れ替える (配置の転換)
注: データが Excel テーブル内にある場合、トランスポーズ機能は使用できません。テーブルを先に範囲に変換するか、TRANSPOSE 関数を使えば行と列の配置を変換できます。
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
对 Office 使用产品密钥 - Microsoft 支持
如果通过 Microsoft 工作区折扣计划 购买了 Microsoft 365. 如果通过雇主的 工作区折扣计划(以前称为家用许可计划) 权益安装 Office 专业增强版、Visio Professional 或 Project Professional，请在安装产品后输入产品密钥。
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Microsoft 365 for home, InfoPath 2013
What version of Outlook do I have? - Microsoft Support
Learn what version of Outlook you're using, and get link for setup, how to import and export email, contacts, and calendar.
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook Web App
在 PowerPoint 中更改默认字体 - Microsoft 支持
可以更改整个演示文稿的默认字体，而不是逐个更改幻灯片中的字体。 字体配对 (标题字体、正文字体) 是 PowerPoint 中的重要设计决策。
Applies To:
PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
SORT function - Microsoft Support
Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Microsoft Family help
Find guidance for all things family at Microsoft. Learn about Family Safety, find resources to support your child at school, and get the latest on keeping your information and devices secure.
July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Windows 11, version 22H2; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
计算两个日期之间的差值 - Microsoft 支持
如何使用 Excel 中的 DATEIF 函数计算两个日期之间的天数、月数或年数。
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016