Excel Tutorial: How To Make All Words Capital In Excel


When working with data in Excel, it can be important to ensure that all words are capitalized for consistency and readability. Whether you're creating a professional report or simply organizing a list, capitalizing all words can make your data look more polished and professional. In this tutorial, we'll walk through the steps to achieve this in Excel so you can easily apply this formatting to your own spreadsheets.

Key Takeaways

  • Capitalizing all words in Excel is important for consistency and readability in professional documents.
  • To achieve this in Excel, you can use the 'UPPER' function to easily capitalize all words in a selected text.
  • By following the outlined steps, you can quickly and efficiently apply proper capitalization to your data in Excel.
  • Proper capitalization can enhance the overall polished and professional look of your documents.
  • Always remember to review and save your document after capitalizing all words to preserve the changes.

Step 1: Open the Excel document

Before you can start making all words capital in Excel, you need to open the document you want to work on.

A. Navigate to the Excel file on your computer

First, locate the Excel file on your computer. This may be in your documents folder, on your desktop, or in another location where you have saved it.

B. Double click on the file to open it in Excel

Once you have found the file, double click on it to open it in Excel. This will allow you to access the content and begin making the necessary changes.

Step 2: Select the text

Once you have opened your Excel document, you will need to select the text that you want to capitalize. There are two methods to do this:

A. Click and drag to highlight the text you want to capitalize

You can simply click and drag your mouse over the text to highlight it. This is a quick and easy way to select specific words or phrases within your document.

B. Use the keyboard shortcut Ctrl + A to select all text in the document

If you want to capitalize all the words in your document, you can use the keyboard shortcut Ctrl + A to select all the text. This is a convenient way to ensure that every word in your document is capitalized.

Step 3: Use the 'UPPER' function

When you want to make all words in a cell capital in Excel, you can use the 'UPPER' function to achieve this. Here's how:

A. Type =UPPER( in an empty cell

Start by selecting an empty cell where you want the capitalized text to appear. Then, type =UPPER( in the cell.

B. Click and drag to highlight the text you want to capitalize

Next, click and drag to highlight the text that you want to capitalize. This could be a single word, a sentence, or an entire cell of text.

Step 4: Apply the function to all words

After selecting the text and using the PROPER function, the final step is to apply the function to all words in the selected range.

A. Close the parenthesis after the text is highlighted

Once you have highlighted the text and entered the PROPER function, make sure to close the parenthesis by typing a closing bracket).

B. Press Enter to apply the function and capitalize all words

After closing the parenthesis, simply press the Enter key on your keyboard. This will apply the PROPER function to the entire selected range, converting all the text to proper case with the first letter of each word capitalized.

Step 5: Review and save

After applying the capitalization formula to your words in Excel, it is essential to review the changes and save your document to preserve the new formatting.

A. Check that all words are now capitalized
  • Scroll through the document to ensure that every word is now capitalized.
  • Check for any missed words or errors in capitalization.
  • Make any necessary adjustments to the formatting.

B. Save the document to preserve the changes
  • Click on the "File" tab in the Excel menu.
  • Select "Save As" to save the document with a new file name, or "Save" to overwrite the existing file.
  • Choose the appropriate location to save the file.
  • Click "Save" to preserve the changes made to the document.


Recap the steps: To capitalize all words in Excel, simply use the =PROPER() function. First, select the cell where you want the capitalized text to appear. Then, enter =PROPER(CELL) and press Enter. This will automatically capitalize the first letter of each word in the selected cell.

Importance of proper capitalization: It is crucial to maintain proper capitalization in professional documents to convey professionalism and attention to detail. Whether it's a report, presentation, or email, using correct capitalization enhances the readability and overall impression of the document.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles