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.

Use PowerPoint in a web browser. If you have a Microsoft account (hotmail.com, outlook.com, live.com, msn.com) or a Microsoft 365 work or school account, you can view and edit a presentation for free in a web browser. Save the file to OneDrive or Dropbox and use PowerPoint for the web to open it. If you don't already have a Microsoft account ...

You can click each file to open the document and review it, or click the down arrow to the right of any file in the Document Recovery pane and then select one of the following, depending on the options you see: Open or View to review the file. Save As to save the file. Delete to delete the file. Close to close the file.

To upload files and folders with the OneDrive for iOS app. In the OneDrive app, tap at the top of the screen. Then tap to Take a photo, Scan a document, Create a folder or Upload a file or photo. OneDrive cannot upload photos optimized for iCloud. To disable optimization, tap Settings > iCloud > Photos and uncheck Optimize Storage.

Download Microsoft Defender on your devices either by: Scanning the following QR code. Searching for Microsoft Defender in your app store. Sharing with your devices, the following link: Copy link. We encourage you to install Microsoft Defender on at least five devices per person. Important: This article is about the Microsoft Defender app that ...

Windows 10. To show libraries in File Explorer, select the View tab, and then select Navigation pane > Show libraries. Show libraries in File Explorer.

Open the file you want to view. Click the title of your file and select Version history . Select a version to open it in a separate window. If you want to restore a previous version you've opened, select Restore. Important: If your experience looks different, select one of the tabs above to try the instructions for another version.

With a document open in an Office program, click File > Save As > OneDrive. If you haven’t signed in, do that now by clicking Sign In. Or if you haven’t signed up for a Microsoft account, click Sign up. After you sign up or sign in, save your document to OneDrive. Tip: To find your files later, just open the Office app you created the file ...