Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
Hide or show rows or columns - Microsoft Support
Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns
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
Find out how much storage your PC has - Microsoft Support
Learn how to check your PC's storage capacity and manage it effectively with Microsoft Support's guidance.
Sync OneDrive files and folders - Microsoft Support
Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Customize the Quick Access Toolbar - Microsoft Support
Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:
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, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, 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, InfoPath 2013, SharePoint Workspace 2010
MATCH function - Microsoft Support
Syntax. MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required.The value that you want to match in lookup_array.For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.
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
Troubleshoot Outlook email setup - Microsoft Support
If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
更改屏幕亮度(Windows - Microsoft 支持
如果你没有台式电脑并且滑块未显示或不起作用,请尝试更新显示驱动程序。 在任务栏上选择"搜索",键入"设备管理器",然后从结果列表中选择"设备管理器"。在"设备管理器"中,选择"显示适配器",然后选择显示适配器。长按 (或右键) 显示适配器名称,然后选择"更新驱动程序"并按照说明操作。
デスクトップの背景と色を変更する - Microsoft サポート
[スタート] > [設定] > [個人用設定] を選択します 。 プレビュー ウィンドウに、実行した変更に関するプレビューが表示されます。 [ 背景のカスタマイズ] で、作成した画像の画像、単色、またはスライドショーを選択できます。 または、 Windows スポットライト を選択して、毎日世界中の新しい ...