Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Manage your Microsoft 365 subscription or Office product
The information below doesn't apply to these Office versions or Microsoft 365 subscriptions. Microsoft personal account Work or school account On the Microsoft account dashboard, select Services & subscriptions to view all Microsoft products associated with this account.
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 for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
在蓝牙打开或关闭Windows - Microsoft 支持
下面介绍如何在 Windows 10 中打开或关闭蓝牙: 选择“开始”按钮 ,然后依次选择“设置” >“设备”>“蓝牙和其他设备”。
Troubleshooting black or blank screens in Windows
For a black screen, use the following keyboard shortcut: Windows logo key + Ctrl + Shift + B.
Windows activity history and your privacy - Microsoft Support
Note: If you have previous activity history stored in the cloud before Windows 11 23H2 and 22H2, January 23, 2024-KB5034204 update, you can use the Clear activity history button to delete previously stored data in the cloud. Otherwise, your activity history will be automatically deleted within 30 days from when your data was last synced to the cloud
Applies To: Microsoft account dashboard
Wiederherstellen verlorener oder gelöschter Dateien
Wenn Sie eine Datei nicht finden können oder eine Datei versehentlich geändert oder gelöscht haben, können Sie sie aus einer Sicherung (falls Sie Windows-Sicherung verwenden) oder aus einer Vorgängerversion wiederherstellen. Vorgängerversionen sind Kopien von Dateien und Ordnern, die Windows automatisch im Rahmen eines Wiederherstellungspunkts speichert.
Internet Explorer Downloads - Microsoft Support
Microsoft Edge is the recommended browser by Microsoft. Support for Internet Explorer ended on June 15, 2022. Internet Explorer 11 has been permanently disabled through a Microsoft Edge update on certain versions of Windows 10.
Change mouse settings - Microsoft Support
To speed up the process of selecting a choice when a dialog box appears, under Snap To, select the Automatically move pointer to the default button in a dialog box check box.(Not all programs support this setting. In some programs, you'll need to move the mouse pointer to the button you want to click.)
Create a document in Word - Microsoft Support
Learn how to format text, add graphics, and more in Word documents. Create professional-looking documents with ease using our step-by-step guide. Try it now!
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016