Tip: Quickly change the text-case in all selected cells at once

Change all text to UPPERCASEIf you type a portion of your data in the wrong case, then you won't have to retype it.
If you received a workbook from others that is in the wrong case, then please remember that there is a quick way to correct this.

Save 5 minutes a day by using ASAP Utilities to quickly change the text-case.

Your text quickly to uppercase, lowercase, etc.?

You can easily change the text-case in the selected cells with the following tools:
ASAP Utilities »

  1. Text » Change to UPPERcase
  2. Text » Change to lowercase
  3. Text » Start first word with Uppercase
  4. Text » Make first character Uppercase, the rest lowercase
  5. Text » Start Each Word With Uppercase

Just select the cells and then start one of the text-tools:
Change text case quickly

For example, quickly change the text in the selected cells to uppercase:

Change all text to UPPERCASE

Just like in MS Word

In MS Word you can use the Shift+F3 key to change the case of the selected text.
But in Excel there is no such shortcut or option in the menu/ribbon (not even in the new Excel 2013. I don't know why Microsoft doesn't add it, many people have been asking for it. Even it's open source alternative, LibreOffice Calc has "Change Case" in its menu.)
The only way to change the case in Excel is to use an extra (helper) column with formulas and a copy/paste values or by using macros.
Fortunately you can also use an add-in such as ASAP Utilities to quickly change case. You can even assign your own shortcuts if you use the change case tools often.

Quick solution

Just select the cells and then choose one of the following tools in the Excel menu:
ASAP Utilities »

  1. Text » Change to UPPERcase
  2. Text » Change to lowercase
  3. Text » Start first word with Uppercase
  4. Text » Make first character Uppercase, the rest lowercase
  5. Text » Start Each Word With Uppercase

This is an easier and quicker alternative for the default method that Excel offers and Microsoft describes.

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on much you use Excel, the amount of data you're working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.

Download

In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for personal use, students and charitable organizations) or the fully functional 90-day business trial from:
http://www.asap-utilities.com/download-asap-utilities.php

3 Responses to “Tip: Quickly change the text-case in all selected cells at once”

  1. What's the difference between utilities 'Start first word with Uppercase' and 'Make first character Uppercase, the rest lowercase'?

  2. Now I get it, I think. If the original text is in Uppercase with the latter utility you can change every character but the first one to lower case in the text.
    So 'Start first word with Uppercase' utility is used to capitalize the first character when the text in question is in lower case and 'Make first character Uppercase, the rest lowercase' utility is used to capitalize the first character when the text in question is in Upper case.

  3. Hello Jaalku,

    Yes indeed, it depends on how the original data needs to be changed.

Pinterest