Create A Drop Down List in Excel 13 Έχουμε τη δυνατότητα να δημιουργήσουμε ένα φύλλο εργασίας πιο αποτελεσματικό με τη δημιουργία μιας Αναπτυσσόμενης Λίστας (Drop Down List) Ποια είναι η χρήση της Αναπτυσσόμενη Λίστα (Drop Down List);An Excel drop down list is a useful feature when you're creating data entry forms or Excel Dashboards It shows a list of items as a drop down in a cell, and the user can make a selection from the drop down This could be useful when you have a list of names, products, or regions that you often need to enter in a set of cellsSelect a cell in a blank sheet, here I select A1, and then Step 3 Create a Drop Down Now we can create the drop down Select the cell for your drop down, and select Data > Data Validation In the resulting Data Validation dialog, you want to Allow a List, and the Source is =SheetList (or whatever name you defined in the previous step), like this Note the equal sign = in front of the SheetList name
Create Drop Down Lists In Excel Easy To Follow Tutorial