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.

Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.

Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.

Unlinking and re-linking your computer to OneDrive can help solve some sync problems. You can also use these same steps to move your OneDrive to a new location, such as an external disk drive.

Under Ways to sign in , you have three choices to sign in with Windows Hello:. Select Facial recognition (Windows Hello) to set up facial recognition sign-in with your PC's infrared camera or an external infrared camera

Ensure these modes create an alert that is visible on your device. Make sure you have a device signal and Internet connection. Make sure your phone calls and text messages are getting through to your mobile device.

When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.

Install language accessory packs after installing Microsoft Office, to add additional display, help, or proofing tools. Install the language accessory pack for your desired language.

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.

Scan the page and save it on your computer in a common file format: .bmp, .jpg, or .png. For information on how to use your scanner, use the manufacturer’s manual or Web site.