FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Change the power mode for your Windows PC - Microsoft Support
Note: You might not be able to change the power mode when a custom power plan is selected.If you can’t set the power mode in Power & battery settings, open Control Panel, select System and Security > Power Options, then choose a Balanced power plan.
Faster and more secure Wi-Fi in Windows - Microsoft Support
Tip: You can also check to see what your network adapter supports by opening the Command Prompt (or Terminal), and then typing the command netsh wlan show drivers.Look next to Radio types supported and see if it includes 802.11be (for Wi-Fi 7) or 802.11ax (for Wi-Fi 6/6e) and look under Authentication and cipher supported in infrastructure mode and see if it includes WPA3 Personal and WPA3 ...
I can't sign in to my Microsoft account - Microsoft Support
If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, GroupMe, Microsoft account dashboard, Microsoft Teams, Microsoft Teams personal, Microsoft To Do, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, Outlook for Android, Outlook for iOS
Manage notifications in Microsoft Teams - Microsoft Support
Missed activity emails. In the Missed activity emails section, you’re able to set the frequency of summary emails detailing your missed activity, or turn this feature off.. Chats and channels notifications. Notifications for chats and channels can be managed at a granular level, allowing you to customize your notifications to your personal work style.
Applies To: Microsoft Teams
About the Microsoft Support and Recovery Assistant
Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.
Applies To: Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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
Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Fixes or workarounds for recent issues in Outlook for PC
Then, create REG_SZ values in this key for each form you wish to allow scripts to run. In the above example, you would create a REG_SZ value named “IPM.Note.Custom” with empty data. When designing a form, Run This Form will run a form using the message class of the base form. So if you started designing an IPM.Note form and want to Run This Form, you will need to have IPM.Note registered.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
配置 Windows Hello - Microsoft 支持
Windows Hello 是登录到 Windows 设备的一种更个性化、更安全的方式。 在 Windows Hello 中,你可以使用面部识别、指纹或 PIN 登录,而不是使用密码。