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.

In the Settings app on your Windows device, select Accounts > Sign-in options or use the following shortcut: Sign-in options. 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.

To clear your TPM, follow these steps: Go to Start > Settings > Update & Security > Windows Security > Device security . Under Security processor, select Security processor details. Select Security processor troubleshooting, and then under Clear TPM, select Clear TPM. You'll need to restart your device to complete the process.

Here's more info on what permissions allow an app to do: Access all your files, peripheral devices, apps, programs, and registry: The app has the ability to read or write to all your files (including documents, pictures, and music) and registry settings, which allows the app to make changes to your computer and settings. It can use any peripheral devices that are either attached or part of ...

Help with BitLocker. Finding product keys for Windows and Office. Other support. Help with a work or school account password. I need to talk to a customer support agent. Learn how to get Microsoft account help, troubleshoot sign in issues, keep your account secure, and manage your Microsoft account dashboard.

The update history page will provide you with the build numbers for 22H2 and 23H2. This will make it easier for support to assist you if you encounter issues. This new update will be cumulative with all the newly announced features including Copilot in Windows (in preview) plus additional changes. Note Copilot in Windows will start to roll out ...

Select the Start  button, then select Settings . Select Personalization > Themes > Desktop icon settings. Select the Recycle Bin check box > Apply. To get to desktop icon settings in Windows 8.1, swipe in from the right edge of the screen, then select Search. Type desktop icons in the search box, and then select Show or hide common ...

You can delete specific files or photos on Microsoft OneDrive, or you can delete entire folders and all the items in them. If you need to, you might be able to restore deleted files from the OneDrive recycle bin. Windows macOS OneDrive website. On your taskbar, select File Explorer . Select your OneDrive folder, select the items you want to ...

The good news is you can probably free up a lot of space on your PC running Windows by following the tips here. But if you keep getting messages about low drive space, you might want to consider other options, including adding additional removable storage. To get the most out of these tips, do them in order from top to bottom.

While 32-bit applications can work with add-ins, they can use up a system's available virtual address space. With 64-bit apps, you have up to 128 TB of virtual address space which the app and any add-ins running the same process can share. With 32-bit apps, you might get as little as 2 GB of virtual address space which in many cases isn't ...