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.

Firewall & network protection in Windows Security lets you view the status of Microsoft Defender Firewall and see what networks your device is connected to. You can turn Microsoft Defender Firewall on or off and access advanced Microsoft Defender Firewall options for the following network types: If you want to change a setting, select the ...

Go to the Windows 7 Service Pack 1 download page on the Microsoft website. Select the Download link that corresponds to your version of Windows 7. Select each of the download links and save them to your PC. When you're ready to install SP1, run the .exe file you downloaded from the site. Then follow the instructions to install SP1.

Turn on Windows backup. To turn on Windows backup and choose your backup settings, select Start > Settings > Accounts > Windows backup. Open Windows backup settings. The following items can be backed up: OneDrive folder syncing. Turn on OneDrive folder syncing to start backing up your files and folders right from Settings.

The transcribe feature converts speech to a text transcript with each speaker individually separated. After your conversation, interview, or meeting, you can revisit parts of the recording by playing back the timestamped audio and edit the transcription to make corrections. You can save the full transcript as a Word document or insert snippets ...

Select Start > Settings > Windows Update > Check for updates. If there is an available update, select Install now. Check for updates. Make sure that your app works with Windows 11. For more info, see Your app doesn't work with Windows. Update Microsoft Store. Select Start, then from the apps list, select Microsoft Store.

Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.

In OneDrive, right-click the file. Select a command. Select New > Folder. Type a name for the folder. Select Create. Looking for an older file? Search is a powerful tool to find all your online files. Type a word or phrase in the Search box. Select a file, or press Enter.

An upgrade can take place on your existing device, though Microsoft recommends using Windows 10 on a new PC to take advantage of the latest features and security improvements. This FAQ is intended to answer questions about upgrading to Windows 10. An update ensures you have the most recent features and security improvements for your current ...

On the PC you’re sharing from, select Start , and then select Settings > System > Nearby sharing .Choose whether you’d like to be able to share and receive files with everyone, or only your own devices (where you are logged in with your Microsoft account).