XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
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.
Virus & threat protection in Windows Security - Microsoft Support
Manage your Virus & threat protection settings. Use Virus & threat protection settings when you want to customize your level of protection, send sample files to Microsoft, exclude trusted files and folders from repeated scanning, or temporarily turn off your protection.. Manage your real-time protection. Want to stop running real-time protection for a short while?
Applies To: Microsoft account dashboard
Create a folder or subfolder in Outlook - Microsoft Support
To add a folder to the folder pane, do the following: In the left pane of Mail, Contacts, Tasks, or Calendar, right-click where you want to add the folder, and then click New Folder.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Tips to free up drive space on your PC - Microsoft Support
Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
安装 Windows 11 的方法 - Microsoft 支持
重要: 在选择从媒体启动之前,应验证设备是否满足最低系统要求,因为满足后才允许安装 Windows 11,如果你至少具有 TPM 1.2(而不是最低系统要求的 TPM 2.0),它将不会根据处理器的系列和模型验证处理器是否在批准的 CPU 列表上。
Download and install Microsoft 365 Access Runtime
The Access 365 Runtime is like previous runtimes in that all design-related UI is either removed or disabled. The Access 365 Runtime includes the Access Database Engine which contains a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb ...
Applies To: Access for Microsoft 365, Access 2021, Office 2021, Access 2019, Office 2019
Collaborate on Excel workbooks at the same time with co-authoring ...
If you selected the Share button, people will receive an email message inviting them to open the file. They can select the link to open the workbook. A web browser will open, and the workbook will open in Excel for the web. If they want to use the Excel desktop app to co-author, they can select Edit in Desktop App.However, they'll need a version of the Excel app that supports co-authoring.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile
OneDrive help & learning
Explore OneDrive support, help, and learning resources. Learn how to protect your important files, documents, and memories with OneDrive.