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.

Under PC settings, tap or click Update and recovery, and then tap or click Recovery. Under Advanced startup, tap or click Restart now. Once your PC restarts, on the Choose an option screen, tap or click Troubleshoot. If you don't see the Startup Settings option, tap or click Advanced options. Tap or click Startup Settings and then Restart.

Manage drive space with Storage Sense. Windows 11 Windows 10. Windows 11 Windows 10. Storage Sense can automatically free up drive space for you by getting rid of items that you don't need, like temporary files and items in your Recycle Bin. Here’s more info on how it works and how to set it up to meet your needs.

Change your screen saver settings. Windows 10. Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings. In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings.

These suggestions are listed in order, so start with the first one, see if that helps, and then continue to the next one if it doesn't. To check the total disk space left on your Windows 11 device, select File Explorer from the taskbar, and then select This PC on the left. The available space on your drive will appear under Devices and drives.

Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar. If the app is already open on the desktop, press and hold (or right click) the app's taskbar icon, and then select Pin to taskbar. Note: To remove a pinned app from the taskbar, right-click the app icon, then select Unpin from taskbar.

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.

For more information see How to back up and restore the registry in Windows. There are two ways to open Registry Editor in Windows 10: In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results. Right-click Start , then select Run. Type regedit in the Open: box, and then select OK.

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 ...

Windows 10. Optimizing your drives can help your PC run smoother and boot up faster. To optimize them: Select the search bar on the taskbar and enter defrag. Select Defragment and Optimize Drives. Select the disk drive you want to optimize. Select the Optimize button.