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
Capitalize first letters on Google Spreadsheets.mp4-canvas49 291996.jpg

Ad

Steps

  1. 1
    Click the "B1" cell
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas27 526287.jpg
    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.
    Capitalize first letters on Google Spreadsheets.mp4-canvas32 067997.jpg
    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.
    Capitalize first letters on Google Spreadsheets.mp4-canvas40 448996.jpg
    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
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas44 75644.jpg
    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
    .
    Capitalize first letters on Google Spreadsheets.mp4-canvas47 05644.jpg
    Was this step helpful? Yes | No| I need help
    Advertisement

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 928 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

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