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 =LOWER (A2) instead. Use =UPPER (A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. Now, fill down the formula in the new column.

To sign out, go to Outlook.com. Select your account initials or account picture at the top corner of your Inbox. Select Sign out. Tips: If you don't see your picture at the top of screen, check to see if ad blocking is turned on. Sometimes this prevents the picture from showing. If you don't see see Profile or Account options, you can access ...

Update Windows. In Windows 11, you decide when and how to get the latest updates to keep your device running smoothly and securely. To manage your options and see available updates, select Check for Windows updates. Or select Start > Settings > Windows Update . Here's some other info you might be looking for:

Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns. Select the third column. Select View > Freeze Panes > Freeze Panes. Freeze columns and rows. Select the cell below the rows and to the right of the columns you want to keep ...

AutoArchive helps manage the space in your mailbox or on the e-mail server that you are using by automatically moving items to an archive location. Depending on the options, AutoArchive completes one or both of the following actions: Moves items from their original location, generally one of your active folders, to an archive folder.

On your taskbar, select the Network, Volume, Battery icon > VPN. From the list of VPN connection names, select the one you want, and then select Connect. If prompted, enter your username and password or other sign in info. Connect to a VPN from the Windows Settings page: Select Start > Settings > Network & internet > VPN .

Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge. For example, to address readers by their first name in your document, you'll need separate columns for first and last names. All data to be merged is present in the first ...

Set up your password reset verification method. Open the web browser on your device and go to the Security info page. Depending on how your administrator has set up your organization, one or more of the following options will be available for you to set up as your security verification method. If multiple options are available, we strongly ...

Choose a display option. To change what shows on your displays, press Windows logo key + P. Here's what you can choose. See things on one display only. See the same thing on all your displays. See your desktop across multiple screens. When you have displays extended, you can move items between the two screens.

Recover items from your Deleted Items or Junk Email folders in new Outlook. Select the Deleted Items or Junk Email folder. If folders are hidden, select the Show Navigation Pane icon. Select the item or items you'd like to recover by hovering over the item and selecting the checkbox next to it. On the Home tab of the ribbon, select Move .