excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Natalie has attended:
Excel Advanced course
Access Intermediate course

Excel

Is it possible to set up data validation so that whatever case someone types information into a cell it automatically formats it to uppercase?

RE: Excel

You can use Excel's Data Validation tool to prevent the user from entering anything except text in the desired case. Select the range of cells to which you want to apply Validation, choose Validation from the Data menu and choose Custom from the Allow list. In the formula box, enter any one of the following formulas, depending on what case you want to allow. Change the reference from A1 to the address of the first cell in the selected range.

=EXACT(A1,UPPER(A1))
=EXACT(A1,LOWER(A1))
=EXACT(A1,PROPER(A1))

With this validation in place, the user can enter only upper, lower, or proper case.

Wed 10 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Server loaded in 0.14 secs.