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
Change or reset Internet Explorer settings - Microsoft Support
Change Internet Explorer settings. There are many changes you can make to customize your browsing experience in Internet Explorer. To view all settings and options, open Internet Explorer on the desktop, select Tools > Internet options.. Reset Internet Explorer settings
Set up text messaging as your verification method
Change your default security info method. If you want text messaging to be the default method used when you sign in to your work or school account using two-factor verification or for password reset requests, you can set it from the Security info page.
将 Gmail 帐户添加到 Outlook for Windows - Microsoft 支持
如果需要使用高级设置添加电子邮件帐户的说明，请转到使用高级设置在 Outlook for PC 中添加 POP 或 IMAP 电子邮件帐户。. Outlook 不接受我的密码. 如果 Outlook 不接受您的密码，并且您知道您为 Gmail 帐户使用了正确的密码，则可能是 Outlook 的较旧版本当前不支持此更快的 Gmail 设置选项。
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
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
Use live captions in Microsoft Teams meetings
Learn how to enable live captions in Teams meetings and see real-time subtitles for what's said. Improve your accessibility and comprehension.
Applies To:
Microsoft Teams
Fix problems signing in to the Xbox app - Microsoft Support
If none of those options work, select the Start button > Settings > Accounts , then find the Microsoft account you used to sign in to the Xbox app and select Remove.Then go back to the Xbox app and sign in with the Microsoft account you just removed. Open Settings
Record your presentation - Microsoft Support
New features added for recording video. The new Record window has two screens: Record and Export.. When you select Record, the Record screen opens by default.. If you select Export in the top right of the Record screen, the Export screen opens.. You can switch between the Record and Export screens using the Record and Export buttons in the top bar of the window.
Applies To:
PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Automatically diagnose and fix problems with Windows Firewall
In the File Download dialog box, click Run or Open, and then follow the steps in the Windows Firewall Troubleshooter.
修复 Windows 中的蓝牙问题 - Microsoft 支持
如果上述步骤都不能修复你的蓝牙问题，请使用 Windows 反馈中心报告错误。 这可帮助 Microsoft 确定此问题的根本原因。