In Microsoft Word and Excel, how do you select a text range or cell and make all of the letter capitalized?

Answer 1

Excel does not have the formatting command which is in Word.

I had the need to do this. Fortunately, the file wasn't astronomically large.

To play it safe, in Excel, I copied the affected columns and pasted them into Word.

In Word:
Select the columns
click Format
cl Change Case
then choose

I then copied them back into Excel and deleted the unchanged columns.

Answer 2

It's a little trickier than Microsoft Word (which is simple) but it's still kind of easy. 1. Open up Excel 2. Press ALT+F11 This is to open up the code editor 3. Double Click Sheet 1 in the top left hand box 4. Copy the following code into the larger right hand box that pops up. ----- Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("B:B")) Is Nothing Then Application.EnableEvents = False Target.Value = Application.Proper$(Target.Value) Application.EnableEvents = True End If End Sub *** NOTE ABOUT THE CODE: Modify the second line of that code to represent the column or columns you are working with. For example, if your names are in column A, then change the second line to read, If Not Intersect(Target, Range("A:A")) Is Nothing Then ----- 5. Save the file. Go back into excel. Now every word you type into the column will capitalize automatically. EDIT: Also assuming you want to manipulate more than one column such as capatilizing the first letter of words entered into both column A and B use the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:A")) Is Nothing Then Application.EnableEvents = False Target.Value = Application.Proper$(Target.Value) Application.EnableEvents = True End If If Not Intersect(Target, Range("B:B")) Is Nothing Then Application.EnableEvents = False Target.Value = Application.Proper$(Target.Value) Application.EnableEvents = True End If End Sub ---- Keep adding to this code for all columns you wish to manipulate.

Answer 3

In Word, you can push the following keys at once: CTRL + A (Do not push the "+", just the other two). That will select all of the text you have typed. Or you can select some portion of the text by clicking with a mouse at the beginning and dragging your mouse till the end of text portion. Then, you push: Shift + F3. That will captitalize the selected text.

In Excel, do the following:

1) Select an empty cell
2) Type: = UPPER(A1), where A1 is the cell that contains the text to be capitalized. If it is some other cell, then enter that cell instead of A1.

Take care.

Answer 4

In WORD, highlight the text you want capitalized. Right click on that text. Select "fonts". In the pop-up window make sure you are in the "fonts" tab. Put a check mark in the ALL CAP box. OK out of the windows and your selected text should now be displayed in all capital letters.

Sorry, but I don't have an answer for you in EXCEL. I think what you type is what you get. Maybe someone else has the answer.

Good luck.