gasrainspire.blogg.se - How to change case in word 2010

#How to change case in word 2010 how to#
#How to change case in word 2010 professional#

Replace XX with the cell location of the top cell in the column you want to convert. Step 2: Type =UPPER(XX) into the topmost empty cell, then press Enter on your keyboard. For example, if you wanted to convert cells A1-A5 to uppercase, then you would need a column with five empty cells. Step 2: Locate an empty group of cells in your spreadsheet that corresponds to the amount of cells containing text that you want to convert to uppercase. Step 1: Double-click the Excel file that contains the text that you want to convert.

#How to change case in word 2010 how to#

So follow the steps below to learn how to convert text in your spreadsheet to uppercase.

#How to change case in word 2010 professional#

In fact, you could make the argument that exclusive use of uppercase letters in Excel 2010 spreadsheets actually looks more professional than standard case usage. While capital letters and the upper case are poor practice in texting and other forms of written communication, they are useful when confined to situations where someone is not being addressed specifically.

Copy and paste the formula cell into each other cell in your column if you wish to make the rest of the cells in a column uppercase.Ĭonvert to All Capital Letters in Excel 2010.

Type the formula =UPPER(XX) but replace the XX with the cell location of the currently-lowercase text.

Click inside the cell where you want the uppercase text.

Quick Summary – How to Make All Text Uppercase in Excel So continue below to see the steps that you need to take to convert text in your worksheet from lowercase to uppercase. Using all uppercase case in Excel 2010 is a great way to make the letters stand out from the numbers and, in many situations, it simply makes the data in the spreadsheet easier to read. One of those times in when you are entering information into a spreadsheet. Then press “7” and then choose an option, such as “S” for Sentence case, “l” (a lowercase L) for lowercase, “U” for UPPERCASE, “C” for Capitalize Each Word, or “t” for tOGGLE cASE.Despite the annoyance that many people have for caps lock and people that write in all uppercase letters, it does have its’ place in certain situations. If you want to use your keyboard to change the case on some text, select the text and then press Alt+H to activate the Home tab. RELATED: How to Disable Automatic Capitalization Correction in Microsoft Word The selected text changes to the selected capitalization type. You can highlight the affected text and use the tOGGLE cASE option to correct the capitalization.įor our example, we’re going to make the selected text all caps, or UPPERCASE.

Toggle Case may seem like a strange option, but it’s useful if you’ve been typing text without realizing the Caps Lock key is on and the autocorrect option for correcting accidental usage of Caps Lock key is not on. tOGGLE cASE: This makes the first letter of every word lowercase and the rest of the letters UPPERCASE.Capitalize Each Word: Capitalizes the first letter of every word.UPPERCASE: Makes every letter UPPERCASE.lowercase: Makes every letter lowercase.Sentence case: Capitalizes the first letter of the first word in a sentence.The following types of capitalization are available:

Select the desired type of capitalization from the drop-down menu. Then, click the “Change Case” button on the Home tab. To change the case on text in a Word document, select the text you want to change and make sure the Home tab is active. Did you type a line of text and then realize that it should have been capitalized differently? Instead of typing the line again, you can quickly and easily change the case of any text in Word without retyping it.