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
Restore deleted files or folders in OneDrive - Microsoft Support
If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin.. For info about restoring a SharePoint file or folder, see how to restore items from the SharePoint recycle bin.For info about restoring SharePoint files stored in OneDrive, see Restore a previous version of a file in OneDrive.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Manage devices used with your Microsoft account
Download Microsoft Edge, Microsoft Launcher, or Link to Windows from the Google Play Store and sign in with your Microsoft account.
Applies To:
Microsoft account dashboard
KB5012170: Security update for Secure Boot DBX
Issue. Next step. If BitLocker Group Policy Configure TPM platform validation profile for native UEFI firmware configurations is enabled and PCR7 is selected by policy, it may result in the update failing to install.. To view the PCR7 binding status, run the Microsoft System Information (Msinfo32.exe) tool with administrative permissions.
View hidden files and folders in Windows - Microsoft Support
Select the View tab and, in Advanced settings, select Show hidden files, folders, and drives and OK.
Insert ASCII or Unicode Latin-based symbols and characters
Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (ยบ) symbol, press and hold down ALT while typing 0176 on the numeric keypad.
Applies To:
Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Account has been locked - Microsoft Support
Why accounts are locked and disabled. Microsoft accounts are usually locked if the account holder has violated our Microsoft Services Agreement.Here are some common reasons why accounts are locked, though not all account locks occur for these reasons:
Photo viewer for Windows 10 - Microsoft Support
Windows Photo Viewer isn't part of Windows 10, but if you upgraded from Windows 7 or Windows 8.1, you might still have it. To check, press and hold (or right-click) a photo in File Explorer, and select Open with.If Windows Photo Viewer isn't in the list, you cannot install it on Windows 10.
Download printer drivers in Windows - Microsoft Support
Download printer drivers. If your printer isn't responding, you may need to remove it and reinstall it so Windows can download and install the proper drivers.
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