Avoid and report Microsoft technical support scams
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
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
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
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
Fix network connection issues in Windows - Microsoft Support
Try these things to troubleshoot network connection issues in Windows 11. Make sure Wi-Fi is on. Select Start > Settings > Network & internet, then turn on Wi-Fi.Next, select More options (>) next to Wi-Fi, then select Show available networks.If a network you expect to see appears in the list, select it, then select Connect. Open Wi-Fi settings
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.
Applies To: Microsoft account dashboard
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
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 10, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Manage files and folders in OneDrive - Microsoft Support
Training: Get up and running quick. Note: If you already had an account signed in to OneDrive and you want to add another account, click the OneDrive cloud icon up in the Menu bar, click the three dots to open the menu, and select Preferences.Click the Account tab, select Add an Account to start OneDrive Setup, and then sign in.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Fix File Explorer if it won't open or start - Microsoft Support
Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.