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.

Important: Steps may be different between new and classic Outlook for Windows. To determine which version of Outlook you're using, look for File on the ribbon.If there's no File option, follow the steps under the New Outlook tab. If the File option appears, select the tab for Classic Outlook.

If you're running Windows 8.1 or earlier, or if your PC doesn't meet the minimum system requirements to run Windows 11, consider moving to a new Windows 11 device. Find a PC that meets your needs. Set up your Microsoft account to transfer files and favorites. One account connects your device across Microsoft apps and services like Microsoft 365, OneDrive, Edge, and Microsoft Store.

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.

Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.

In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.

A new tab to Sign in using your Yahoo account will open in your web browser. Follow the prompts to complete signing in, including any two-factor authentication prompts you set up for this account.

Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.

An upgrade differs from an update in that it moves your PC from a previous version of Windows—such as Windows 10—to Windows 11. This FAQ is intended to answer questions about upgrading to Windows 11.