good, to confirm the operations you have performed. At this point, all you have to do is press the button. On the new screen you see, select the item list, using the menu allow and then type in the field the origin, the symbol =, followed by the group name of data that you created previously (for example, if you called the value group "group", you must write = group ). On the screen that appears, type the name you want to assign to the selected group of values, without entering any space, and then click the button good and alsoĪt this point select the cell (or cells) into which you want to insert your dropdown, go to the tab data Excel, up, and click the button Data validation. First, select with the mouse the cells that contain the values to be inserted in the drop-down menu (the values must be contained in the same column or in the same row and there must be no jumps between them), go to the tab formulas Excel you find at the top and click the button Define name. If, on the other hand, your intention is make a dropdown with Excel using the values already present in the spreadsheet, the operation to be performed is similar to that described above.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |