Jump to content

Increase data entry accuracy with drop down lists


Recommended Posts

Increase data entry accuracy with drop down lists

Giving users the option to select data from lists rather than type it manually can help eliminate many data entry errors. But you don't need to create the actual lists to ensure accuracy.

After users enter an item once, Excel automatically includes it in a drop-down list of entries that users previously typed in the column.

For example, to access the list of vendors previously typed in the Vendors column of an Orders spreadsheet, follow these steps:

1. Select the cell under the Vendors column for the next order.

2. Press [Alt] and the down arrow.

3. Select the vendor's name from the list, and press [Enter] or [Tab] to move to the next cell.

If the vendor's name is not on the list, users must type it manually. Excel will include the name the next time someone accesses the list.

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...