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
OneDrive release notes - Microsoft Support
Learn about the latest feature updates and bug fixes for the OneDrive sync app across all devices.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, OneDrive (work or school), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Create and share news on your SharePoint sites
Organization news. News can come from many different sites. but there might be "official" or "authoritative" sites for organization news. News from these sites are distinguished by a color block on the title as a visual cue, and are interleaved throughout all news posts displayed for users on the SharePoint start page.
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams
About the Microsoft Support and Recovery Assistant
Learn how to download Microsoft Support and Recovery Assistant to help fix problems with Microsoft 365, Office, or Outlook.
Applies To:
Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Print in Microsoft Edge - Microsoft Support
Learn more about how to print web pages and documents in Microsoft Edge.
Fix problems with apps from Microsoft Store - Microsoft Support
Get troubleshooting tips to fix problems with apps from Microsoft Store.
Insert or delete rows and columns - Microsoft Support
You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Set up your Microsoft 365 sign-in for multi-factor authentication
Learn how to set up your user account for multifactor authentication with Microsoft 365.
Applies To:
Office for business, Microsoft 365 admin
How to use Surface UEFI - Microsoft Support
Learn about Unified Extensible Firmware Interface (UEFI) features and how to access them on Surface Pro 4, Surface Book, and Surface Studio.