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.

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

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.

Open the workbook that you want to change or remove the password for. On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet. To add a new password, click Protect Sheet or Protect Workbook, type and ...

About Microsoft Rewards status levels. Microsoft account. Microsoft Rewards has two status tiers: Level 1 and Level 2. Earn and keep Level 2 status by reaching 500 Microsoft Rewards points each month - no matter how you earn points, they all count toward your status. Level 2 members can earn five times more points on Bing.com, save up to 10% on ...

Getting the most out of your PC backup. When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier. Your Microsoft account ties everything together, no matter where you are or what ...

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

Once you've allowed microphone access to your apps, you can change the settings for each app. In Microphone settings, go to Choose which Microsoft apps can access your microphone, and turn on apps you want to use with it.For desktop apps, make sure that Allow desktop apps to access your microphone is turned on.

Check that the page shows the correct Microsoft account, and then click Next . Read the list and click the checkboxes to acknowledge you’ve read each item. Choose to have the re-open window set to 30 or 60 days. In the Select a reason drop-down list, choose an explanation for why you're closing the account. Click Mark account for closure .