Making a drop-down-menu in Excel is fairly easy (and with drop-down-menu I mean in this case a cell with a number of preset options that you can choose from).
Let's say you hae a game with 10 classes you can choose from. Create a new sheet (I usually create separate sheets for look-up-tables etc). Enter the names of the classes in a column, one class/ cell. Then select the cells and give them a name (as described in the previous tip).
Then go back to the first sheet and select the cell where you want the drop-down menu to be, and then go to Data - Data Verification. Choose "List" from the combo-box, and then enter the name you gave your list in the previous step. Finish with clicking OK.
If all went well, you should now be able to click on the cell and then get a nice drop-down-menu with all the classes.
No comments:
Post a Comment