Excel Tutorial: How To Make All Capital Letters In Excel


Formatting text in Excel is crucial for creating professional and polished spreadsheets. Whether you're creating a report, a budget, or any other type of document, it's important to have consistent and uniform formatting throughout. One important aspect of formatting text is converting it to uppercase for consistency and clarity.

Overview of the steps to make all capital letters in Excel

  • Select the cells you want to convert to uppercase
  • Go to the 'Home' tab on the ribbon
  • Click on the 'Change Case' button in the 'Font' group
  • Select 'UPPERCASE' from the dropdown menu
  • Alternatively, you can use the formula =UPPER() to convert text to uppercase

Key Takeaways

  • Consistent and uniform formatting is crucial for professional spreadsheets in Excel.
  • Using the UPPER function is an easy way to convert text to uppercase in Excel.
  • Applying changes as values and checking for errors ensures the accuracy of the text conversion process.
  • Saving the file with the new formatting and proper organization is important for future use.
  • Proper text formatting is essential for clarity and professionalism in documents.

Step 1: Selecting the text to be converted

Before converting text to all capital letters in Excel, you need to select the cells or range of cells containing the text.

A. How to choose the cells or range of cells containing the text

To select a single cell, simply click on the cell with the text you want to convert. If you want to select a range of cells, click and drag your mouse to highlight the desired cells.

B. Using the Ctrl key to select multiple non-adjacent cells

If you need to select multiple non-adjacent cells, hold down the Ctrl key while clicking on each individual cell. This will allow you to select multiple cells scattered throughout the worksheet.

Step 2: Using the UPPER function

A. Explanation of the UPPER function in Excel

The UPPER function in Excel is a useful tool that allows you to convert any text to uppercase. This means that all lowercase letters in a cell will be automatically converted to uppercase, while any existing uppercase letters will remain unchanged.

B. How to enter the UPPER function into a cell

To use the UPPER function, you will need to enter it into a cell where you want the text to be converted to uppercase. Here’s how to do it:

  • Select the cell where you want the converted text to appear.
  • Type the following formula into the cell: =UPPER(A1), where “A1” is the reference to the cell containing the text you want to convert to uppercase.
  • Press Enter, and the text in the selected cell will be converted to uppercase.

Step 3: Applying the changes to the entire selection

After converting the text to all capital letters using the formula in Step 2, you may want to apply the changes to multiple cells or the entire selection in your Excel worksheet. Here are two methods to accomplish this:

A. Using the fill handle to apply the formula to multiple cells
  • Select the cell containing the text that has been converted to all capital letters.

  • Position the cursor over the bottom-right corner of the selected cell until it turns into a black plus sign, also known as the fill handle.

  • Click and drag the fill handle over the range of cells to which you want to apply the changes, and release the mouse button.

B. Using the paste special function to apply the changes as values
  • Select the cell containing the text that has been converted to all capital letters.

  • Right-click on the selected cell and choose "Copy" from the context menu, or press Ctrl + C on your keyboard to copy the cell.

  • Select the range of cells where you want to apply the changes.

  • Right-click on the selected range of cells and choose "Paste Special" from the context menu.

  • In the "Paste Special" dialog box, select "Values" and click "OK" to apply the changes as values to the selected range of cells.

Step 4: Checking for any errors

Once you have completed the process of converting all text to capital letters in Excel, it is important to verify that there are no errors and to troubleshoot any issues that may have arisen.

A. How to verify that all the text has been converted to capital letters
  • Manually review the text

    One way to verify that all text has been converted to capital letters is to manually review the entire document. Scroll through each cell and visually check to ensure that all text is in capital letters.

  • Utilize Excel functions

    You can also use Excel functions to check for any lowercase letters that may have been missed during the conversion process. The LOWER function can be applied to each cell to identify any instances where lowercase letters are present.

B. Troubleshooting any issues with the conversion process
  • Check for mixed data types

    If you notice that certain cells still contain lowercase letters, it is possible that there are mixed data types within the cell. This can occur when the cell contains a combination of text and numbers, or when special characters are present. Identify and separate these mixed data types to ensure proper capitalization.

  • Verify the formula used for conversion

    Double-check the formula or method that was used to convert the text to capital letters. Ensure that there are no errors in the formula and that it is being applied correctly to all cells. If necessary, troubleshoot and modify the formula to address any issues.

  • Consult Excel resources

    If you encounter persistent issues with the conversion process, consider consulting Excel resources such as forums, tutorials, or support documentation. Other Excel users may have encountered similar problems and can provide guidance on troubleshooting the specific issue.

Step 5: Saving the changes

Once you have successfully converted all the text to capital letters, the next step is to save the Excel file with the new formatting.

A. How to save the Excel file with the new formatting

After making the necessary changes, go to the "File" menu and select "Save" to save the file with the new formatting. You can also use the shortcut Ctrl + S to quickly save the changes. It is important to note that the changes are being saved in the same file, so make sure to save a copy if you want to keep the original formatting as well.

B. Best practices for naming and organizing the file

When saving the file, it is advisable to use a descriptive and meaningful file name that reflects the content of the spreadsheet. This will make it easier to locate the file in the future. Additionally, consider organizing your files into relevant folders to maintain a well-structured filing system. This will help you access the files quickly and efficiently.


Recap: To make all capital letters in Excel, simply use the =UPPER() function to convert the text to uppercase. This can be done by entering the formula =UPPER(cell reference) into a new cell, replacing "cell reference" with the specific cell you want to convert.

Importance: Proper text formatting is crucial in professional documents as it enhances readability and professionalism. Using all capital letters where appropriate can help emphasize important information and create a polished final product.

Try out these steps in your next Excel document to ensure a clean and professional look!

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles