![]() Click on the PrimaryList name, and click OK.Click in the Source box, and press the F3 key, to see a list of the names in the workbook.On the Excel Ribbon, click the Data tab.Next, select the cell(s) where you want the drop down list to appear Here is the name, “ PrimaryList“, being typed in the Name Box. Then, to name the list, select all the cells, click in the Name Box, type a one-word name “PrimaryList”, and press Enter.List the printers on a different sheet, in a single column.In this example, people will pick the name of the printers that they use in the office.įirst, create a list of printers for the drop down It’s easy to make a drop down list with Data Validation. Then, after you’ve made a basic list, experiment with fancier features, like hiding items that have been previously selected. ![]() It’s really easy to make a simple drop down. You can add a drop down list in a cell, to make it easy for people to enter data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |