XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a 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
Unlicensed Product and activation errors in Office
If Office activation fails, you'll see Unlicensed Product or Non-commercial use / Unlicensed Product in the title bar of your Office apps, and most features of Office are disabled. To restore all features of Office, you'll need to fix the problem that's causing activation to fail.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, InfoPath 2013
Save a Word document as a template - Microsoft Support
Whether you’re starting from a Microsoft template or updating one of your own, Word's built-in tools help you update templates to suit your needs. To update your template, open the file, make the changes you want, and then save the template. In Microsoft Word, you can create a template by saving a document as a .dotx file, .dot file, or a .dotm fie (a .dotm file type allows you to enable ...
Applies To:
Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Change default programs in Windows - Microsoft Support
Use Settings in Windows 10 to change default apps and programs.
Change your background in Microsoft Teams meetings
Explore tips to change your Microsoft Teams background. Learn how to replace, blur, or change your Teams background image before or during a meeting.
Applies To:
Microsoft Teams
Windows activity history and your privacy - Microsoft Support
Find out how Microsoft uses activity history data to provide personalized cross-device experiences and to help improve its products and services.
Applies To:
Microsoft account dashboard
Shut down, sleep, or hibernate your PC - Microsoft Support
Learn how to shut down, sleep, or hibernate your PC. When you’re ready to make your PC sleep, just press the power button on your desktop, tablet, or laptop, or close your laptop’s lid.
Fix USB-C problems in Windows - Microsoft Support
Learn how to troubleshoot USB-C problems in Windows and fix USB devices, ports, and adapters not working properly.
Microsoft account security info & verification codes
Find out how to set up and manage your security info and verification codes for your Microsoft account, and troubleshoot common issues.
Applies To:
Microsoft account dashboard
Dark Mode in Outlook - Microsoft Support
In Outlook, the black color theme includes dark mode, which provides a black background (instead of white) for the message window. You can switch to a white background for the message window if you prefer.
Applies To:
Outlook for Microsoft 365, Outlook on the web, Outlook.com