Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.

How to open PC Health Check. In Windows, use Search on the taskbar to search for “PC Health Check,” then select it from the list of results. If a PC Health Check update is available, you can quickly install it for the latest version. If you don't have PC Health Check installed, you can install it by going to https://aka.ms ...

Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, and then Data Validation. Note: If you can’t select Data Validation, the worksheet might be protected or shared. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again.

Generally, if you bought a physical copy of Windows, the product key should be on a label or card inside the box that Windows came in. If Windows came preinstalled on your PC, the product key should appear on a sticker on your device. If you’ve lost or can’t find the product key, contact the manufacturer. To ensure your product key is ...

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.

The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis ...

Use the Microsoft Wireless Display Adapter. Surface. The Microsoft Wireless Display Adapter is a strong, reliable way to project your content, photos, and videos to a big screen.

If you weren't able to change your password. If you couldn't change your password this way, see Reset your Microsoft account password. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.

First, insert a temporary column next to the column that contains the text you want to convert. In this case, we’ve added a new column (B) to the right of the Customer Name column. In cell B2, type =PROPER (A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type ...