Type a series of text in a column. For example, you could enter a list of names, artists, food items—anything. The text you enter can be in any case, as the UPPERCASE or PROPER function will correct it later.
Insert a column to the right of your data. If there's already a blank column next to the column that contains your data, you can skip this step. Otherwise, right-click the column letter above your data column and select Insert. You can always remove this column later, so don't worry if it messes up the rest of your spreadsheet right now.
Click the first cell in your new column. This is the cell to the right of the first cell you want to capitalize.
Click fx. This is the function button just above your data. The Insert Function window will expand.
Select the Text category from the menu. This displays Excel functions that pertain to handling text.
Select UPPER from the list. This function converts all letters to uppercase. If you'd rather just capitalize the first character of each part of a name (or the first character of each word, if you're working with words), select PROPER instead. You could also use the LOWER function to convert all characters to lowercase.
Click OK. Now you'll see "UPPER()" appear in the cell you clicked earlier. The Function Arguments window will also appear.
Highlight the cells you want to make uppercase. If you want to make everything in the column uppercase, just click the column letter above your data. A dotted line will surround the selected cells, and you'll also see the range appear in the Function Arguments window. If you're using PROPER, select all of the cells you want to make proper case—the steps are the same no matter which function you're using.
Click OK. Now you'll see the uppercase version of the first cell in your data appear at the first cell of your new column.
Double-click the bottom-right corner of the cell that contains your formula. This is the cell at the top of the column you inserted. Once you double-click the dot at the bottom of this cell, the formula will propagate to the remaining cells in the column, displaying the uppercase versions of your original column data. If you have trouble double-clicking that bottom-right corner, you can also drag that corner all the way down the column until you've reached the end of your data.
Copy the contents of your new column. For example, if your new column (the one that contains the now-uppercase versions of your original data) is column B, you'll right-click the B above the column and select Copy.
Paste the values of the copied column over your original data. You'll need to use a feature called Paste Values, which is different than traditional pasting. This option will replace your original data with just the uppercase versions of each entry (not the formulas). Here's how to do it: Right-click the first cell in your original data. For example, if you started typing names or words into A1, you'd right-click A1. The Paste Values option might be in a different place, depending on your version of Excel. If you see a Paste Special menu, click that, select Values, and then click OK. If you see an icon with a clipboard that says "123," click that to paste the values. If you see a Paste menu, select that and click Values.
Delete the column you inserted. Now that you've pasted the uppercase versions of your original data over that data, you can delete the formula column without harm. To do so, right-click the letter above the column and click Delete.
Comments
0 comment