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
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
Keyboard shortcuts in Microsoft Edge - Microsoft Support
Press this key. To do this. Command + Shift + B. Show or hide the favorites bar. Command + Shift + C . Open Developer tools. Command + D. Save your current tab as a favorite. Command + Shift + D. Save all open tabs as favorites in a new folder
Windows 10 and Windows 11 in S mode FAQ - Microsoft Support
To increase security and performance, Windows 11 in S mode only runs apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, or if you have Windows 10 Pro, Enterprise, or Education and want to upgrade to Windows 11, you'll need to permanently switch out of S mode.
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
Show or hide the ribbon in Office - Microsoft Support
Choose an option for the ribbon: Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.. Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.. Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select the ellipsis (...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016
Use Immersive Reader in Microsoft Edge - Microsoft Support
Reading preferences in Immersive Reader In Reading preferences, you can turn on tools like Line focus to focus on reading one, three or five lines at a time, Picture dictionary to see a visual representation of a word, or Translate to change the language of the text.. Find these tools in Reading preferences on the Immersive Reader toolbar. Line focus: Line focus narrows the focus of your ...
Applies To: Microsoft Edge
Recover lost or deleted files - Microsoft Support
If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.
Create films with a video editor - Microsoft Support
For fast and simple editing, we've added Clipchamp as the official Microsoft video editor. Microsoft Clipchamp comes preinstalled on Windows 11 devices. To open Clipchamp, go to the search box on the taskbar, type Clipchamp, and select it from the results.Or you can select Start , then select All apps and scroll down to find Clipchamp in the list of apps.
Create a document - Microsoft Support
Click a template to see a preview. Click the arrows on the side of the preview to see more templates.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016