How to change case in Excel sheet?

30 June 2023By Dasha

Changing case in Excel seems to be not as easy as in Word files. The MS users try to find various methods to complete the task. However, it can be easier with a new feature added to ONLYOFFICE spreadsheet editor. Read this article to know how to change case in Excel sheets.

How to change case in Excel sheet?

Changing the case or capitalization in Excel can help bring the data in the cells into the same look. Since there is no function similar to Word, users follow several more complicated ways to do this:

  • Change the letters manually. The most obvious and at the same time the longest way is to change the letter case manually using the Shift key.
  • Use document editor functionality. You can copy the data you want to change the case of in the text editor and use the automatic function, and then add the data back to the table.
  • Add formulas. Formulas in Excel can replace this case-changing function, but require some additional knowledge. Let’s look at how to use the formulas below.

In addition to the methods listed above, there is probably the easiest way to change the case in Excel using the ONLYOFFICE spreadsheet editor.

How to change case in Excel sheet with ONLYOFFICE

Starting with version 7.4, the ONLYOFFICE spreadsheet editor gets the case change feature. This function serves as a full analog of the one in Word and makes it much easier to work with capitalization and changing the case of letters in cells.

The feature is available on the Home tab on the top toolbar.

How to change case in Excel sheet?

You can select one of the options from the drop-down list: Sentence case., lowercase, UPPERCASE, Capitalize Each Word, and tOOGLE cASE. Let’s look at each option in detail.

How to change case in Excel sheet?

How to capitalize the first letter of a sentence in Excel sheets?

To capitalize only the first letter of the sentence, use Sentence case. It capitalizes only the first letter of your phrase in the cell.

To do it, choose the cell or a group of cells where you want to capitalize the first letters. Then, click the Change case button and choose Sentence case.

How to change case in Excel sheet?

Alternatively, you can make the same using the Excel formula.

First of all, you need to insert an additional column where the results will appear. In our example, the column will be inserted between the columns Month and Quantity. Open the context menu by right-clicking any cell in the Quantity column.

In the context menu find Insert —> Column Left.

How to change case in Excel sheet?

Then, put the cursor into a cell in a new column and enter the following formula:

=REPLACE(LOWER(E2),1,1,UPPER(LEFT(E2,1))) 

where E2 is any cell with the phrase you want to capitalize the first letter in.

Do the same with the rest of the rows by dragging the little plus in the bottom right corner of the cell with the formula.

How to change case in Excel sheet?

How to make all the letters lowercase in Excel sheets?

To make all letters lowercase, use the appropriate option in the Change Case menu.

How to change case in Excel sheet?

To make letters lowercase with a formula, use the LOWER function. It is used to convert uppercase letters to lowercase in the selected cell.

Select the cell where you wish to display the result or insert a new one as described above. Then, go to the Formula tab at the top toolbar —> Text and data —> LOWER function.

How to change case in Excel sheet?

Enter the required argument in the appeared window. Click the OK button.

How to change case in Excel sheet?

How to capitalize all the letters?

Capitalized text in a table can be used to highlight the main point, draw attention, or improve the readability of the data in the table. If this is the case for you, use the UPPERCASE option in the dropdown list.

How to change case in Excel sheet?

If you need to capitalize all letters in the selected cell using a formula, choose the UPPER function in the Text and data group. Follow the same step described above to insert it.

How to change case in Excel sheet?

How to capitalize the first letter of each word?

Capitalizing the first letter of each word can make sense when you have names on your sheet. The easiest way to make sure they are all written correctly is to use Capitalize Each Word option.

Define cell range with names and go to the Home Tab  —> Change Case button  —> Capitalize Each Word.

How to change case in Excel sheet?

As for the formula, use the PROPER function. It is used to convert the first character of each word to uppercase and all the remaining characters to lowercase.

How to change case in Excel sheet?

Work on your spreadsheets with ONLYOFFICE

Try the functionality of the ONLYOFFICE spreadsheet editor to create and manage your data in tables. You can download free desktop editors for Windows, Linux, or macOS or store and edit your files in the cloud with ONLYOFFICE DocSpace:

GET DESKTOP APP                  START IN THE CLOUD

Create your free ONLYOFFICE account

View, edit and collaborate on docs, sheets, slides, forms, and PDF files online.