You can always remove this column later, so don’t worry if it messes up the rest of your spreadsheet right now.
You can always remove this column later, so don’t worry if it messes up the rest of your spreadsheet right now.
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.
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.
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.
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.
