Excel shortcuts

How to Use the Excel All Caps Shortcut

If you work with data in Microsoft Excel, you may find yourself needing to convert text to all uppercase letters. For example, you may have a list of names that you need to convert to uppercase, or you may need to convert all the text in a cell to uppercase. There are a few different ways that you can convert text to all uppercase letters in Excel.

One way to convert text to all uppercase letters is to use the Upper function. To use the Upper function, you will need to enter the following into a cell:

=UPPER(text)

Replace "text" with the cell reference that contains the text that you want to convert to uppercase. For example, if the text is in cell A1, you would enter the following into the cell where you want the converted text to appear:

=UPPER(A1)

You can also use the Lower function to convert text to all lowercase letters. To use the Lower function, you will need to enter the following into a cell:

=LOWER(text)

Replace "text" with the cell reference that contains the text that you want to convert to lowercase. For example, if the text is in cell A1, you would enter the following into the cell where you want the converted text to appear:

=LOWER(A1)

You can also use the Proper function to convert text to proper case. Proper case means that the first letter of each word is capitalized and all other letters are lowercase. To use the Proper function, you will need to enter the following into a cell:

=PROPER(text)

Replace "text" with the cell reference that contains the text that you want to convert to proper case. For example, if the text is in cell A1, you would enter the following into the cell where you want the converted text to appear:

=PROPER(A1)

If you want to convert text to all uppercase letters, but you don't want to use a function, you can use the All Caps shortcut. To use the All Caps shortcut, select the cells that you want to convert to all uppercase letters. Then, press the Ctrl + Shift + U keys on your keyboard. The text in the selected cells will be converted to all uppercase letters.

You can also use the Format Cells dialog box to convert text to all uppercase letters. To use the Format Cells dialog box, select the cells that you want to convert to all uppercase letters. Then, click the Home tab on the ribbon and click the Format button. In the Format Cells dialog box, click the Text button. Then, click the OK button. The text in the selected cells will be converted to all uppercase letters.

You can also use the AutoCorrect feature to convert text to all uppercase letters. To use the AutoCorrect feature, select the cells that you want to convert to all uppercase letters. Then, click the File tab on the ribbon and click the Options button. In the Excel Options dialog box, click the Proofing button. In the Proofing tab, click the AutoCorrect Options button. In the AutoCorrect dialog box, click the AutoCorrect tab. Then, select the Capitalize first letter of sentences and Capitalize first letter of table cells check boxes. Click the OK button. The text in the selected cells will be converted to all uppercase letters.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.