Jump to content

Create a list box to ensure data entry accuracy


Recommended Posts

Create a list box to ensure 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.

Follow these steps to create a list for the State field cells:

1. Select all the cells in the State column.

2. Go to Data | Validation.

3. On the Settings tab, select List from the Allow drop-down list.

4. In the Source text box, enter the allowable entries separated by commas as follows: NJ, NY, PA, DE, etc.

5. Select the In-cell Dropdown check box.

6. Click OK.

When users move to a cell in the State column, a drop-down arrow displays. 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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...