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.

Under Microsoft Defender Firewall, switch the setting to On.If your device is connected to a network, network policy settings might prevent you from completing these steps. For more info, contact your administrator.

Press Ctrl + Alt + Delete to open Task Manager.If you don’t see Task Manager after pressing Ctrl + Alt + Delete, press Ctrl + Shift + Esc to open Task Manager.. If Task Manager flickers along with everything else on the screen, a display driver is probably causing the problem.

To help protect you and your recipients against computer viruses, Outlook blocks the sending and receiving of certain types of files (such as .exe and certain database files) as attachments. If you need to send one of these file types to an email recipient, we recommend using OneDrive and sending the recipient a link to the file instead.

When you check Outlook Desktop for the Teams Meeting Add-in by going to File > Options > Add-ins, then select Go next to COM Add-ins, the Teams Meeting Add-in is missing.

Learn how Smart charging in Windows can help your battery last longer over time.

Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.

Need the full set of Excel features? Open your file in the Excel desktop app one of two ways, depending on what you see in your workbook: Select Open in Desktop App at the top of your workbook.If you don't see it, there should be a search bar along the top of your workbook.

In the Display resolution row, select the list and choose an option.It's usually best to stick with the one that's marked (Recommended). Monitors can support resolutions that are lower than their native resolutions, but text won't look as sharp and the display might be small, centered on the screen, edged with black, or stretched.

A product key is a 25-character code that's used to activate Windows and helps verify that Windows hasn't been used on more PCs than the Microsoft Software License Terms allow.