How to Change from Lowercase to Uppercase in Excel

Microsoft’s Excel spreadsheet program has several functions to make your text type-case consistent. If you have a series of names that is in the lowercase, you can use “flash fill” function to capitalize names in Excel 2013. If you need all the text to be uppercase, you can use UPPER function to capitalize all the letters or PROPER to capitalize the first letter.

Steps Edit

Method One of Four:

Using the Uppercase Function Edit

Method Two of Four:

Using the Proper Name Function Edit

Method Three of Four:

Using Flash Fill in Excel 2013 Edit

Method Four of Four:

Community Q&A

• You can't use caps lock on some operating systems; try using the uppercase button

• Yes, you can do this by selecting the entire sheet then specifying you want it to be uppercase.

Video Edit

Things You'll Need Edit

Related wikiHows

Make a Spreadsheet in Excel

Make a Bar Graph in Excel

Prepare Amortization Schedule in Excel

Convert Excel to PDF

Subtract in Excel

Run a Multiple Regression in Excel

Create a Histogram in Excel

Create a Database from an Excel Spreadsheet

Calculate Mean and Standard Deviation With Excel 2007