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.

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.

We would like to show you a description here but the site won’t allow us.

Click Save to save the console update.zip file to your computer.; Unzip the file by right-clicking on the file and selecting Extract all from the pop-up menu.

Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the caption have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.

Free. A Free badge means an active Microsoft 365 Family or Personal subscription isn't associated with the account you signed in with. Only the free web versions of Word, Excel, and PowerPoint are available to you. To access these apps in your browser, all you need to do is to sign in to Microsoft365.com with your Microsoft account and select the app you need from the app launcher .

The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.

Leave your Android device in your pocket the next time it rings — pick up the call from your PC instead. Calling requires Bluetooth capability on both your PC and on your Android device, so make sure you have it turned on for both.

Option. Description. Microsoft Exchange Server. If Outlook cannot automatically detect your Exchange server, you can enter its address here. To find out the name of your Exchange server, you have to contact the person who gave you the email address, or contact someone in your IT department, for the name of your Exchange server.