|
Excel Tip - Create a list box for data
entry accuracy
A list
box makes it easier for Excel users to avoid errors. For
example, a State field requires users to know the two-letter
abbreviation for each state. To ensure accuracy, let users
select from a list.
To
create a list for the State field cells, follow these steps:
-
Select all the cells in the State column.
-
Go
to Data | Validation.
-
On
the Settings tab, select List from the Allow drop-down
list.
-
In
the Source text box, enter the allowable entries
separated by commas as follows: AR, TX, OK, LA, etc.
-
Select the In-cell Dropdown check box.
-
Click OK.
When
users move to a cell in the State column, Excel displays a
drop-down arrow. Clicking the arrow reveals a list of
allowable states users can select for that cell. If users
attempt to type an entry that's not on the list, Excel
displays an error message.
|
