أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
Now, cell B2 has a drop down list which shows the items names in A2:A6. As of now, we have a drop down list where you can select one item at a time.
Yes we can make a drop down list in excel. Here are the following steps : Add another column to the data which have formula to calculate the task period then choose data validation and choose list from the allow part, the select the range that contain your list items you want.
Copy paste to prescribed cell and shrink to fit
This is possible using Data Validation
you just select the cell you want
go to data tab
choose data validation
then choose list from the allow part, then select the range that contain your list items you want.
thank you for the question