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.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

A theme is a combination of desktop background pictures, window colors, and sounds. Get a theme. To get a theme, expand one of the categories below, select a link for the theme, and then select Open.This saves the theme to your PC and puts it on your desktop.

4. Select picture and select Insert. Inserting multiple pictures at once: Once you select the source where your picture is being inserted from, then select multiple pictures, then select Insert.. All selected images will be inserted within the workbook cells at once, starting from the active cell and down the column for as many cells as pictures selected, overwriting any values in those cells.

If you can't choose any of the menu options, type inside an email message, calendar event, or contact, Outlook may have frozen. There are three steps you can take to try to get Outlook working again. Check for other Outlook processes running. Occasionally, Outlook tries to run a process in the background. Auto-archive, sending and receiving a ...

To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.

Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.

For example, let’s say that you are editing a Word document on your device, but you aren't able to finish before you have to stop working for the day. If you turn on the Store my activity history on this device setting on the Activity history settings page, you will see that Word activity in your timeline the following day—and for the next ...

Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.

Note: The steps to install the 2019, 2016, or 2013 versions of Office Professional Plus, Office Standard, or a stand-alone app such as Word or Project might be different if you got Microsoft 365 through one of the following: Microsoft Workplace Discount Program (formerly known as Home Use Program): If you bought Microsoft 365 for personal use through your company, see Install Office through ...