how to create drop down menu in excel 2016

This allows you to select a product category from the main menu drop-down list box (such as Beverages), then display all the related products from the submenu (dependent) drop-down list box (such as Apple Juice, Coffee, etc.). This is especially useful for fields that require specific information fields that have long or complex data that’s hard to spell or fields where you want to control the responses.Ĭreating dependent drop-down lists (when combined with an INDIRECT function) is another benefit. I do not get any error messages it seems the drop down list for Column B is not transferring over.Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. I try Product Hardware, and again the drop down menu will not open. There is an arrow, but my selections will not open.

So i click lets say Service in column A, i go to column B, the drop down menu will no open. I pick Top row only since that is how my list is set up. I then go to formula and create from Selection. However, in the data validation under 'source' i use the formula =INDIRECT(A1)+Sheet2!$A$2:$D$23 and click ok. I am doing the same thing as i have while creating the drop down menu in column A. So if you choose one of the options in Column A, then you'll have different options to chose from in column B. So i want to create a Second drop down menu in Column B (sub cat its labeled). Click Source, go to my list and highlight the four Categories, click Ok.

Lets say the Categories are Product Hardare, Product Software, Service, and Policy. I have seen people ask this question on the Youtube videos to no replay. i have been searching over youtube and google but cannot find how to fix an error.

So i am creating a spreadsheet and using drop down menus using data validation.

How to create drop down menu in excel 2016