Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Create a group in Outlook - Microsoft Support
Create a group for your project or team. Create a PLC group in Outlook (Office 365 Education) A Professional Learning Community (PLC) group is a type of Microsoft 365 Group that provides a shared space for educators to use for collaboration.
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, New Outlook for Windows, Outlook for Android, Outlook for iOS
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
使用 vlookup、hlookup 和其他函数(如 index 和 match)根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup,然后链接到更多内容。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.
Applies To: Microsoft account dashboard
关闭电脑,或使其进入睡眠或休眠状态 - Microsoft 支持
注意: 如果连接到电脑的设备(例如显示器、打印机或扫描仪)在从睡眠状态或休眠状态唤醒后不能正确工作,你可能需要先断开设备连接并重新连接或重新启动电脑。还应确保你具有适用于所有设备的最新驱动程序。
ファイルを圧縮および展開する - Microsoft サポート
JPEG 画像のような特定の種類のファイルは、既に高度に圧縮されています。 複数の JPEG 画像を 1 つのフォルダーに zip 圧縮しても、フォルダーの合計サイズは元の画像をまとめたサイズとほぼ同じです。
Sign in - Microsoft Support
Training: Sign in to office.com with your Microsoft personal, work, or school account. Watch this video to learn how.
Applies To: Office 2021, Office 2019, Office 2016
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
Get help with Windows upgrade and installation errors
To upgrade to Windows 11, you need enough space on your hard drive for the installation to take place. To view how much hard drive space is available on your computer, select File Explorer on the taskbar (known as Windows Explorer in Windows 7) or press Windows logo key + E. Then select Computer or This PC and look under Hard Disk Drives or under Devices and drives.
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.