Capitalize First Letters in Google Sheets

Edited by Djinu, VisiHow, Eng, Chirag Bhutani

You're watching VisiHow. In this video, we're going to show how to capitalize the first letter using Google Sheets. In this video, we have a list of names in column "A". They are typed in lowercase, but we want each word to start with a capital letter.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    Click the "B1" cell
    .
    Advertisement
    Was this step helpful? Yes | No| I need help
  2. 2
    Type "=proper(A1)"
    .
    Alternatively, instead of typing "A1", you can just click the "A1" cell.
    Advertisement
    Was this step helpful? Yes | No| I need help
  3. 3
    Next, press "Enter"
    .
    You'll see that the cell will have the capitalized text from the other cell.
    Was this step helpful? Yes | No| I need help
  4. 4
    If you want to fill the cells down, you can just click on the cell
    .
    Was this step helpful? Yes | No| I need help
  5. 5
    Then, double-click the cell or click and drag it by the corner to fill down
    .
    Was this step helpful? Yes | No| I need help

That was how to capitalize just the first letter for each word in cells using Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks again for watching VisiHow!

Was this helpful? Yes | No| I need help

Video: Capitalize First Letters in Google Sheets

Questions and Answers

Can you do this when the field is already occupied?

Trying to capitalize the first letter of every word on a sheet that's already complete

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Google

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 1,079 times.

x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No