Data Validation Drop Down List Propinsi Kota. We can also use drop down lists to create interactive reports and financial models where results change when the user changes a cell s value. Sebagai contoh silahkan buka sheet drop down 1 pada excel online.
On the dataentry sheet select cell c3. Creating a date drop down list is simple but effective as well. Data validation in excel is a useful feature that allows you to control the type of data that is going into the spreadsheet.
On the ribbon s data tab click data validation.
Buat drop down list manual. The data validation window will appear. Dropdown list bertingkat saat membuat dropdown list dengan fitur data validation ada kalanya kita ingin dropdown list untuk pilihan sel tersebut berubah secara otomatis menyesuaikan dengan isi data pada sel lainnya. First select the cell where we need to create a drop down list.
