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.

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.

Tip: If your can't get the code by email or phone, you might be able to enter an email address that's different from the one you're trying to recover. Go to the Recover your account page and follow the prompts.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Under Edit signature, compose your signature.You can change fonts, font colors, and sizes, as well as text alignment. If you want to create a more robust signature with bullets, tables, or borders, use Word to create and format your signature text, then copy and paste it into the Edit signature box.You can also use a pre-designed template to create your signature.

Troubleshoot issues that occur when setting up external monitors. If you are trying to set up an external monitor and it’s not working, press the Windows logo key + P to make sure that the Extend option is selected. If the Extend option is selected, try the following troubleshooting tips.

Learn how to use Remote Desktop in Windows. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.

To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.

The FILTER function allows you to filter a range of data based on criteria you define.

Adding Emojis to your conversation. Below the message box are three buttons to help you insert content into your message. The emoji button opens menus where you can quickly search for what you want.