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
Fix problems signing in to the Xbox app - Microsoft Support
On your PC, go to Xbox.com and select Sign in.If there are problems with your account, the instructions will help you solve them. If you can’t go beyond the sign-in screen, select Forgot my password and follow the instructions.
更改修订颜色 - Microsoft 支持
这些颜色设置仅适用于你的计算机。 其他人将看到修订以其所设置的任何颜色显示。 “按作者”的颜色在不同计算机上也会有所不同。 高级修订选项. 插入内容 设置在文档中插入文本时的格式（默认值为“下划线”）和颜色（默认值为“按作者”）。可将颜色更改为固定值，或不在“颜色”字段中 ...
Applies To:
Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Manually add an account to the Microsoft Authenticator app
Add your work or school account. On your computer, note the Code and Url information on the Configure mobile app page.Keep this page open so you can see the code and URL.
Datenträgerbereinigung in Windows - Microsoft-Support
Hinweis: Wenn Sie feststellen, dass der Ordner Temp nach dem Ausführen der Datenträgerbereinigung schnell gefüllt wird, finden Sie Informationen dazu unter Geringer Speicherplatzfehler aufgrund eines vollständigen Temp-Ordners. Weitere Informationen zum Freispeichern von Speicherplatz auf Ihrem PC finden Sie unter Speicherplatz im Windows.
Auto color management in Windows 11 - Microsoft Support
Creative professionals and enthusiasts care about fully calibrated, accurate colors because it helps to make sure colors remain consistent from the beginning to the end of their projects.
April 23, 2024—KB5036980 (OS Builds 22621.3527 and 22631.3527) Preview
Windows 11, version 23H2 ; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Use slicers to filter data - Microsoft Support
Use slicers to quickly filter data in Excel. 1. A slicer header indicates the category of the items in the slicer. 2. A filtering button that is not selected indicates that the item is not included in the filter.
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
Account & profile | Xbox Support
Find everything you need to manage your Xbox account, profile, and more.
Create a standard, private, or shared channel in Microsoft Teams
Add members to a shared channel. When creating a shared channel, the default setting is Share this channel with everyone on the team.. After you've chosen Shared channel as the channel type in the selection box, type the names of the people in your org you want to add to the channel and select from the list.
Applies To:
Microsoft Teams