Excel change any text entered to upper case

Ok, I see what you mean, you just want the individual cell to use the rule automatically without needing another cell to accomplish the goal.

After researching this, the only way I found to accomplish this is by using a font that contains no lower case version of the letters.

When you are browsing through your list of fonts, you can tell if a font is upper case only because the font name will be in all upper case letters.

Some of the supplied fonts in Microsoft Windows/Office that contain only upper case letters are:

Copperplate Gothic Engravers Felix Tilting Stencil

Locating a specific font for all for all your titles can be time consuming, especially if you must repeatedly scroll through long list of font choices.

A timesaving way to apply an ALL CAPS font to a cell is to utilize Cell Styles.

Cell Styles are located on the Home tab in the Styles group.

You have the option to use an existing style, create your own style and add it to the library, or modify an existing style.

If we wish to use the Heading 1 style, but we wish it to be in all upper case letters, right-click on the Heading 1 style and select Modify.

In the Style dialog box, click the Format button.

In the Format Cells dialog box, select the Font tab and set the font to the desired ALL CAPS font. You can also use this opportunity to set the font color, underline color, border color, etc…

We can now select a cell and type in our new title. Once entered, with the title cell selected, click the Heading 1 style from the Cell Styles list.

Yes, but that involves another column, as I siad, I was to enter eg "a" and have it automatically
become "A".

Thanks, I can't look into this right now but will let you know how I get on

Richard

No worries if you experience any problems please do not hesitate to contact me again,

Thanks,

Parth P.

Hello there Richard,

Sorry to hear you're experiencing issues with Excel and hope I can assist your issue as you can use a simple VBA (Visual Basic for Applications) macro to automatically convert any text entered into a cell to uppercase:

1. Press ALT + F11 to open the Visual Basic for Applications (VBA) editor. 2)In the VBA editor, click Insert in the menu and then select Module. This will insert a new module.
2. In the module window, paste the following code:

Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Me.UsedRange) Is Nothing Then Application.EnableEvents = False Target.Value = UCase(Target.Value) Application.EnableEvents = True End If End Sub

4. Close the VBA editor. Now, whenever you enter any text into a cell in the worksheet, it will automatically be converted to uppercase.

**PLEASE NOTE** -Please note that this code will affect all cells in the worksheet. If you want it to apply only to specific cells, you can adjust the range in the Intersect function accordingly.

Remember to save your workbook as a macro-enabled file (.xlsm) if you haven't already done so.

I hope this helps you and should you have anymore problems/concerns please do not hesitate to contact me again.

Thanks,

Parth P.