# How To Make First Letter Capital In Excel?

The answer to the question How To Make First Letter Capital In Excel?, is pretty straightforward, our experts have explained this in the following steps.

Step 1. First, Click the cell where you want to make the change.

Step 2. Now, On the Home tab, in the Font group, click the small arrow next to the word Font.

Step 3. Now, In the Font dialog box, under Effects, select the Small Caps check box.

Step 4. Now, Click OK.

You May Also Like

How To Pass A Mouth Swab Drug Test For Amazon

How To Exit Fastboot Mode?

What Is Number Porting?

## Make First Letter Capital In Excel

To make the first letter of a cell capital in Excel, you can use the UPPER function; for example, if the cell contains the word “excel”, you can use the following formula: =UPPER(A1)

You May Also Like

How To Blow A Bubble With Gum

How To Fill Up A Bean Bag Chair?

How To Get Slime Out Of Hair

### How To Make First Letter Capital In Excel? [Video]:

We have found a great video explaining the question How To Make First Letter Capital In Excel?. This video was published by MJ Tube with the title Easy Way to Make First Letter Capital in MS Excel (Excel 2003-2019). Though it was published 3 years ago, it’s still really helpful.

There’s another video available on YouTube. This video was published by Chester Tugwell with the title Excel: Capitalize First Letter of Each Word in a Cell. This was uploaded 2 years ago, you can watch that too.

### Make First Letter Capital In Excel FAQ:

Here we are trying to cover as many related questions, so our users can get the maximum value from our platform. Here are some of the Make First Letter Capital In Excel associated questions. If you have any query related to Make First Letter Capital In Excel then feel free to contact us anytime.

#### 1. How do you make the first letter of a word capital in Excel?

The first letter of a word can be made capital in Excel by using the UPPER function. For example, if the word is “apple”, the UPPER function returns “apple”.

#### 2. How do you make the first letter of every word capital in Excel?

To capitalize the first letter of every word in a cell, you can use a simple formula: in the cell where you want to show the results, type =PROPER(). Then select the cell with the text you want to change and type a closing parenthesis.

#### 3. How do you make the first letter of a sentence capital in Excel?

In Excel, to make the first letter of a sentence capital, you can use the UPPER function. For example, if you have a cell with the text “This is a test”, you can use the following formula: =UPPER(A1). This will return “THIS IS A TEST.”

#### 4. How do you change the case of text in Excel?

To change the case of the text in Excel, you can use the UPPER, LOWER or PROPER functions; for example, if you have a column of text that contains both upper and lower case letters, you can use the UPPER function to convert the text into upper case.

#### 5. How do you convert all lowercase letters to uppercase in Excel?

To convert all lowercase letters in Excel into uppercase, you can use the UPPER function.

#### 6. How do you convert all uppercase letters to lowercase in Excel?

To convert all upper case letters in Excel to lowercase, use the LOWER function – this function converts all the letters in a given cell to lowercase.

#### 7. How do you title case text in Excel?

In Excel, you can use the PROPER function to title the text in a single line, which takes a string of text and capitalizes the first letter of each word in the string.

#### 8. What is the difference between uppercase and lowercase in Excel?

The main difference between uppercase and lowercase in Excel is that uppercase is used for writing header cells, lowercase is used for writing data cells, uppercase is also used for creating formulas and functions, while lowercase is used for writing data.

#### 9. How do you change the font case in Excel?

To change the font case in Excel, click on the Home tab and then click on the small arrow in the lower right corner of the Font section, which opens a menu with different options for changing the case of the selected text.

We hope you enjoyed watching/reading this solution. You can also visit our How To‘s section for more such useful content. If you have more questions related to this query this feel to contact us any time also don’t hesitate to ask for any query through our contact us form.

You May Also Like

How To Verify A Paypal Account?

How To Make Tree In Little Alchemy

How To Make Money On Onlyfans Without Showing Your Face