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 Microsoft Photos app - Microsoft Support
Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.
Erneutes Installieren von Windows - Microsoft-Support
Hinweise: Wenn Sie Windows 11 mithilfe eines Installationsmediums neu installieren, während Sie "Nichts beibehalten" (Neuinstallation) auswählen, wird automatisch reservierter Speicher aktiviert, wenn die Partition, auf der Sie Windows neu installieren, 20 GB oder größer ist. Die Option „Reservierter Speicher” reserviert Speicherplatz für Updates, Apps, temporäre Dateien und ...
Help in Disk Management - Microsoft Support
Disk Management in Windows helps you perform advanced storage tasks like initializing a new drive and extending or shrinking volumes.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Show, hide, or resize desktop icons - Microsoft Support
Here's how to show icons, hide them, or change their size in Windows. To show or hide desktop icons. Right-click (or press and hold) the desktop, point to View, and then select Show desktop icons to add or clear the check mark.
Account help
Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.
修复 Windows 中的 USB-C 问题 - Microsoft 支持
注意: 带 USB Type-C 连接器的电脑具有更高的功率限制。 如果连接器支持 USB 电力传输,则其能够以更大的功率实现更快速充电。. 要更快地充电,你的电脑、充电器和线缆均必须符合行业标准。
Install, manage, or uninstall apps in Microsoft Edge
Alternatively, you can install any website by going to the top corner of the browser and select Settings and more … > Apps > Install this site as an app.
Applies To: Microsoft Edge
Repair apps and programs in Windows - Microsoft Support
Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.