10/28/2023 0 Comments Drop down list in excel![]() ![]() On a new worksheet, enter the employee names in any manner desired. You can create this list almost anywhere, but for design purposes it is a good idea to put the list on a different worksheet than the one where the data entry will be.įor example, let's say that you want a list of employee names. Start by creating a list of the values that you want available in the drop-down list. Once the user makes a selection and moves to a different cell, the arrow for the drop-down list disappears. This list allows users to select the cell and then select from a list of pre-defined values for that cell. ![]() ![]() One of the really cool uses for the data validation feature in Excel is the ability to create a single-use drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |