Excel Guides

Forcing Input to Uppercase in Excel

If you want to ensure that all data entered into a particular field in Excel is in uppercase, there are a couple of different ways that you can go about this. One option is to use the Data Validation feature to set up a rule that will automatically convert any text entered into uppercase. Another option is to use a macro to trap the KeyPress event and convert the character to uppercase before it is added to the cell.

Using Data Validation

To set up data validation so that all text entered into a cell is converted to uppercase, follow these steps:

  1. Select the cells that you want to apply data validation to.
  2. On the Data tab, in the Data Tools group, click Data Validation. The Data Validation dialog box appears.
  3. In the Allow list, click Custom. A formula appears in the Formula

    Move beyond 

    Excel

    Get started with Causal today.
    Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.