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.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create or edit a hyperlink - Microsoft Support
To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
Turn off Defender antivirus protection in Windows Security
Switch Real-time protection to Off.Note that scheduled scans will continue to run. However, files that are downloaded or installed will not be scanned until the next scheduled scan.
Change your background in Microsoft Teams meetings
If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.
Applies To: Microsoft Teams
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Compare Visio versions and features - Microsoft Support
See this page to try or buy one of the Visio subscription plans.. Feature comparison Collaboration and sharing. Save diagrams in the cloud, collaborate in Microsoft Teams, and work with others in a file at the same time.
Applies To: Visio Plan 2, Visio in Microsoft 365, Visio Plan 1, Visio Professional 2021, Visio Standard 2021, Visio Professional 2019, Visio Standard 2019, Visio Professional 2016, Visio Standard 2016, Visio 2013
Manage devices used with your Microsoft account
Download Microsoft Edge from the Apple App Store and sign in with your Microsoft account.
Applies To: Microsoft account dashboard
Set up auto-reply (out of office) - Microsoft Support
Notes: To set an automatic reply for contacts outside your company, select Outside My Organization > Auto-reply to people outside my organization, type in a message, and select OK.. The OK button may be missing because of certain screen solution and scaling settings. To resolve this issue, you can adjust the screen resolution and scaling settings, or use a large monitor.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Microsoft account security info & verification codes
Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).
Applies To: Microsoft account dashboard