Pick From Drop Down List Excel. On the settings tab in the allow box click list. Go to the data tab on the ribbon then click data validation.
On the settings tab in the allow box click list. On the second sheet type the items you want to appear in the drop down list. Now select the cell under sub category and just write the formula in data validation and click ok.
You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon menu.
On the settings tab in the allow box click list. Choose list option is allow and select the cells for main category names which in this case is at b2 and c2 cell month and week days as we can see a drop down list is created which asks the user to choose from the given option. In data tab under the data tools section click on data validation. In the data validation dialog under settings tab choose list from allow drop down list.
