![]() ![]() We are going to make a drop-down list for Departments in my example. Image Gallery of Drop Down Validation List Below are examples of two drop-down lists I being used in the first two images, and image 3 shows the worksheet with the drop-down list. Someone using your worksheet clicks an arrow and then clicks an entry in the list. You can provide a more efficient worksheet by using drop-down lists in cells where people can make a Yes or No choice, or pick from another list you insert. ![]() One of the most common data validation uses is to create a drop-down list. When bad data is entered into Excel, here are features that don’t work correctly: Data validation keeps bad data from being entered. An example would be if you have a column for Departments, and someone puts in Accounting but another person types in Acct. You can use data validation to restrict the type of data or the values that users enter into a cell.
0 Comments
Leave a Reply. |