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
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Add or manage an iCloud email account in Outlook
If prompted, enter your password. However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password.To obtain an app-password, do the following:
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Request a refund for digital games | Xbox Support
Refunds are typically issued for requests meeting the following criteria: Requests are made within 14 days of the purchase date; Requests are for games in which you haven’t accumulated a significant amount of play time
Add flair to your email with emojis - Microsoft Support
In the Windows emoji picker, you can either scroll through the list, use the category icons at the top or bottom of the emoji picker, or type a keyword to search for the emoji you want.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business
Add pictures or attach files to email messages in Outlook
In Outlook, you have the option to: Attach a file | Upload a locally saved file to your OneDrive | Insert a picture into the body of a message | Attach an email item | Solve problems with attachments. Attach a file to an email message in new Outlook. New Outlook keeps track of the files you have worked on recently and suggests them whenever you decide you want to attach a file to an email message.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Get to know Game Bar on Windows | Xbox Support
Find out how to use Game Bar to capture game play, chat with friends, track achievements, and more.
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To:
Office 2021, Office 2021 for Mac
How to close your Microsoft account - Microsoft Support
Note: If you forgot your account info and had to reset your security info, you must wait 60 days before closing your account.