Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
How to go passwordless with your Microsoft account
Simple, fast, secure. If my account doesn’t have a password, how will I sign in? Once you remove your password from your account, you will need to sign in using a passwordless method like the Microsoft Authenticator app, Outlook for Android, Windows Hello, physical security keys, or SMS codes.
Applies To: Microsoft account dashboard
Troubleshoot problems with Microsoft Authenticator
You can resolve problems with Microsoft Authenticator by checking the tips in this article and reviewing some of the known errors. Tips: If you're using mobile data, try switching to Wi-Fi and vice-versa. Make sure Airplane mode is off.
Microsoft account security info & verification codes
For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Learn how to manage your Microsoft account security info and troubleshoot verification code issues.
Applies To: Microsoft account dashboard
POP, IMAP, and SMTP settings for Outlook.com
If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App Light, New Outlook for Windows, Outlook for Android, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
How to sign in to or out of Outlook.com - Microsoft Support
If you can't sign in to your Outlook.com, Hotmail, Live, or MSN email account, or you're not sure how to sign in or sign out, here are some solutions.
Applies To: Outlook.com
Screen mirroring and projecting to your PC or wireless display
Cast to a display from a Windows PC. You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.
Finding your BitLocker recovery key in Windows - Microsoft Support
If your system is asking you for your BitLocker recovery key, the following information may help you locate your recovery key and understand why you're being asked to provide it. Important: Microsoft support is unable to provide, or recreate, a lost BitLocker recovery key.
Update drivers manually in Windows - Microsoft Support
Learn how to update drivers in Windows using Device Manager to update or reinstall a driver.
Using IF with AND, OR, and NOT functions in Excel
Following are examples of some common nested IF (AND ()), IF (OR ()) and IF (NOT ()) statements in Excel. The AND and OR functions can support up to 255 individual conditions, but it’s not good practice to use more than a few because complex, nested formulas can get very difficult to build, test and maintain.
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 Web App, Excel for Windows Phone 10
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
其实用查找函数很容易做到。. VLOOKUP 和 HLOOKUP 函数,以及 INDEX 和 MATCH 是 Excel 中一些最有用的函数。. 注意: Excel 中不再提供“查找向导”功能。. 下面是如何使用 VLOOKUP 的示例。. =VLOOKUP (B2,C2:E7,3,TRUE) 在此示例中,B2 是第一个 参数 ,即函数运行所需的数据元素 ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016